commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <dirk.verbe...@pandora.be>
Subject Re: [dbcp] Howto monitor JDBC Connections on tomcat 4.1.29
Date Sat, 07 Feb 2004 14:23:52 GMT
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: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message