Below is an example of how you might do this with a Timer.
You *could* copy this class to all of your apps, call init() in their
Application class constructors and call it a day (or, as you suggest, subclass
ERXApplication and use that subclass in your MySQL apps). But best practice
would really be to have a principal class in your common framework (a class
that's loaded when the framework is loaded, you can specify it in the "WOLips
Development"-part of your Eclipse project's properties). And that principal
class should probably make sure you're listening for
EOModelGroup.ModelAddedNotification to see which models use MySQL and then use
that information to create keepalive-timers for each MySQL connection.
The way you go depends on the scale of your operation, I guess. But a little
overengineering never hurt anyone. *cough cough*
-----------------
public class MakeMySQLSuckALittleLess {
public static void init() {
NSTimestamp firstRun = new
NSTimestamp().timestampByAddingGregorianUnits( 0, 0, 0, 1, 0, 0 );
new Timer().scheduleAtFixedRate( new
KeepMySQLConnectionAliveTask(), firstRun, 3600 * 1000 );
}
private static class KeepMySQLConnectionAliveTask extends TimerTask {
@Override
public void run() {
EOFetchSpecification fs = …; // Perform some
lightweight operation on your MySQL connection
ERXEC.newEditingContext().objectsWithFetchSpecification( fs );
}
}
}
-----------------
- hugi
On 20.7.2013, at 06:49, Pierre Gilquin <[email protected]> wrote:
> 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 <[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/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]
