Connections not released during reload
Hi, I'm using the following conmfiguration: - tomcat 5.0.28 - Windows 2000 - Oracle 9i database on Sun Solaris I'm using the Tomcat connection pooling dbcp and have the following problem. When reloading the applcation, the open connections are not released and just stay open on the database forever. These connections never die, even though the configuration to remove dead connections is enabled. I then get a whole set of new connections for the reloaded application. Seems the reference to the old connections is just lost. This only happens when reloading the application, not during stop/start. Is there a way to fix this (except stop/start of course :-)) Thanks Bernhard - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Connections not released during reload
Write a ServletContextLlistener and in its contextDestroyed() method use the shutdown() method of the DBCP pool to close connections. rgds Antony Paul On Thu, 13 Jan 2005 11:37:22 +0100, Bernhard Slominski [EMAIL PROTECTED] wrote: Hi, I'm using the following conmfiguration: - tomcat 5.0.28 - Windows 2000 - Oracle 9i database on Sun Solaris I'm using the Tomcat connection pooling dbcp and have the following problem. When reloading the applcation, the open connections are not released and just stay open on the database forever. These connections never die, even though the configuration to remove dead connections is enabled. I then get a whole set of new connections for the reloaded application. Seems the reference to the old connections is just lost. This only happens when reloading the application, not during stop/start. Is there a way to fix this (except stop/start of course :-)) Thanks Bernhard - 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]
AW: Connections not released during reload
Antony, thanks a lot, that's a very good idea and should fix it definitly! Cheers Bernhard -Ursprüngliche Nachricht- Von: Antony Paul [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. Januar 2005 11:56 An: Tomcat Users List Betreff: Re: Connections not released during reload Write a ServletContextLlistener and in its contextDestroyed() method use the shutdown() method of the DBCP pool to close connections. rgds Antony Paul On Thu, 13 Jan 2005 11:37:22 +0100, Bernhard Slominski [EMAIL PROTECTED] wrote: Hi, I'm using the following conmfiguration: - tomcat 5.0.28 - Windows 2000 - Oracle 9i database on Sun Solaris I'm using the Tomcat connection pooling dbcp and have the following problem. When reloading the applcation, the open connections are not released and just stay open on the database forever. These connections never die, even though the configuration to remove dead connections is enabled. I then get a whole set of new connections for the reloaded application. Seems the reference to the old connections is just lost. This only happens when reloading the application, not during stop/start. Is there a way to fix this (except stop/start of course :-)) Thanks Bernhard - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
