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" <pgilq...@citycable.ch <mailto:pgilq...@citycable.ch>> 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      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to