What is connection pooling? What Method and class used for
Connection pooling in Java?
- 2 Answers
- 6856 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / qim2010
Connection pooling is the maintenance of a group of database
connections for reuse by applications on an application
server thus cutting down substantially on the number of new
connections that need to be created. It is part of the JDBC
2.0 Optional Package API. Another part of the Optional
Package API provides for the use of the Java Naming and
Directory Interface (JNDI) and DataSource objects instead of
JDBC 1.0 DriverManager objects to access relational data.
Connections made via a DataSource object that is implemented
to work with a middle tier connection pool manager will
participate in connection pooling. This can improve
performance dramatically because creating new connections is
very expensive.
Connection pooling is totally transparent. It is done
automatically in the middle tier of a J2EE configuration, so
from an application's viewpoint, no change in code is
required. An application simply uses the
DataSource.getConnection method to get the pooled connection
and uses it the same way it uses any Connection object.
The classes and interfaces used for connection pooling are:
ConnectionPoolDataSource
PooledConnection
ConnectionEvent
ConnectionEventListener
The connection pool manager, a facility in the middle tier
of a three-tier architecture, uses these classes and
interfaces behind the scenes. When a
ConnectionPoolDataSource object is called on to create a
PooledConnection object, the connection pool manager will
register as a ConnectionEventListener object with the new
PooledConnection object. When the connection is closed or
there is an error, the connection pool manager (being a
listener) gets a notification that includes a
ConnectionEvent object.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / krishna priya
Connection pool is pool of connections where we can get ready made connections instead of creating every time. After using this connection object from pool these are replaced.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are static and dynamic queries?
Explain the difference between resultset and rowset in jdbc
Where is mysql jdbc driver located?
Does the JDBC-ODBC Bridge work with Microsoft J++?
Explain how data flows from view to db and reverse
How do I find whether a parameter exists in the request object?
what are the types of result sets in JDBC 3.0 ?
Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?
How are jdbc statements used?
What is the return type of execute, executequery and executeupdate?
What are different parts of a url?
can we define indexes on a foreign key? Explain pros and cons?
Core Java 
