Also, you may want to look at configuring your webapp outside of server.xml using the tomcat/Catalina/localhost/ROOT.xml method
I recently discussed this here http://www.adcworks.com/blog/index.php/archives/2004/11/14/getting-up-and-running-with-tomcat-55 Hope it helps, ADC. > -----Original Message----- > From: Ed Sykes [mailto:[EMAIL PROTECTED] > Sent: 15 November 2004 16:49 > To: [EMAIL PROTECTED] > Subject: Cannot create JDBC driver of class '' for connect URL 'null' > > > Hi, > > > > I'm trying to setup DBCP with Tomcat 5.5.4 with Oracle 8.1.6 > using Java 1.5.0 > > > > I've read FAQ, and the Jakarta How-To Docs: > > http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasourc > e-examples-howto.html > > > > Everything works fine if I don't use connection pooling or > JNDI lookups. > > i.e., > > > > Class.forName(Connection_Info.JDBC_DRIVER); > > conn = DriverManager.getConnection(URL, USERNAME, PASSWORD); > > stmt = conn.createStatement(); > > > > works fine. So, Tomcat finds the Oracle JDBC driver fine. > > > > I'm getting the following error: > > > > Cannot create JDBC driver of class '' for connect URL 'null' > > > > Here's is the section I've added to > C:\jakarta-tomcat-5.5.4\conf\server.xml > > > > <Context path="/ROOT/WEB-INF/classes" > docBase="ROOT/WEB-INF/classes/JITS" > > debug="5" reloadable="true" crossContext="true"> > > > > <Resource name="jdbc/myoracle" auth="Container" > > type="javax.sql.DataSource" > driverClassName="oracle.jdbc.driver.OracleDriver" > > url="jdbc:oracle:thin:@newton.sheridanc.on.ca:1522:DB2" > > username="jits" password="mypassword" > maxActive="20" maxIdle="10" > > maxWait="-1"/> > > > > <ResourceParams name="jdbc/myoracle"> > > <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:@newton.sheridanc.on.ca:1522:DB2</value> > > </parameter> > > <parameter> > > <name>username</name> > > <value>jits</value> > > </parameter> > > <parameter> > > <name>password</name> > > <value>mypassword</value> > > </parameter> > > <parameter> > > <name>maxActive</name> > > <value>20</value> > > </parameter> > > <parameter> > > <name>maxIdle</name> > > <value>10</value> > > </parameter> > > <parameter> > > <name>maxWait</name> > > <value>-1</value> > > </parameter> > > </ResourceParams> > > > > > > </Context> > > > > > > > > > > Here's the contents of > C:\jakarta-tomcat-5.5.4\webapps\ROOT\WEB-INF\web.xml > > > > > > <servlet> > > <servlet-name>JITS.ImageServer</servlet-name> > > <servlet-class>JITS.ImageServer</servlet-class> > > </servlet> > > > > <servlet-mapping> > > <servlet-name>JITS.ImageServer</servlet-name> > > <url-pattern>/servlet/JITS.ImageServer</url-pattern> > > </servlet-mapping> > > > > <resource-ref> > > <description>Oracle Datasource example</description> > > <res-ref-name>jdbc/myoracle</res-ref-name> > > <res-type>javax.sql.DataSource</res-type> > > <res-auth>Container</res-auth> > > </resource-ref> > > > > > > > > In my java file ( ImageServer.java ) : > > > > > > Context initContext = new InitialContext(); > > System.out.println("1 got an initial context from JNDI"); > > > > Context envContext = > (Context)initContext.lookup("java:/comp/env"); > > System.out.println("2 got a context from JNDI"); > > > > DataSource ds = > (DataSource)envContext.lookup("jdbc/myoracle"); > > System.out.println("3 got a datasource from JNDI"); > > > > > > Connection conn = ds.getConnection(); > > System.out.println("4 got a connection from the pool"); > > > > > > > > OUTPUT: > > 1 got an initial context from JNDI > > 2 got a context from JNDI > > 3 got a datasource from JNDI > > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create > JDBC driver of class '' for connect URL 'null' > > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(B > asicDataSource.java:780) > > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(Basi > cDataSource.java:554) > > at JITS.ImageServer.getImage(ImageServer.java:48) > > > > > > Any suggestions would be gratefully appreciated ! > > > > Sincerely, > > Ed Sykes > > > > > <FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE> ------------------------------------------------------- QAS Ltd. Developers of QuickAddress Software <a href="http://www.qas.com";>www.qas.com</a> Registered in England: No 2582055 Registered in Australia: No 082 851 474 ------------------------------------------------------- </FONT> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
