Pid schrieb:
On 03/03/2012 12:33, Michael wrote:
Hi folks,
I've been examining the JMX operations of the new pool and did not find
a crucial one.
Sometimes our Oracle database has to be restarted, the pool still keeps
the pooled connections. The webapp requests a connection, receives a
pooled one and boom => ORA-... Connection closed.
I'd like to be able via JMX to reopen all open pooled connections
without the need to restart the webapp.
Do you have testOnBorrow="true" and a validationQuery="SELECT 1 FROM
DUAL" configured?
This should suffice to ensure each connection is valid before use.
Hi Pid,
I did not yet try that option. Of course, if this works, I'll happy with
the "lazy" approach. I will test this the next couple of days and give
feedback.
Thanks,
Michael
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
