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:@server_name:1521:DEV</value>
      </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

Reply via email to