connection pooling 1 Answer(s) 5 years and a month ago
Posted in : JDBC
July 30, 2009 at 3:59 PM
A connection pool is a cache of database connections maintained by the database. This results connections can be reused when the database receives future requests for data. It is used to increase the performance of executing commands on a database. It open and maintain a database connection for each user.
In JDBC connection pool, a pool of Connection objects is created at the time the application server (or some other server) starts. These objects are then managed by a pool manager.When the connection pool server starts, it creates a predetermined number of Connection objects.A client application would then perform a JNDI lookup to retrieve a reference to a DataSource object that implements the ConnectionPoolDataSource interface. The ConnectionPoolDataSource would return a Connection object that implemented the PooledConnection interface.