What is Connection Pooling????

Many applications needs to connect to database for retrieving, updating, deleting and inserting the data. For every activity with the database there needs to be a connection established by the application server. If tens of thousands of connections are made to database server for every request then it chokes-up the network and server hangs.

To avoid this the Connection Pooling mechanism provides way of storing established connections in the memory.

This is nothing but pool all the connections at one place. Every time a database connection needs to be established a request is made to pool or any object which holds all the connections to provide a connection. Once that particular database activity is completed the connection is returned back to the pool.

Many J2EE application servers provide their own connection pooling mechanism.