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: [email protected]
For additional commands, e-mail: [email protected]
