You may need the following in your server.xml ResourceParams:
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
It's described in more detail in:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
to.html
<http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-ho
wto.html>
-----Original Message-----
From: Jonathan Drnek [mailto:[EMAIL PROTECTED]
Sent: 10 December 2003 14:37
To: [EMAIL PROTECTED]
Subject: Tomcat 5 and oracle
I am having a problem setting up a data source in tomcat. I seem to
remember having this problem last time I played with it several moths ago
but I don't remember what I did to fix it.
I am running Tomcat 5.0.16 with JVM version 1.4.2_03-b02 on windows 2000.
I am trying to connect to an Oracle 8.1.7.1.0 database.
I have placed the ojdbc14.jar file in common\lib
The error I am getting is
javax.servlet.ServletException: Cannot create JDBC driver of class '' for
connect URL 'null', cause: No suitable driver
I am using oracle.jdbc.driver.OracleDriver because that's what the docs
said, but I seem to recall that was not correct. I just can't find anything
that tells me what other driver I should be using.
My server.xml file has
.
.
.
<Resource name="jdbc/ordt" type="javax.sql.DataSource"/>
.
.
.
</ResourceParams>
<ResourceParams name="jdbc/ordt">
<parameter>
<name>validationQuery</name>
<value>select * from dual</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@holl302h:1521:ORDT</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>username</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
.
.
.
web.xml looks like
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd";>
<web-app>
<display-name>Metrology Lab</display-name>
<description>
First Source Metrology Lab
</description>
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/ordt</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
my code looks like
Context initContext = new InitialContext();
Context envContext =
(Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/ordt");
Connection conn = ds.getConnection();
Thanks for any help,
Jon Drnek
*****************************************************************
The information in this email and in any attachments is
confidential and intended solely for the attention and use
of the named addressee(s). This information may be
subject to legal professional or other privilege or may
otherwise be protected by work product immunity or other
legal rules. It must not be disclosed to any person without
our authority.
If you are not the intended recipient, or a person
responsible for delivering it to the intended recipient, you
are not authorised to and must not disclose, copy,
distribute, or retain this message or any part of it.
*****************************************************************
