Example of a good 'middle-of-the road' c3p0 configuration for MySQL?

i am trying to use c3p0 in my current Spring ba开发者_运维知识库sed application. I am no database pooling expert and was wondering if there is a more or less a good example of a c3p0 configuration (in applicationContext.xml) that can be used against a MySQL database? The pool should detect database connection loss and retries.

c3o0 is dead, do not use it. Use jdbc-pool

Here's the docs, (scroll down to How to use) http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html

Here's a good article on why is this better http://www.tomcatexpert.com/blog/2010/03/12/explaining-jdbc-pool-high-concurrency-alternative-connection-pooling-module

You mean c3p0 or hibernate-c3p0? Hibernate has taken development for C3P0 and it is very well alive. It just published version 4.0.0 CR1, which will be out with Hibernate 4.