tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian" <bbprefix-m...@yahoo.com>
Subject RE: Tomcat 6.0.29 using more and more RAM until it collapses?
Date Thu, 11 Nov 2010 19:57:19 GMT


> -----Original Message-----
> From: Christopher Schultz [mailto:chris@christopherschultz.net]
> Sent: Thursday, November 11, 2010 02:39 PM
> To: Tomcat Users List
> Subject: Re: Tomcat 6.0.29 using more and more RAM until it collapses?
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Brian,
> 
> On 11/11/2010 2:26 PM, Brian wrote:
> > I'm using it properly. After I perform a SQL sentence, I close the
> > objects (result set, then its statement).
> 
> http://blog.christopherschultz.net/index.php/2009/03/16/properly-handling-
> pooled-jdbc-connections/

I will read this link, thanks!!

 
> > I also check what is going on in my DBMS (MySQL), and it shows a
> > normal amount of connections.
> 
> Good. That's unlikely to be the problem, then.

That is what I think too. I see, on average, about 30-40 connections in  MySQL using its "Workbench"
tool. And that looks fine, that corresponds to the way I configured the pool.
But I must say that I hadn't always used the pool. In the past I used to use just one connection,
and in many methods I had forgot to close the resultset. You can imagine how much my app crashed!
I couldn't even sleep at night! Then I fixed my app so it closes every result set it created,
then the statement, and then "close" the connection so it goes back to the pool. Since that
day, my app stopped crashing that often. Now it still crashes, but less often.


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


Mime
View raw message