Hi,

I'am using Hibernate 3.1.3 for for database interaction. I'am using c3p0 for connection pool strategy. I have a problem whenever we stop the database, we get exception, HiberbateException when operating on session objects,
like say on session.createQuery() method.

When the database connection is lost, I wish to check the exception if it occurred because of disconnection from database and customize my response. If it is because of disconnection, I wish to reconnect to database. How to know the database connectivity status in Hibernate?

Thanks,
Sanjeev Srinath

session.getconnection() gives you the Connection object, from this object you can get the status of connection

Hey thanks for the reply. I already tried by getting session.connection() method, and tried to check the status by using connection.isClosed(), but it once again throws exception. Even if I initialize Connection object before the exception as well, it is showing the status based on the status of whether this connection is closed by session it was invoked on. I do not want the status of connection based on the session object, I wish to know the status of database connectivity if it is still present between application and database.

Hope you understand my requirement.

Thanks,
Sanjeev Srinath

When you r using c3p0 , c3p0 will take care of refreshing your connection. you need to add configuration for c3p0 which refresh the connection after certain interval.

Ranveer, when I get disconnected, as the session object will raise the exception, so can I know the reason that the exception is raised because of database disconnection(like the database connection is lost because of the command from administrator)?

Hi Sanjeev,
I am not sure about Hibernate but if you check the log file c3p0 gives error about database connection status. Let me try?