BasicDataSource is, as the javadoc says, a one-stop shopping for basic needs. It has all the necessary. It creates internally a PoolableDataSource and an ObjectPool. PoolingDataSource implements the DataSource interface using a provided ObjectPool. PoolingDatasource take cares of whatever has to do with connections (casting, checking validity, setting properties, etc) and ObjectPool take cares of … Read more
That method is implemented in the current driver version. You must be using an old PgJDBC. Upgrade. It’s fully backward compatible. (You should’ve specified your PgJDBC version in the question). Separately, though, relying on connection “validation” is usually a bad idea. It’s just a way of trying to imperfectly hide a race condition. Simply grab … Read more
C3PO and DBCP development have stalled mostly because they are mature. I have seen both of these drivers be able to support hundreds of transactions per second. The Tomcat pool is a reworked & updated DBCP driver. MyBatis 3.0 also contains it’s own pooling implementation which, based on code inspection, seems solid. Finally, there’s BoneCP … Read more
You’ve done good research. I’d say, go ahead with BoneCP. Some years ago I would have suggested c3p0, but it has currently some open and unresolved issues as well. Too bad, actually. The BoneCP author is by the way also active here at SO.
Tomcat DBCP is just a renamed version of Apache Commons DBCP, with also a different internal package name prefix. At build time, Tomcat fetches the Commons DBCP sources (the version depends on the Tomcat version, for instance Tomcat 7.0.27 uses Commons DBCP 1.4), and does package name replacement (org.apache.commons -> org.apache.tomcat.dbcp) and builds the result … Read more
There is not only one validationQuery for all databases. On each database you have to use different validationQuery. After few hours of googling and testing I have collected this table: Database validationQuery notes hsqldb – select 1 from INFORMATION_SCHEMA.SYSTEM_USERS Oracle – select 1 from dual DB2 – select 1 from sysibm.sysdummy1 mysql – /* ping … Read more
Try putting the driver jar in the server lib folder. ($CATALINA_HOME/lib) I believe that the connection pool needs to be set up even before the application is instantiated. (At least that’s how it works in Jboss)
DBCP is out of date and not production grade. Some time back we conducted an in-house analysis of the two, creating a test fixture which generated load and concurrency against the two to assess their suitability under real life conditions. DBCP consistently generated exceptions into our test application and struggled to reach levels of performance … Read more