Fast and reliable alternatives to bonecp connection pool

java jdbc connection-pooling bonecp
Deinlandel picture Deinlandel · Jul 25, 2012 · Viewed 8.8k times · Source

I was using BoneCP for my Java projects. But, unfortunately, I discovered that this pool is unable to recover after the database failure. I am not the only one with such problem (just look at the official forums if you want). As I (and many others) never got answer on bonecp forums, it seems that this project is no longer supported and my issue is unlikely to be fixed.

So, I am looking for an alternative actively developed and supported connection pooling library which is able to handle database outages correctly and recover as soon as database is available again.

Answer

MJB picture MJB · Jul 25, 2012

The other major contenders are

  • C3P0 - also more or less abandoned, but very capable
  • Proxool - also abandoned
  • DBCP - abandoned for a long time, restarted.
  • HikariCP - new CP that even the BoneCP author concedes is faster
  • Vibur - modern pool, with metrics and slow query logging
  • Tomcat JDBC Pool - included with tomcat, but can be used standalone

Related questions

Connection pooling options with JDBC: DBCP vs C3P0

What is the best connection pooling library available for Java/JDBC? I'm considering the 2 main candidates (free / open-source): Apache DBCP - http://commons.apache.org/dbcp/ C3P0 - http://sourceforge.net/projects/c3p0 I've read a lot about …

Read More
How to establish a connection pool in JDBC?

Can anybody provide examples or links on how to establish a JDBC connection pool? From searching google I see many different ways of doing this and it is rather confusing. Ultimately I need the code to return a java.sql.…

Read More
Closing JDBC Connections in Pool

Our standard code section for using JDBC is... Connection conn = getConnection(...); Statement stmt = conn.conn.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); ResultSet rset = stmt.executeQuery (sqlQuery); // do stuff with rset rset.close(); stmt.close(); conn.close(); Question 1: …

Read More