Communications link failure during commit().

[bis ani]

Hi,

For my web application, I am using hibernate and mysql database and Jboss server. I configure the database connection in the hibernate.cfg file.

My server has to run continously for days and the user should be able to access the application whenever required. The problem I am facing is everyday morning, when I first Access the application , I am getting the following exception:

java.sql.SQLException: Communications link failure during commit(). Transaction resolution unknown.

I think the reason is after a period of inactivity , MYSQL Server is closing the connection. But I dont know where/how to set the maximum connect interval, through hibernate.

Please give some ideas regading this.

regards,
Bis

[bis ani]

Hi,

Can anybody help with the above question? Everyday morning I have to restart the server for tackiling this? Any hints..

regards,
Bismi