In my app, 1. There is an init Servlet to initialize my connection pool using JNDI resource. 2. I close result set, statement and connection after each access. I also nullify those object in finally block. 3. Before Tomcat shuts down my webapp, I override destroy method in init Servlet to close and nullify the data source.
-----Original Message----- From: Adam Hardy [mailto:[EMAIL PROTECTED] Sent: October 1, 2003 5:20 AM To: Tomcat Users List Subject: Re: Datasource connections not released when reloading context actually that doesn't really close them, since it's a connection pool, but it tells the connection pool that they're free for someone else. On 10/01/2003 11:05 AM Adam Hardy wrote: > Hi Matt, > you don't destroy them, you just close them. > > if (!conn.isClosed()) conn.close(); > > > > > > On 09/30/2003 12:51 AM Matt Raible wrote: > >> If I'm getting my database connections from a JNDI resource >> (configured in >> server.xml) how do I destroy these suckers. Sample code would be >> great - or >> tell me to RTFM. >> >> Matt >> >> -----Original Message----- >> From: Phillip Qin [mailto:[EMAIL PROTECTED] >> Sent: Monday, September 29, 2003 8:04 AM >> To: 'Tomcat Users List' >> Subject: RE: Datasource connections not released when reloading context >> >> - to release your DB connections when your app is shutdown or reloaded: >> implement destroy method in your servlet class to close them. >> - to prevent connections getting exhausted, use evictor if your use >> commons >> pooling and dbcp. >> >> -----Original Message----- >> From: Jose Alfonso Martinez [mailto:[EMAIL PROTECTED] Sent: >> September 27, 2003 7:31 PM >> To: [EMAIL PROTECTED] >> Subject: Datasource connections not released when reloading context >> Hi guys, >> >> Does any one know if there is a possibility of tomcat, for any reason, to >> reload a context without telling it to do so???? >> >> I am having a problem that after 2 or 3 days without reloading tomcat, >> pooled-connections from the datasource get exahusted. >> >> The only case I have seen that the number of pooled-connections is >> incremented is when I reloaded my context. In this case, the reloaded >> context's datasource opened a new set of connections to work on >> (leaving the >> older connections opened and not releasing them until tomcat is >> shutdown). >> If the context gets reloaded over and over again, eventually connections >> with the DBMS will get exahusted... >> >> Is that the expected behavior???? To leave conections open when >> reloading a >> context???? >> >> Would there be another posibility for pooled-connections to get >> exahusted, >> once they were set up and correctly running??? >> >> Thanks in advance >> >> Jose >> >> --------------------------------------------------------------------- >> 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] >> >> > -- struts 1.1 + tomcat 5.0.12 + java 1.4.2 Linux 2.4.20 RH9 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
