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: Ken Anderson <email@hidden>
- Date: Fri, 19 Jul 2013 21:19:55 -0400
That's what I do...
> On Jul 19, 2013, at 4:50 PM, Hugi Thordarson <email@hidden> wrote:
>
> Create a Timer that fires every hour to fetch an object?
>
> It's the perfect hack; simple yet disgusting.
>
> - hugi
>
>
>> On 19.7.2013, at 15:01, Pierre Gilquin <email@hidden> wrote:
>>
>> 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
>
>
> _______________________________________________
> 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
_______________________________________________
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