tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brooke Hedrick <brooke.t.hedr...@gmail.com>
Subject Re: [Tomcat JDBC Pool] Close pooled connections via JMX
Date Sat, 03 Mar 2012 17:09:47 GMT
On Mar 3, 2012 7:17 AM, "Pid" <pid@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]
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message