How to use Java JDBC connection pool?

Question

I want to use a JDBC connection pool. The most important factor is that it's easy-to-use and bug-free. What is suitable for me?

Answer 1

I suggest c3p0 (over DBCP which has some really serious issues): it works great, is actively maintained and easy to use. Maybe have a look at this previous question for more inputs on this.

Update: I admit I didn't check the status when I wrote this answer (I'm using c3p0 for many years and was happy with it) and it appears that c3p0 development is in stand by. Funnily, the previous question mentioned as reference has been updated the 2010-03-12 to mention that DBCP development is alive again. My original post may thus be out of date.

Answer 2

Another fine alternative is the Apache Database Connection Pool.

Instead of getting a connection using DriverManager, you'll use a JNDI naming service to get your connection out of the pool.

Be sure to close your resources - Connection, Statement, and ResultSet. If you don't, your pool will be quickly exhausted.

Answer 3

I've used this MiniConnectionPoolManager with H2 and Derby.

Answer 4

Also have a look at BoneCP (http://jolbox.com); there are some samples on the site.