Search code examples
javajdbcconnection-poolingbonecp

Fast and reliable alternatives to bonecp connection pool

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.

Solution

  • 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