Hi,
I have set up Tomcat 4.1.31 with a JDBC pool using the settings below.
However I 'm a bit confused about my the way this works.
1. InitialSize is set to 5 yet I don't see any connections started after
Tomcat is bounced.
2. Some of the older connections are not getting cleared down.
3. Although maxIdle is set to 5, I still get more than 5 idle connections.
I have referred to the documentation on:
http://jakarta.apache.org/commons/dbcp/configuration.html
and tried to set accordingly as below. Could someone with more experience
comment on these please, and recommend any changes I need to make?
Many thanks,
Ed.
<Context path="/POL" docBase="/b7/apache/b7uat08/webapps/POL"
debug="0">
<Logger className="
org.apache.catalina.logger.FileLogger"
prefix="POL." suffix=".log" timestamp="true"/>
<Resource name="jdbc/pol" auth="Container"
type="
javax.sql.DataSource"/>
<ResourceParams name="jdbc/pol">
<parameter>
<name>factory</name>
<value>
org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>xxxxxxx</value>
</parameter>
<parameter>
<name>password</name>
<value>xxxxxxx</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value></value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@(protected)>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>initialSize</name>
<value>5</value>
</parameter>
<parameter>
<name>minIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>validationQuery</name>
<value>select 1 from dual</value>
</parameter>
<parameter>
<name>testOnBorrow</name>
<value>true</value>
</parameter>
<parameter>
<name>testOnReturn</name>
<value>false</value>
</parameter>
<parameter>
<name>testWhileIdle</name>
<value>true</value>
</parameter>
<parameter>
<name>minEvictableIdleTimeMillis</name>
<value>60000</value>
</parameter>
<parameter>
<name>timeBetweenEvictionRunsMillis</name>
<value>120000</value>
</parameter>
<parameter>
<name>numTestsPerEvictionRun</name>
<value>10</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>5</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
</Context>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)
