This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes MYSQL 5.0 Connection Time Out Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MYSQL 5.0 Connection Time Out" Watch "MYSQL 5.0 Connection Time Out" New topic
Author

MYSQL 5.0 Connection Time Out

Tukaram Kanade
Ranch Hand

Joined: Feb 18, 2010
Posts: 39
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
Martin Vanyavchich
Ranch Hand

Joined: Sep 16, 2008
Posts: 241
What connection times out? What are you using your connection for?


SCJP 6, OCMJD 6, OCPJWSD 6
I no good English.
Tukaram Kanade
Ranch Hand

Joined: Feb 18, 2010
Posts: 39
i am using hibernate for accessing the MySQL DB.

Martin Vanyavchich
Ranch Hand

Joined: Sep 16, 2008
Posts: 241
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MYSQL 5.0 Connection Time Out