** Update: BoneCP is no longer maintained ** Instead, HikariCP been proven to be a rock solid successor (and is default connection pool for Spring Boot)
Recently switched to over from using the default connection pool provided by tomcat 7 (which is a re-repackage of DBCP) to BoneCP. Why did we switch? noticed that connection pool wasn’t performing as well as we wanted, under heavy load, the synchronzied blocks that DBCP uses is a performance bottleneck.
Updating tomcat to use BoneCP datasource is answered in this stackoverflow post.
Set the “type” to the BoneCPDataSource (we take advantage of the fact, tomcat supports javax.sql.DataSource out of the box) and the “factory” needs to the Tomcat provideded BeanFactory implemenation.