Spring JDBC connection pool best practices

C3PO and DBCP development have stalled mostly because they are mature. I have seen both of these drivers be able to support hundreds of transactions per second.

The Tomcat pool is a reworked & updated DBCP driver. MyBatis 3.0 also contains it’s own pooling implementation which, based on code inspection, seems solid. Finally, there’s BoneCP which claims to have the best performance. I haven’t used any of these on a project yet.

Probably the best advice is to pick any of them test it. Spring makes it easy to swap out later.

Leave a Comment