Re: how to check connection pool is still working

[Tim Funk]

Yup  - There is an option in DBCP (which is what tomcat uses) which allows 
you to specify a validation query. (for exmaple: select 'x' from dual) The 
validation query can run before the connection is borrowed or after it is 
returned or both. See the DBCP docs for more details.

-Tim

a b wrote:
Hello everyone,
I am running database on different machine than the
one running tomcat. Tomcat creates a connnection pool
to the database, but when some times database machine
reboots, it makes all the connections in the pool
useless,is there a way to tell the tomcat to make
release resources with existing connection pool and
create another one ?
Thanks.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]