That's what I do... > On Jul 19, 2013, at 4:50 PM, Hugi Thordarson <[email protected]> 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 protected]> 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 protected] >>> <mailto:[email protected]>> 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 protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/hugi%40karlmenn.is >> >> This email sent to [email protected] > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/kenlists%40anderhome.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
