Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
From: "George Sexton" <gsexton@mhsoftware.com>
To: "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>,
	"'Richard Road Runner'" <rjadrian@nc.rr.com>
Subject: RE: Database connections aren't being released...
Date: Thu, 6 Oct 2005 09:17:35 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
In-Reply-To: <00ae01c5ca09$23ec91f0$030aa8c0@teamreblaptop>
Thread-Index: AcXKCUKNawXO2oi5SiKHM8AtCdLfNAAf5CSA
Message-Id: <20051006151748.0033A32422@mail.mhsoftware.com>

As many people have pointed out, your app is probably not closing resources.
A tool that can help find these is:

http://findbugs.sourceforge.net/


George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585
  

> -----Original Message-----
> From: Richard Road Runner [mailto:rjadrian@nc.rr.com] 
> Sent: Wednesday, October 05, 2005 6:01 PM
> To: Tomcat Users List
> Subject: Database connections aren't being released...
> 
> I am not sure that this is a Tomcat issue, but we are not 
> sure what exactly is causing our problem.
> 
> We are running Tomcat 5.0.27.  We are using the most recent 
> jconn2.jar driver to connect to a Sybase SQL Anywhere Studio 
> 7 database via JDBC.
> 
> Over a period of time, the number of connections to the 
> database continues to increase far beyond the possible number 
> of users.  The only way to close the connections is to 
> restart the database server.
> 
> Again, we are not sure if we should be looking at Tomcat, the 
> JDBC driver, or Sybase to solve this problem.
> 
> Any input would be helpful.
> 
> Thanks
> 
> 
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org