Tomcat - Hibernate - MySQL - Which connection pool manager ?

[PascalAlberty]

Hi everybody,

we have a Spring application which will run under Tomcat/Hibernate/MySQL.

Now, I would like to configure a connection pool manager and of course I have several possibilities:
- Spring inside connection pool
* C3P0
* DBCP
* ...
- Tomcat connection pool using JNDI to retrieve it

I read some threads (http://forum.springframework.org/showthread.php?t=38306 for example) saying that C3P0 seems better then DBCP. But I would have some arguments to choose between "spring inside" and "tomcat one".

Thanks

[karldmoore]

I've used c3p0 a few times in the past with no problems. We tried a few different options previously to this but we ended up going to c3p0.