On Mar 3, 2012 7:17 AM, "Pid" <p...@pidster.com> wrote: > > 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.
That approach doesn't work when the application uses symlinks to get to data on other Oracle servers. > > > p > > > -- > > [key:62590808] >
