Re: mysql access exception after a long time
Re: mysql access exception after a long time
- Subject: Re: mysql access exception after a long time
- From: Pierre Gilquin <email@hidden>
- Date: Fri, 19 Jul 2013 17:01:52 +0200
Thanks for your help
I realize that 8 hours are the setting for wait_timeout in mysql server.
As my app is not used at night, I think to change wait_timeout to 24h and schedule a restart of my WO app every night.
Do you thing it could solve the problem in a easy way ?
Pierre
Hi,
This is a well known bug in MySQL driver. It happens after 8 hours of
being idle. Try not to use the driver 's default connection pool, use
some altetnatives such as C3po.
Best of luck!
On 19 Jul 2013 20:33, "Pierre Gilquin" <email@hidden
<mailto:email@hidden>> wrote:
Hi
If mysql is not accessed by my app for a long period of time (around
8h), an exception is throwned.
Is there a setting that I can apply to my wonder-WO app or mysql to
prevent this ?
Thanks in advance
Pierre
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden