Connection pools

Database connections: The last point is critical: connections must always be properly released when no longer needed. Failure to do so will eventually cause the application to "hang", and fail to respond to user actions. All code in your application regarding connections should be treated with special care.

To ensure that database connections are used as efficiently as possible, many applications make use of a connection pool, which can sometimes improve performance in a distributed application. An application will use a connection pool as follows:

A database driver may contain a connection pool as part of its services, through its implementation of the javax.sql.DataSource interface. DataSource objects are used with JNDI.

The popular Tomcat tool implements JNDI, and connection pooling is described in its documentation. It's not difficult to use.

See Also :
Get database connection
Encapsulate connections