tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hemendra.R...@WellsFargo.COM
Subject RE: IOException: failed to communicate with MySQL
Date Tue, 03 Jun 2003 16:56:08 GMT
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:martin_j@libero.it]
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message