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.