Re: MySQL communication link failure

[Stijn de Witt <St...@bergland-it.nl>]

The server has been running with the new settings for a couple of days 
now and it looks good so far.
Thanks everyone for your help!

-Stijn


Stijn de Witt wrote:

> Martin Kalén wrote:
>
>> Stijn de Witt wrote:
>>
>>> Could you review these settings for the evictor thread solution? Do 
>>> you think these settings are ok?
>>>
>>> validationQuery="select 1"
>>> minEvictableIdleTimeMillis="60000"
>>> timeBetweenEvictionRunsMillis="120000"
>>> numTestsPerEvictionRun="10"
>>> testWhileIdle="true"
>>> testOnBorrow="false"
>>> testOnReturn="false"
>>>
>>> Could I combine these with autoReconnect="true"? Would that be useful?
>>> Which of the two options would you use?
>>
>>
>> This looks like a good setup to me! Personally, I would recommend you
>> to set testOnBorrow="true" and leave the autoReconnect URL paramater
>> out of the equation.
>
>
> Thanks for all the info Martin, I will do as you say, leave 
> autoReconnect=true out, use an evictor thread and set 
> testOnBorrow="true".
> I will let you know how it worked out.
>
> Greetings,
>
> -Stijn
>

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org