You must put ojdbc14.jar inside $TOMCAT_HOME/common/lib
:D
> ----------
> De: Kumar Abhay-CAK203C[SMTP:[EMAIL PROTECTED]
> Responder: Tomcat Users List
> Enviada: segunda-feira, 22 de dezembro de 2003 22:52
> Para: Tomcat Users List
> Assunto: Problem in Connection Pooling
> Prioridade: Alta
>
> 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
>
