Hi,

We use hibernate , and c3p0 for connection pooling. The database is MySQL.
What is the general strategy for recovering from Stale connections(though c3p0 documentation has lot of details, and we tried by setting some parameters). For example if we browse the application ,and then restart MySQL in-between, and access the application again we get the following error:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

The same happens as some users say when MySQL has timmed out.

Regards

Nitin