A Connection Pool is maintained internally by the Connection Pool Manager. When a request for a subsequent connection comes in, the Connection Pool Manager searches the pool for the availability of a free connection and returns it to the application if one is available. Connection Pools works as below
ÃÂ· If any unused connection is available, it returns one.
ÃÂ· If all connections are used up, a new connection is created and added to the pool.
ÃÂ· If the number of connections reaches the maximum number of connections in the pool, the requests are queued until a connection becomes free for reuse.