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:@sunlhrd36.abc.com:1538:ZJUPT</value>
                       </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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to