commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thomas <ma...@apache.org>
Subject Re: [dbcp] connection error while querying to db after being 7+ hours idle.
Date Thu, 22 Jul 2010 21:55:44 GMT
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
View raw message