> Here is the entry from my server.xml file:

> <Resource name="jdbc/TestDB" auth="container" 
type="javax.sql.DataSource"/>
<> ResourceParams name="jdbc/TestDB">
<> parameter>
<> name>driverClassName</name>     <========================
<> value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
<> /parameter>
<> parameter>
<> name>url</name>
<> value>jdbc:microsoft:sqlserver://brad:1433</value>
<> /parameter>
<> parameter>
<> name>username</name>
<> value>TestDB</value>
<> /parameter>
<> parameter>
<> name>password</name>
<> value>password</value>
<> /parameter>
<> parameter>
<> name>driverClassName</name>   <====================
<> value>foo.bar.Driver</value>  <==== this is a dummy i think...
<> /parameter>
<> parameter>
<> name>maxActive</name>
<> value>20</value>
<> /parameter>
<> parameter>
<> name>maxIdle</name>
<> value>30000</value>
<> /parameter>
<> parameter>
<> name>maxWait</name>
<> value>100</value>
<> /parameter>
<> /ResourceParams>

i'm not sure if this is the problem, but why have you two driver in this 
Resource???

did you ever get this to work?  I am trying to set up a resource to 
connect to an oracle database and always get the following message:

SQLException caught: Cannot load JDBC driver class 'null' 

--servlet--
Context ctx = new InitialContext();
Context env = (Context)ctx.lookup("java:comp/env");
DataSource ds = (DataSource) env.lookup("jdbc/gdm");
Connection con = ds.getConnection();

--web.xml--
<resource-ref>
  <res-ref-name> jdbc/gdm </res-ref-name>
  <res-type> javax.sql.DataSource </res-type>
  <res-auth> Container </res-auth>
</resource-ref>

--server.xml--
<Resource name="jdbc/gdm" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/gdm">
  <parameter>
    <name>driverClassName</name>
    <value>oracle.jdbc.driver.OracleDriver</value>
  </parameter>
  <parameter>
    <name>url</name>
    <value>jdbc:oracle:thin:@localhost:1521:GDM</value>
  </parameter>
  <parameter>
    <name>username</name>
    <value>GDMU</value>
  </parameter>
  <parameter>
    <name>password</name>
    <value>GDMU</value>
  </parameter>
  <parameter>
    <name>maxActive</name>
    <value>20</value>
  </parameter>
  <parameter>
    <name>maxIdle</name>
    <value>30000</value>
  </parameter>
  <parameter>
    <name>maxWait</name>
    <value>100</value>
  </parameter>
</ResourceParams>

I have also tried using the Tomcat administration tool which puts the 
values in the <GlobalNamingResources> area but I still can't connect.

Any ideas?

yes, it works for me, but with a mysql driver, connecting to a mysql
database.
i've used the configuration settings described in tomcat documentation,
section "JNDI Datasource HOW-TO".

Alex

----- Original Message -----
From: "Jon Pierson" <jon.pierson@e...>
To: "Tomcat" <apache_tomcat@p...>
Sent: Tuesday, February 18, 2003 9:53 PM
Subject: [apache_tomcat] Re: Problems getting a DataSource to talk from my
Tomcat app to SQL Server 2000


> did you ever get this to work?  I am trying to set up a resource to
> connect to an oracle database and always get the following message:
>
> SQLException caught: Cannot load JDBC driver class 'null'
>
> --servlet--
> Context ctx = new InitialContext();
> Context env = (Context)ctx.lookup("java:comp/env");
> DataSource ds = (DataSource) env.lookup("jdbc/gdm");
> Connection con = ds.getConnection();
>
> --web.xml--
> <resource-ref>
>   <res-ref-name> jdbc/gdm </res-ref-name>
>   <res-type> javax.sql.DataSource </res-type>
>   <res-auth> Container </res-auth>
> </resource-ref>
>
> --server.xml--
> <Resource name="jdbc/gdm" auth="Container" type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/gdm">
>   <parameter>
>     <name>driverClassName</name>
>     <value>oracle.jdbc.driver.OracleDriver</value>
>   </parameter>
>   <parameter>
>     <name>url</name>
>     <value>jdbc:oracle:thin:@localhost:1521:GDM</value>
>   </parameter>
>   <parameter>
>     <name>username</name>
>     <value>GDMU</value>
>   </parameter>
>   <parameter>
>     <name>password</name>
>     <value>GDMU</value>
>   </parameter>
>   <parameter>
>     <name>maxActive</name>
>     <value>20</value>
>   </parameter>
>   <parameter>
>     <name>maxIdle</name>
>     <value>30000</value>
>   </parameter>
>   <parameter>
>     <name>maxWait</name>
>     <value>100</value>
>   </parameter>
> </ResourceParams>
>
> I have also tried using the Tomcat administration tool which puts the
> values in the <GlobalNamingResources> area but I still can't connect.
>
> Any ideas?