I was wondering which connection pool to use. I'm using Tomcat, and apparantly it provides a "DBCP" connection pool. Hibernate on the other hand, which I'm also using, has built in support for the "C3PO" connection pool. Then there is the "org.apache.commons.dbcp.BasicDataSource" which I could also use.
- What's the pros- and cons of the different pools, or is there an obvious choice?
- I could use both "C3PO" and "org.apache.commons.dbcp.BasicDataSource" in a non managed environment if I wanted to, right?