i have a application that use hibernate.
i need a automatically reconnection feature so i use c3p0.
and c3p0 works fine, it checks the db and reconnect whenn possible.

but .....

how can i react if the connection is lost, how is it possible to get the exceptions from c3p0,
or is there a other possibility to check if the db is up or down.

Hi.

If the pool is unable to Connect to the database over a period of time, eventually your application will see an SQLException thrown from client calls to getConnection(). For now, there is no easy way for your application to test whether the reason for the Exception was that c3p0 determined the database to be inaccessible -- an SQLException from getConnection() could have other causes.

To resolve this, the next minor revision of c3p0 (0.9.0-pre4) will set SQL State "08001" on SQLExceptions from getConnection() resulting from a down or inaccessible database. Thus your code can determine whether the database appears to be unavailable. (In general, be careful to test for null when checking the SQL state of SQLExceptions, because often no SQL state is set, and the state defaults to null.)

smiles,
Steve (c3p0 guy)

i supposed that, but thanks for your fast answer.