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.
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
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
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.
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.
That
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 have testOnBorrow=true and a validationQuery=SELECT 1 FROM
DUAL configured?
On Mar 3, 2012 11:48 AM, Brooke Hedrick brooke.t.hedr...@gmail.com
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
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 emp.