Several open-source database connection pools

• DBCP Database Connection Pool

• C3P0 Database Connection Pool

DBCP is an open source connection pool implementation under the Apache Software fund, and to use the DBCP data source, the application should add the following two jar files to the system:

• Commons-dbcp.jar: Implementation of connection pooling

• Commons-pool.jar: Dependency libraries for connection pooling implementations

The connection pool for Tomcat is implemented with this connection pool. The database connection pool can be used either in combination with the application server or independently by the application.

C3P0 is an open source JDBC connection pool that implements data sources and Jndi bindings, and C3P0 data sources are used more in project development.

Jar Package C3p0-0.9.2-pre1.jar, Mchange-commons-0.2.jar,

Difference:

1. DBCP does not automatically reclaim idle connection functions

2. C3P0 has automatic recycle idle connection function

Several open-source database connection pools