How to use Java JDBC connection pool?

I want to use a JDBC connection pool. The most important factor is that it's easy-to-use and bug-fre开发者_StackOverflow中文版e. What is suitable for me?

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.

Also have a look at BoneCP; there are some samples on the site.

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.

I've used this MiniConnectionPoolManager with H2 and Derby.

2 years later... Just migrated to jdbc-pool (standard on Tomcat 7 now) it was very easy to implement it standalone in a web app or for the the whole server. Per specifications and my experience it out-performs c3p0.

Per specs it is also alot cleaner than dbcp or c3p0.