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