monitoring open connections that are not removed with removeAbandoned param set to ture

[Amir S]

Hi,
How can I monitor my open connections to know which JSP opened which
connection?
I'm using the removeAbandoned option set to true and I have open connections
that exceed the max active count.
I'm using oracle 9i and Apache Tomcat/5.0.28.
 
the pool configurations are:
 
<Resource name="jdbc/TEST" auth="Container"
              type="javax.sql.DataSource"/> 
 
<ResourceParams name="jdbc/TEST">
  <parameter>
    <name>factory</name>
    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>
  <parameter>
    <name>driverClassName</name>
    <value>oracle.jdbc.driver.OracleDriver</value>
  </parameter>
  <parameter>
    <name>url</name>
    <value>jdbc:oracle:thin:@10.0.0.1:1521:TEST</value>
  </parameter>
  <parameter>
    <name>username</name>
    <value>XXX</value>
  </parameter>
  <parameter>
    <name>password</name>
    <value>XXX</value>
  </parameter>
  <parameter>
    <name>maxActive</name>
    <value>500</value>
  </parameter>
  <parameter>
    <name>maxIdle</name>
    <value>10</value>
  </parameter>
  <parameter>
    <name>maxWait</name>
    <value>5000</value>
  </parameter>
   <parameter>
              <name>removeAbandoned</name>
              <value>true</value>
            </parameter>
   <parameter>
              <name>removeAbandonedTimeout</name>
              <value>10</value>
            </parameter>
  <parameter>
              <name>logAbandoned</name>
              <value>true</value>
            </parameter>
 

</ResourceParams>
 
Regards,
Amir S