commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cyrille <cyrille....@free.fr>
Subject Re: [dbcp] connection error while querying to db after being 7+ hours idle.
Date Fri, 23 Jul 2010 08:03:45 GMT
Hi Thomas,

I have not worked a lot with mysql, but did you try to set testOnBorrow 
to true with a validation query such as " SELECT 1" ?
This will trigger a new validation query before uysing the connection, 
and will drop the connection if it is not valid.

Cyrille



Le 22/07/10 23:55, Mark Thomas a écrit :
> On 22/07/2010 22:48, Minhaj wrote:
>    
>> Hi Dennis,
>>
>> Thanks for your reply.
>>
>> Well, some one told me to put the testWhileIdle property true but it's not
>> working for me still same issue; no luck :(
>>
>> Secondly, You must be talking about "minEvictableIdleTimeMillis" property?
>> Aren't you?
>>
>> Following is my setting for "minEvictableIdleTimeMillis" property.
>> # The minimum amount of time an object may sit idle in the pool before it is
>> # eligable for eviction by the idle object evictor (if any).
>> # [Default: 180000 (30 min)]
>> dbcp.minEvictableIdleTimeMillis=180000
>> Here you can find the complete configuration details.
>> http://commons.apache.org/dbcp/configuration.html
>>
>> So rather then DBCP what do use? what are your recommendation? c3p0? my
>> application is a spring+hibernate based app.
>>      
> Just use a validation query.
>
> Mark
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
> For additional commands, e-mail: user-help@commons.apache.org
>
>    

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message