[Tomcat JDBC Pool] Close pooled connections via JMX

2012-03-03 Thread Michael
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.

Re: [Tomcat JDBC Pool] Close pooled connections via JMX

2012-03-03 Thread Pid
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

Re: Too many connections in keepalive state in jk threadpool

2012-03-03 Thread Rainer Jung
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

Re: [Tomcat JDBC Pool] Close pooled connections via JMX

2012-03-03 Thread Brooke Hedrick
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.

RE: [Tomcat JDBC Pool] Close pooled connections via JMX

2012-03-03 Thread Caldarale, Charles R
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

RE: [Tomcat JDBC Pool] Close pooled connections via JMX

2012-03-03 Thread Brooke Hedrick
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?

RE: [Tomcat JDBC Pool] Close pooled connections via JMX

2012-03-03 Thread Brooke Hedrick
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

RE: [Tomcat JDBC Pool] Close pooled connections via JMX

2012-03-03 Thread Caldarale, Charles R
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.