Problem with Oracle/Global Naming Resource

[Roberts, Eric]

I am getting the following error when attempting to load the Oracle database driver as 
a globally pooled resource:

java.sql.SQLException: Cannot load JDBC driver class 'null'
        at 
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:529)
        at 
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)

It works fine if I either give my application an explicit context in server.xml or put 
the same entries in a DefaultContext.

Any ideas?

My server.xml entries are:

  <!-- Global JNDI resources -->
  <GlobalNamingResources>

  <!-- Database Connection Pool Definition -->
  <Resource name="TESTdb"
               type="javax.sql.DataSource"
                auth="Container"
                scope="Shareable">
</Resource>
  <ResourceParams name="TESTdb">
    <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:@dbtst:1521:scott</value>
    </parameter>

    <parameter>
     <name>username</name>
     <value>scott</value>
    </parameter>

    <parameter>
     <name>password</name>
     <value>tiger</value>
    </parameter>

    <parameter>
      <name>maxActive</name>
      <value>100</value>
    </parameter>

    <parameter>
      <name>maxIdle</name>
      <value>3</value>
    </parameter>

    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>

    <parameter>
       <name>removeAbandoned</name>
       <value>true</value>
    </parameter>

    <parameter>
       <name>removeAbandonedTimeout</name>
       <value>60</value>
    </parameter>

    <parameter>
       <name>logAbandoned</name>
       <value>true</value>
    </parameter>
  </ResourceParams>
</GlobalNamingResources>

My web.xml entries are:

  <resource-ref>
      <res-ref-name>TESTdb</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
      <res-sharing-scope>Shareable</res-sharing-scope>
  </resource-ref>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>