Re: Debugging my Connector/J based Tomcat Servlet

Hi,

Maybe a silly question (I don't know your skills), but do you close all the ResultSets, Statements and Connections properly in your application after use? Or if you are using pooling is you pool closing everything right?
Can you make a simple testapplication which reproduces the problem.

Anyway, I'm not into the code of the mysql driver, so maybe somebody else can give you more helpfull advice about that.

Ronald.


Op vrijdag, 10 juli 2009 15:19 schreef Niklas Saers <[email protected]>:
> 
> On Jul 10, 2009, at 11:04 AM, Ronald Klop wrote:
> > This is a neat tool.
> > http://www.eclipse.org/mat/
> 
> Thanks for the tip about mat, using that I got a better understanding  
> of my memory use. The Servlet has a Retained Heap of 6,811,840. Of  
> this, 6,811,672 come from the private java.sql.Connection variable  
> 'con'. Is there anything I need to do to regularly flush out this  
> connection? As noted, it has an awful lot of Fields, Statements,  
> ResultSets etc laying around that have been used and should be flushed.
> 
> Cheers
> 
>     Nik
>  
> 
> 
>