Comparison between C3P0, BONECP, DBCP, proxool Four popular Java connection pools

c3p0 is an open source JDBC Connection pool that is published in the Lib directory with Hibernate, including the connection and statement pools that implement the JDBC3 and JDBC2 extension specification descriptions datasources Object.

BONECP is an open source, fast JDBC connection pool. BONECP is very small, only more than 40 K (runtime needs log4j and Google Collections support, which add up is not small), compared to c3p0 more than 600 K. Another person thinks that BONECP has a disadvantage is that the JDBC driver is loaded outside the connection pool, so that some application server configuration is not flexible. Of course, small volume is not bonecp excellent reason, BONECP in the end there is what prominent place, please see Performance test report.

DBCP (Database Connection Pool) is a database connection pool that relies on the Jakarta Commons-pool object pooling mechanism. Tomcat's data source uses the DBCP. Currently, there are two versions of DBCP, 1.3 and 1.4, respectively. Version 1.3 corresponds to JDK 1.4-1.5 and JDBC 3, while the 1.4 version corresponds to JDK 1.6 and JDBC 4. So when choosing a version, look at what JDK version you're using, and there's no difference in functionality.

Proxool is a Java SQL driver driver that provides a connection pooling package for other types of drivers that you choose. Can be ported to existing code very simply. Fully configurable. Fast, mature and robust. You can transparently increase the connection pooling capability for your existing JDBC driver.

###################################################################

BONECP is a fast, free, and open source Java database connection pool (JDBC pool) management tool Library. BONECP in the fast this feature to achieve the ultimate, the official data is c3p0 and so on about 25 times times.

Comparison between C3P0, BONECP, DBCP, proxool Four popular Java connection pools