JNDI Problem

[Bussie, Andre D]

Trying to set access datasource via JNDI. Using Tomcat 5.0.19 however I
get the following error message

Cannot create JDBC driver of class '' for connect URL 'null', cause:
null

 

Here is my server.xml file snippet

<GlobalNamingResources>

<Resource name="hsqldb" type="javax.sql.DataSource"/>

<ResourceParams name="hsqldb">

      <parameter>

        <name>maxWait</name>

        <value>5000</value>

      </parameter>

      <parameter>

        <name>maxActive</name>

        <value>4</value>

      </parameter>

      <parameter>

        <name>password</name>

        <value></value>

      </parameter>

      <parameter>

        <name>url</name>

        <value>jdbc:hsqldb.hsql://localhost</value>

      </parameter>

      <parameter>

        <name>driverClassName</name>

        <value>org.hsqldb.jdbcDriver</value>

      </parameter>

      <parameter>

        <name>maxIdle</name>

        <value>2</value>

      </parameter>

      <parameter>

        <name>username</name>

        <value>sa</value>

      </parameter>

  </ResourceParams>

 </GlobalNamingResources>

 

Here is web.xml snippet

<!-- JNDI Resource Declarations -->

  <resource-ref>

   <description>Resource reference to a HSQLDB datasource instance

     that is configured in the server.xml file.

   </description>

   <res-ref-name>hsqldb</res-ref-name>

   <res-type>javax.sql.DataSource</res-type>

   <res-auth>Container</res-auth>

  </resource-ref>

 

JSP code to access 

Context initContext = new InitialContext();

Context envContext  = (Context)initContext.lookup("java:/comp/env");

DataSource ds = (DataSource)envContext.lookup("hsqldb");

Connection conn = ds.getConnection();

 

 

I followed the instructions from the tomcat web page what is causing
this and how can I get this resolved to access the datasource through
JNDI. 

 

Anyone .........