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. p -- [key:62590808]
signature.asc
Description: OpenPGP digital signature
