struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ben Anderson" <stuts_anderson...@hotmail.com>
Subject RE: Oracle DataSource configuration
Date Mon, 29 Dec 2003 16:47:12 GMT
not sure if this matters, but my oracle jar is in common/lib instead of 
shared/lib.  I'm not familiar with the differences/uses of common and 
shared, but that's how mine works.
-Ben


>From: "Ed Dowgiallo" <edowgial@ptdprolog.net>
>Reply-To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
>To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
>Subject: Oracle DataSource configuration
>Date: Mon, 29 Dec 2003 11:12:11 -0500
>
>I'm running into the following exception when issuing a getConnection to an 
>Oracle DataSource.
>
>SQLException: Cannot create JDBC driver of class '' for connect URL 'null'
>
>It has the following definition in a Tomcat 4.1.29 server.xml file.
>
><Resource name="Library" auth="Container" scope="Shareable" 
>type="javax.sql.DataSource"/>
>
></ResourceParams>
>
><ResourceParams name="Library">
>
><parameter>
>
><name>factory</name>
>
><value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
>
></parameter>
>
><parameter>
>
><name>driverClassName</name>
>
><value>oracle.jdbc.driver.OracleDriver</value>
>
></parameter>
>
><parameter>
>
><name>url</name>
>
><value>jdbc:oracle:thin:@192.168.0.202:1521:tpeds002</value>
>
></parameter>
>
><parameter>
>
><name>username</name>
>
><value>abc</value>
>
></parameter>
>
><parameter>
>
><name>password</name>
>
><value>xyz</value>
>
></parameter>
>
><parameter>
>
><name>maxActive</name>
>
><value>25</value>
>
></parameter>
>
><parameter>
>
><name>maxIdle</name>
>
><value>10</value>
>
></parameter>
>
><parameter>
>
><name>maxWait</name>
>
><value>-1</value>
>
></parameter>
>
></ResourceParams>
>
>I have setup the following resource-ref in the applications web.xml file.
>
>   <resource-ref>
>     <description>Oracle DataSource</description>
>     <res-ref-name>Library</res-ref-name>
>     <res-type>javax.sql.DataSource</res-type>
>     <res-auth>Container</res-auth>
>   </resource-ref>
>
>The JDBC library is a class12.jar file in the Tomcat shared/lib directory.
>
>Comments and suggestions are most welcome.
>
>Thank you,
>
>Ed
>---------------------------------------------------------------------
>To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: struts-user-help@jakarta.apache.org

_________________________________________________________________
Check your PC for viruses with the FREE McAfee online computer scan.  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org


Mime
View raw message