Does anyone have any experience with either c3p0 vs. dbcp and know the pros and cons of each? The information that I've been able to find on google so far points me in the direction of c3p0. However, dbcp seems to have better support/documentation. So I'm not sure which is better.
One thread says:
These problems were experienced with the latest version of DBCP and
pool. There are still some scary outstanding issues related to
concurrency that are unresolved in DBCP's bugzilla:
Evictor thread in GenericObjectPool has potential for deadlock
"I personally prefer c3p0 mainly because it is actively maintained. There have been some discussions on each of them mainly on the Hibernate forums - try doing some search there. They are both open source though, so it is possible to extend/fix them if needed."
I didn't have much luck searching the Hibernate mailing lists for the discussions, but I will keep looking. I am using the Spring framework and iBatis on top of a mysql database. Anyone have any suggestions comments on the pros/cons on these two packages?