Yes better than restart mysqld or the server ...
Could you please share some lines of code ?.
In order to do that for all mysql apps, I think to subclass ERXApplication and use a
independent access like "show tables"
Pierre
That's what I do...
On Jul 19, 2013, at 4:50 PM, Hugi Thordarson <h...@karlmenn.is> 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 <pgilq...@citycable.ch> 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" <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/hugi%40karlmenn.is
This email sent to h...@karlmenn.is
_______________________________________________
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/kenlists%40anderhome.com
This email sent to kenli...@anderhome.com
_______________________________________________
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