tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pid <>
Subject Re: [Tomcat JDBC Pool] Close pooled connections via JMX
Date Sat, 03 Mar 2012 13:16:31 GMT
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.




View raw message