Chapter 6. DBCP (Database Connection Pool)

Opening a connection to a database is a relatively expensive operation. To avoid having to frequently open database connections, many applications rely on a database connection pool—a group of connections to the database, rotated between the various components of an application as needed. The Apache Jakarta Commons Database Connection Pool (DBCP) provides a rich set of functionality for connection pooling.

Note: Most modern application servers include built-in database connection pooling functionality. If you are building an application that you intend to host in an application server, consult your server documentation for more information on the preferred connection pool mechanism.