I do it in my init servlet's destroy method. When I "start" my application, I use an init Servlet to initialize logger, connection pool etc. When Tomcat is shutting down, it automatically executes my init servlet's destroy method where I close the connection pool.
-----Original Message----- From: Vijay Pawar [mailto:[EMAIL PROTECTED] Sent: June 9, 2003 7:56 AM To: [EMAIL PROTECTED] Subject: tomcat does not release connections Hi All, i have a small query, am using dbcp for connection pooling and am opening 3 connection to the database and having 1 connection as idle. now..when i restart the tomcat container , sometime it does not release the 3 connections ( this is when i check it using the query select count(SADDR) from v$session where username='ACBD' and machine='lmpx00028' ) can something be done in the conf files for tomcat so that the container releases all the connections when it is restarted Cheers Vijay Pawar ----------------- On behalf of Amit J Malhotra (RIL.com) ---------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]