Re: How to close all connections in a Tomcat container db connection pool?

2011-05-16 Thread Filip Hanik - Dev Lists
in Tomcat 7 (not sure if backported to 6), you configure a Filip On 5/11/2011 7:55 AM, Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dale, On 5/10/2011 7:24 PM, Dale Ogilvie wrote: The cause of the error was the db admin patching a db package underlying one use

RE: How to close all connections in a Tomcat container db connection pool?

2011-05-11 Thread Dale Ogilvie
Thanks Chris. Not as simple as I'd hoped, about as complicated as I expected :-) -Original Message- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: Thursday, 12 May 2011 1:56 a.m. To: Tomcat Users List Subject: Re: How to close all connections in a T

Re: How to close all connections in a Tomcat container db connection pool?

2011-05-11 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dale, On 5/10/2011 7:24 PM, Dale Ogilvie wrote: > The cause of the error was the db admin patching a db package underlying > one used by our web-app. Post patch all the packages appeared valid to > the admin, but not to our app using db connections es

How to close all connections in a Tomcat container db connection pool?

2011-05-10 Thread Dale Ogilvie
Hi, We just had an issue in production on tomcat 6, a web application was getting strange errors from the oracle database: java.sql.SQLException: ORA-06508: PL/SQL: could not find program unit being called in Package Our configuration uses a database pool in GlobalNamingResources of server.xml