Oracle connection pooling

[Sinclair, Alan (CORP, GEAccess)]

All,
On Tomcat 4.0.6, I have been trying most unsuccessfully to setup a JDBC
connection pool to Oracle,  it is driving me to the point of insanity. I
copied  classes12.jar, commons-collections.jar, commons-dbcp.jar,
commons-pool.jar  into $CATALINA_HOME/common/lib 

This is the server.sml snippet for the data source:

<Resource name="jdbc/dev" auth="Container"
                    type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/dev">
             <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:@10.0.0.xx:1522:dev</value>
             </parameter>
             <parameter>
               <name>user</name>
               <value>whatever</value>
             </parameter>
             <parameter>
               <name>password</name>
               <value>whatever</value>
             </parameter>
             <parameter>
               <name>maxActive</name>
               <value>5</value>
             </parameter>
             <parameter>
               <name>maxIdle</name>
               <value>3</value>
             </parameter>
             <parameter>
               <name>maxWait</name>
               <value>-1</value>
             </parameter>
          </ResourceParams>

When Tomcat is restarted, there are no connections to the database. What
have I missed ?  Where does Tomcat write the JDBC logging info - there is
nothing in logs/catalina.out     I presume when Tomcat starts, the db
connections should be initiated with the database but there are none.  I
have no idea where to go from here.

Any help would be most appreciated.

Regards,



--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>