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.
posted 10 years ago
Can anybody help with the above question? Everyday morning I have to restart the server for tackiling this? Any hints..
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads