Dbcp
DBCP may be the most used open source connection pool, probably because of the ease of configuration, and many examples of open source and Tomcat applications are used for this connection pool.
This connection pool can set the maximum and minimum connections, connection waiting time, etc., basic functions are available. The configuration of this connection pool is described in the attachment compression package: Dbcp.xml.
Usage Evaluation: In the specific project application, it is found that the stability of the continuous operation of this connection pool is still possible, but the speed is slightly slower, the stability under the pressure of the large concurrent quantity
The connection pool monitoring is also not available
C3p0
C3P0 is another open source connection pool, in the industry is also more famous, this connection pool can set the maximum and minimum connection, connection waiting time, etc., basic functions have.
The configuration of this connection pool is described in the attachment compression package: C3p0.xml.
Use evaluation: In the specific project application, found that the continuous operation of this connection pool stability is quite good, under the pressure of large concurrency also has a certain guarantee, in addition to not
Provides connection pool monitoring.
Java Database connection Pool comparison