What is Connection Pooling?

a. Connection pooling is the process of reusing the database connections created between the application and the database, by then increasing the performance of the application.
Suppose, that there is table in the database, called 'employer', if a objects asks the application server to create a connection between the table and the object, the appServer creates, but it does not throw away the connection, it keeps the connection information in a pool, if again the object requires to connect to the table, it doesn't require to create a new connection as the connection available in the connection pool can be reused. Hence increase in performance.

b. Connection Pooling is a technique used for sharing the server resources among requested clients. It was pioneered by database vendors to allow multiple clients to share a cached set of connection objects that provides access to a database.

c. Connection pooling is a place where a set of connections is kept and is used by the different programers with out creating conncections tithe database (it means there is a ready made connection a available for the programmers where he can use). After using the connection he can send back that connection to the connection pool. Number of connections in connection pool may vary.

d. Getting connection and disconnecting are tasks by itself, which costs to the application performance, so we should avoid it. To be more precise, depending of the Max & Min connections parm set in the specific Appserver config, it intially either gets the min set of ready to connections or would be request based till the max connections are used. Once DB operations are done, the free DB connections are re-used.

e. Getting connection and disconnecting are tasks by itself, which costs to the application perfomance, so we should aovid it. To be more precise, depending of the Max & Min connections parm set in the specific Appserver config, it intially either gets the min set of ready to connections or would be request based till the max connections are used. Once DB operations are done, the free DB connections are re-used.

f. Connection pooling means set of connections is available to connect, after use this connection, disconnect it then others can use it. It reduces the time, and it can be eusable. User can use any number of connections.

SOURCE : www.referjava.com