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]



Reply via email to