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:[EMAIL PROTECTED] 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
