 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Struts - A MVC web framework | | Tomcat - JSP/Servlet container | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | | JSP - A mailing list about Java Server Pages specification and reference | |
Struts & Hibernate
|
|
|
| | | Problem in Connection Pooling | Problem in Connection Pooling 2003-12-23 - By Edson Alves Pereira
Back
You must put ojdbc14.jar inside $TOMCAT_HOME/common/lib
:D
> -- ---- --
> De: Kumar Abhay-CAK203C[SMTP:CAK203C@(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:@(protected):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
>
|
|
|
