Re: [dbcp] Howto monitor JDBC Connections on tomcat 4.1.29

[Dirk Verbeeck]

You can use my showJNDI.jsp page to check your JNDI datasources.
Download it from here:
http://cvs.apache.org/~dirkv/builds/
There isn't a ready to be used monitor servlet, contributions welcome ;-)

-- Dirk

Dirk R�ttgers, wega Informatik AG wrote:

I'd like to monitor the number of active / idle JDBC Connections on 
tomcat 4.1.29.
Is there a (tomcat) build in tool, script, log where i can find more 
information on how the pool works, and which resources are used?

Are there any JAVA/Servlet/JSP/Taglib Sources which can be used to 
monitor activities or check at least the pool dynamically?

At our site the the JDBC Connection is defined as a JNDI Datasource in 
the server.xml DefaultContext as follows

<DefaultContext  debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/xxxDataSource"
          auth="Container"
          type="javax.sql.DataSource"
          />
 <ResourceParams name="jdbc/xxxDataSource">
     <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:@...</value>
     </parameter>
     <parameter>
      <name>maxActive</name>
      <value>200</value>
     </parameter>
     <parameter>
      <name>maxIdle</name>
      <value>40</value>
     </parameter>
     <parameter>
      <name>maxWait</name>
      <value>10000</value>
     </parameter>
    ...
Thanks for your kind help.
    Dirk



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