Hello,

I am trying to set up connection pooling with Tomcat 4.1.29 and Oracle 9i
I am getting the below error:

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause:java.sql.SQLException: No suitable driver

Please tell me what to do to resolve this. I am able to lookup dB. But on trying to fetch data from dB I am getting this error.

Please Help

Regards
Abhay

Details:

Server.xml
  <Resource name="estimation" scope="Shareable" type="javax.sql.DataSource"/>
  <ResourceParams name="estimation">
   <parameter>
    <name>validationQuery</name>
    <value>select sysdate from dual</value>
   </parameter>
   <parameter>
    <name>maxWait</name>
    <value>5000</value>
   </parameter>
   <parameter>
    <name>maxActive</name>
    <value>4</value>
   </parameter>
   <parameter>
    <name>password</name>
    <value>pass</value>
   </parameter>
   <parameter>
    <name>url</name>
    <value>jdbc:oracle:thin:@(protected)>
   </parameter>
   <parameter>
    <name>driverClassName</name>
    <value>oracle.jdbc.driver.OracleDriver</value>
   </parameter>
   <parameter>
    <name>maxIdle</name>
    <value>2</value>
   </parameter>
   <parameter>
    <name>username</name>
    <value>eppsys</value>
   </parameter>
  </ResourceParams>


    <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" displayName="Estimation" docBase="C:\Estimation" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/Estimation" privileged="false" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">

      <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_estimation_log." suffix=".txt" timestamp="true" verbosity="1"/>

    </Context>

Web.xml

<resource-ref>
 <res-ref-name>jdbc/estimation</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Shareable</res-auth>
</resource-ref>

Class Path

.;C:\Estimation;C:\Tomcat\common\lib\servlet.jar;C:\Tomcat\common\lib\mail.jar;C:\Tomcat\common\lib\activation.jar;C:\Tomcat\common\lib\jndi.jar;C:\Tomcat\common\lib\jdbc2_0-stdext.jar;C:\Tomcat\common\lib\classes12.jar

Tried with oracle.jar and ojdbc14.jar