Brian and others,
Good information. Thanks. What happens with result sets if they don't get
closed? Do they live on forever as memory leaks, or do they get cleaned up
by GC when the object referencing them goes out of scope? If a result set
is left open, does it prevent the connection from getting successfully
closed?
Thx.
JWM
-Original Message-
From: Brian Cook [mailto:[EMAIL PROTECTED]
Sent: Friday, October 07, 2005 3:38 PM
To: Tomcat Users List
Subject: Re: Tracking Datasource Connection Usage?
JWM wrote:
Two things you can do here.
1. Set both removeAbandoned and logAbandoned parameters to
true. This will reclaim most lost connections. And log a trace of what
code called a connection that was never closed.
2. Use a finally block to close all of your Resultsets and
connections. This will insure they are closed even if your code throws
an exception.
Example :
ResultSet rs = null;
Connection con = null;
try {
}
catch(Exception e) {
}
finally {
rs.close();
con.close();
}
I started getting exceptions saying no connections were available on my
JDBC
datasource (org.gjt.mm.mysql.Driver). The pool was definitely large
enough
to handle the load. So it appears that I'm not freeing the all the
connections as I should. I noticed that I did not have the
'removeAbandoned' flag set on the Resource tag. Changing that has
apparently fixed the out of connections problem. But I really want to
clean
up the code and fix it the right way. I've got the close() statements in
place. But obviously, I'm missing some of them somewhere. Is there any
process for logging/tracking allocating and freeing connections (and
absence
thereof.), available connections, etc? Or are there any methods I can call
to give me this type of debug info? What's the recommended way to debug
this?
Thanks.
JWM
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Brian Cook
Digital Services Analyst
Print Time Inc.
[EMAIL PROTECTED]
913.345.8900
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
