Answer Posted / dinesh
Connection pooling whic h use to Reuse the Connection
resource.To Avoid wastage of connection resources,So you
don't need to have new connection ,Instead of creating new
connection,You can use the connection from connection pool
resource
A database driver may contain a connection pool as part of
its services, through its implementation of the
javax.sql.DataSource interface. DataSource objects are used
with JNDI.
With example:
import java.sql.*;
import java.util.*;
import org.w3c.dom.*;
import DBConnectionManager;
public class XSQL {
static DBBroker pool = DBBroker.getInstance();
// <---- Pool code!
public static Element executeQuery(
String connectionName,
String statementId,
String statementText,
Document factory
)
throws SQLException
{
Connection connection = null;
DBConnection db = null;
// <---- Pool code!
try {
db = pool.getConnection(connectionName);
// <---- Pool code!
connection = db.getConnection();
// <---- Pool code!
Statement statement = connection.createStatement();
ResultSet resultSet =
statement.executeQuery(statementText);
ResultSetMetaData metaData = resultSet.getMetaData();
int columnCount = metaData.getColumnCount();
Element rowSet = factory.createElement("xsql:rowset");
rowSet.setAttribute("id", statementId);
for (int i = 0; resultSet.next(); i++) {
Element row = factory.createElement("xsql:row");
row.setAttribute("sequence", String.valueOf(i + 1));
rowSet.appendChild(row);
for (int j = 0; j < columnCount; j++) {
String value = resultSet.getString(j + 1);
Element element = factory.createElement(
metaData.getColumnLabel(j + 1).toLowerCase()
);
row.appendChild(element);
if (value != null) {
element.appendChild(
factory.createTextNode(value)
);
}
}
}
resultSet.close();
statement.close();
return rowSet;
} catch (SQLException e) {
throw(new SQLException(statementText));
} finally {
if (connection != null) {
pool.releaseConnection(db); // <---- Pool code!
}
}
}
}
If u r not understand the code,If ur the beginners that
prespective to
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzaha/poolnods.htm
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of StringTokenizer class?
What is the inheritance?
What is the size of a string in java?
How do you use find and replace?
Explain where variables are created in memory?
Is an object null?
What is array length?
What is the best definition for data?
Is string is a data type in java?
Explain the polymorphism principle?
What is Java Annotations?
How to make a read-only class in java?
Tell some latest versions in JAVA related areas?
What is preflight request?
What is a website container?