I'm looking at BoneCP as a replacement for DBCP after discovering that a lot of time was spent in my application in doing SELECT 1 statements because of testOnBorrow=true
We use a lot Spring jdbcTemplate.query(), update()... with small queries in a highly concurrent environment so I guess that BoneCP could greatly improve our performances.
I'm a little worried by the different reports I saw on this forum saying that BoneCP cannot properly recover from DB connection problem in some cases. Is there a real problem or is it due to application misbehavior (connection not closed)?
I cannot promote BoneCP as a replacement for DBCP only because it's fast if it not also very reliable and robust.
I also see that some important bugs (see for example https://bugs.launchpad.net/bonecp/+bug/790759) have been fixed a few months ago but not released. So, when will these changes be released?