struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Muench" <Steve.Mue...@oracle.com>
Subject RE: Oracle DataSource configuration
Date Mon, 29 Dec 2003 19:44:23 GMT
Ed,
 
The setup instructions for the "BC4J/Struts Toy Store Demo" at:
 
  http://otn.oracle.com/sample_code/products/jdev/bc4jtoystore/index.html
 
 
go over the specifics of setting up Oracle DataSource for Tomcat.
 
The direct URL to the 80-page whitepaper that explains the demo's implementation and setup
is at:
 
  http://otn.oracle.com/sample_code/products/jdev/bc4jtoystore/readme.html
 
Hope this helps.
 

Steve Muench - Technical Evangelist, Product Mgr, Developer, Author
http://radio.weblogs.com/0118231/


 


  _____  

From: Ed Dowgiallo [mailto:edowgial@ptdprolog.net] 
Sent: Monday, December 29, 2003 08:12
To: Struts Users Mailing List
Subject: Oracle DataSource configuration


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


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message