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.