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/archive%40mail-archive.com This email sent to [email protected]
