tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Darian Shimy <DSh...@24hourfit.com>
Subject Connection Pool exceeding MaxActive limit
Date Tue, 22 Apr 2003 18:09:44 GMT
We are having a problem where the number of connections to the Oracle
database is exceeding the limit set in maxActive.  We are using Tomcat
4.1.12 with jdk 1.3.1.

Server.xml:
<Resource name="jdbc/applicationDS" auth="Container"
type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/applicationDS">
 <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:@server:1522:sid</value>
  </parameter>
  <parameter>
    <name>username</name>
    <value>username</value>
  </parameter>
  <parameter>
    <name>password</name>
    <value>password</value>
  </parameter>
  <parameter>
    <name>maxActive</name>
    <value>20</value>
  </parameter>
  <parameter>
    <name>maxIdle</name>
    <value>3</value>
  </parameter>
  <parameter>
    <name>maxWait</name>
    <value>-1</value>
  </parameter>
  <parameter>
    <name>validationQuery</name>
    <value>select count(1) from dual</value>
  </parameter>
</ResourceParams>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message