Database reconnecxion

[Olivier Scalbert]

Hello,

In short, I am writing a JSF application that exposes a mysql database through JPA entities and stateless session bean.
I am using glassfish.
I have a question on robustness. If I shutdown the mysql server, of course I have exceptions as soon as I try to access the database.
As I catch the exceptions, the JSF app is still alive.
If I restart the mysql server, how could I automatically recreate the db connexion to glassfish ?
I am using hibernate.

Thanks,

Olivier

[Reza Rahman]

Olivier,

You'd have to check with the GlassFish folks, but the DB connection pools should recover by themselves once the database is online again.

Thanks,
Reza

[RaviNada Kiran]

Reza is correct here.

The server keeps on making a connection to the resource followed by a specific interval of time(server specific)