MYSQL 5.0 Connection Time Out

Hi All,

I have written a web application that connects to a MySQL database. Everything works fine for the first 8 hours,When my web application remains in ideal state for 8 hours, then MySQL connection expires.

After that restarting the tomcat everthing works fine again.
How should i resolve this problem.
Please help me.

Thanks in Advance

What connection times out? What are you using your connection for?

i am using hibernate for accessing the MySQL DB.

If you're using a pool, sometimes the connections in it expire due to long periods of incativity. One workaround is to always fetch some metadata from connection prior to doing any serious work. If metadata retrieval fails, get another connection from the pool, and so on. Make a resonable number of retries, depending on the pool size, before notifying the user that something is wrong. Please come back and tell us what solved the issue.