what is connection pooling with example?
Answers were Sorted based on User's Feedback
Answer / rakesh
Connection pooling means that connections are reused rather
than created each time a connection is requested. To
facilitate connection reuse, a memory cache of database
connections, called a connection pool, is maintained by a
connection pooling module as a layer on top of any standard
JDBC driver product.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / 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 |
Answer / venkat
if we are using connection pooling , we can interact
database only once ,then we can place some area, then we
can reuse .
example
if we take in hibernate Ex: c3po,proxy.
these are setting to the configuration file.
Is This Answer Correct ? | 1 Yes | 2 No |
what are the application of compiler and interpreter for source program
Name the package that always imported by default?
What is a JAR file?
Does java map allow duplicates?
What are 4 pillers of object orinted programming?
what is web.xml?and its use?
methods in Applet?
What is continuity of a function?
Can we sort hashmap in java?
How hashmap increases its size in java?
What are 3 data types?
What is the return type of the main method?