> From: Brooke Hedrick [mailto:brooke.t.hedr...@gmail.com]
> Subject: RE: [Tomcat JDBC Pool] Close pooled connections via JMX
> You will see things like: select * emp@otherdb. Where @otherdb
> is typically an entry that you would find in a tnsnames.ora.
> I left out the FROM between the * and e
On Mar 3, 2012 11:48 AM, "Brooke Hedrick"
wrote:
>
>
> On Mar 3, 2012 11:35 AM, "Caldarale, Charles R" <
chuck.caldar...@unisys.com> wrote:
> >
> > > From: Brooke Hedrick [mailto:brooke.t.hedr...@gmail.com]
> > > Subject: Re: [Tomcat JDBC Pool] Close pooled connections via JMX
> >
> > > > Do you h
On Mar 3, 2012 11:35 AM, "Caldarale, Charles R"
wrote:
>
> > From: Brooke Hedrick [mailto:brooke.t.hedr...@gmail.com]
> > Subject: Re: [Tomcat JDBC Pool] Close pooled connections via JMX
>
> > > Do you have testOnBorrow="true" and a validationQuery="SELECT 1 FROM
> > > DUAL" configured?
> > >
> >
> From: Brooke Hedrick [mailto:brooke.t.hedr...@gmail.com]
> Subject: Re: [Tomcat JDBC Pool] Close pooled connections via JMX
> > Do you have testOnBorrow="true" and a validationQuery="SELECT 1 FROM
> > DUAL" configured?
> >
> > This should suffice to ensure each connection is valid before use.
On Mar 3, 2012 7:17 AM, "Pid" 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.
Hallo Herr Beier,
On 02.03.2012 11:19, Beier Michael wrote:
Hi all,
we're running tomcat 7.0.23 on sun jdk 1.6.0_29, connected via ajp to httpd
2.2.21 using mod_jk 1.2.32.
I observed the behavior, that tomcat keeps threads in its ajp pool in keepalive
state, regardless of which timeouts (con
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
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'
