What is Connection Pooling? Is it advantageous?
An EJB container provides the service of connection pooling in order to provide efficient way of database connectivity to its concurrent and continuous user requests. Whenever a client request for a database connection then an instance is picked from the connection pool to get an access to database as soon as user is through with his work instance is returned to connection pool. There is a limit specified by App server administrator for the availability of number of connections and beyond a specified limit a predefined number increases numbers of connection pool instances. When demand goes back to normal then access amount of connection pool instances are removed.
This mechanism of connection pooling helps in smart and efficient use of system resources and improving the overall performance of the whole system.
This mechanism of connection pooling helps in smart and efficient use of system resources and improving the overall performance of the whole system.