Are you using a global pool or is the pool just for that app?
If global, this will kill the connections for all the apps. Not something you want to do in production but will be fine in development.
So remember to remove this before going live, if global.
That is what I get for reading while asleep, I missed that you were seeing this from the DB server. So my original post doesn't apply. Sorry about that.
Doug
----- Original Message ----- From: "Lucie Chan" <[EMAIL PROTECTED]>
To: <[email protected]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 08, 2005 2:58 AM
Subject: How to release connections in connection pool during reload?
Dustin,
Thanks! You''ve helped me to solve a prloblem that I've been struggling with for days.
--- Lucie
Date: Fri, 7 Jan 2005 22:08:20 -0800 (PST) From: Dustin <[EMAIL PROTECTED]> Subject: How to release connections in connection pool during reload? Content-Type: text/plain; charset=us-ascii
In your servlet's destroy() method (I am using Struts and plugins, and use the plugin's destroy() method), add the following code:
((BasicDataSource) ds).close();
That is assuming your data source is named 'ds'. This will close all connections.
Dustin
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
