Tomcat DataSource Configuration Problem

[Rahul Gupta]

Hi,
I have configured Tomcat to connect to Oracle Database. However it gives the following exception.
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause:
java.sql.SQLException: No suitable driver
The server.xml file is as follows:

<?xml version='1.0' encoding='utf-8'?>
<Server>
  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
  <GlobalNamingResources>
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
    <Resource auth="Container" description="User database that can be updated and saved" 
      name="UserDatabase" type="org.apache.catalina.UserDatabase"/>
    <Resource auth="Container" name="jdbc/OracleAdmin" type="javax.sql.DataSource"/>
    <ResourceParams name="UserDatabase">
      <parameter>
        <name>factory</name>
        <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
      </parameter>
      <parameter>
        <name>pathname</name>
        <value>conf/tomcat-users.xml</value>
      </parameter>
    </ResourceParams>
    <ResourceParams name="jdbc/OracleAdmin">
      <parameter>
        <name>validationQuery</name>
        <value>select * from acc_user</value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:oracle:thin:@B3-3F094-8B1Q:1521:UBS</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>aw_dbo</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>aw_dbo</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>2</value>
      </parameter>
    </ResourceParams>
  </GlobalNamingResources>
  <Service name="Catalina">
    <Connector acceptCount="100" connectionTimeout="20000" disableUploadTimeout="true" 
       port="8080" redirectPort="8443">
    </Connector>
    <Connector port="8009" protocol="AJP/1.3" protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler"
      redirectPort="8443">
    </Connector>
    <Engine defaultHost="localhost" name="Catalina">
      <Host appBase="webapps" name="localhost">
        <Logger className="org.apache.catalina.logger.FileLogger"
           prefix="localhost_log." suffix=".txt" timestamp="true"/>
      </Host>
      <Logger className="org.apache.catalina.logger.FileLogger"
           prefix="catalina_log." suffix=".txt" timestamp="true"/>
      <Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
    </Engine>
  </Service>
</Server>

I have seen this problem in various forums however no one has been able to give a clear answer. I hope somebody out there has faced similar problem earlier and found a solution.
Awaiting your suggestions and replies.
[ jess disabled smilies and added [code] tags ]
[ May 04, 2004: Message edited by: Jessica Sant ]

[Jessica Sant]

moving this to the Tomcat forum.

[Mike Curwen]

did you put classes12.jar (or whatever contains oracle.jdbc.driver.OracleDriver) into common/lib ?

also, many users report problems trying to configure DataSources as a global jndi resource. have you tried declaring your datasource inside of the Context that will be using it. If you do this, you also won't have to remember to insert a ResourceLink into your Context.