As noted in Tomcat docs,

A web application has to explicetely close ResultSet's, Statement's, and
Connection's.

I am using a web app that opens a ResultSet locally (in a method) but it
never gets closed (gc'd sometime I presume).

Under Oracle, a user is hitting the maximum number of Oracle process and
I presume it is a leak.

Three questions.

1) must a local ResultSet be explicitely closed to avoid a leak

2) if I use,             <parameter>
              <name>logAbandoned</name>
              <value>true</value>
            </parameter>

to log the stack trace, where is that log?  Under logs in the usual place for that 
context.
I have to tell someone else where to find the log otherwise would just look for it 
myself (ie I'm not running Oracle).

3) If only Oracle shows this behavior what could account for that?  Diff jvm?  (just 
curious)

TIA

-- 
shawn


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to