Sorry... my bad. My math doesn't work early in the morning. :-[ At any rate, the validation query run every minute is still acting as a keep-alive on the connection. It'll never go stale. Personally I'd drop the testWhileIdle, timeBetweenEvictionRuns, minEvictableIdleTime and just let the pool test on borrow. That's the default behavior as long as a validationQuery is specified.
--David Jacob Rhoden wrote: > David Smith wrote: > >> I think I see what's happening here. You've told the database pool to >> continually test connections every hour. The validation query itself >> >> >>> validationQuery="select 1" testWhileIdle="true" >>> timeBetweenEvictionRunsMillis="60000" >>> minEvictableIdleTimeMillis="60000" >>> >> > This is why I am confused, isnt 60000=60 seconds? It is certinaly not > doing an idle test every 60 seconds, why does it say Millis? > > Best Regards, > Jacob > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
