I've added the following to the configuration:
testWhileIdle=true
timeBetweenEvictionRunsMillis=30
minEvictableIdleTimeMillis=60
with the intention that any idle connections would be evicted and closed
normally before the firewall terminated them. Does specifying these
enable the
testWhileIdle=true,
timeBetweenEvictionRunsMillis=5000,
numTestsPerEvictionRun=5,
...
This will cause the idle object evictor thread to wake up every five
second, and test 5 threads with the validation query. We use this in our
application because we were having dead threads being given to the
Mark Thomas wrote:
The validation query on its own does nothing. Have you tried setting
testOnBorrow=true ? That may be sufficient if you can live with a slight delay
if a broken connection needs to be refreshed.
Mark
Thanks Mark, I have the testWhileIdle=true which I understood would
run