The difference between C3P0 and DBCP

Original address:

The difference between C3P0 and DBCP

https://blog.csdn.net/huangxinyu_it/article/details/50826463

C3P0 Introduction:




C3P0 is an open-source JDBC connection pool that implements data source and Jndi bindings, and supports standard extensions for JDBC3 specifications and JDBC2. The open source project that uses it now has hibernate,spring etc.




DBCP Introduction:


DBCP (db connection pool), database connection pooling. is a Java Connection pool project on Apache and a connection pooling component used by Tomcat. Separate use of DBCP requires 3 packages: Common-dbcp.jar,common-pool.jar, Common-collections.jar because establishing a database connection is a very time-consuming and resource-consuming behavior, it is necessary to set up some connections with the database through connection pool, put in memory, apply to the connection pool directly when the application needs to establish a database connection, and then put it back after use.




The difference between C3P0 and DBCP:




DBCP does not automatically recycle the free connection function




C3P0 has automatic recycle idle connection function