Yesterday, I added autoReconnect=true to the URL and I am no longer having the problems. I did not have to restart the tomcat server in the morning today. Thanks to everyone for their help.
Hemendra -----Original Message----- From: Martin Jacobson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 12:58 AM To: Tomcat Users List Subject: Re: IOException: failed to communicate with MySQL Mindaugas Genutis wrote: >>a couple of days ago a post went by talking about MySQL default timeout >>being set to 8 hrs for connections... betting this might be your problem... > > > Thanks for pointing this out. I've read the thread "Tomcat problems every > morning". However, no solution was suggested in that thread. One can > assume the solution implicitly: increase default MySQL timeout from 8 > hours to say 48 hours. However, if my application stays idle for 48 hours > during holidays, it will disconnect after that. > > Does anyone else have a suggestion on how to improve on this? > Yes, add ?autoReconnect=true to the connection url. Martin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
