Hypersonic/Tomcat-5/ WinXP config

[Tom K]

Does anyone have a simple examples of configuring the Hypersonic SQL
Database working with Tomcat-5.19 ?
 
I have looked at all the Documentation and set up the classpath
variables but still seem to get the error message:
java.lang.ClassNotFoundException: org.hsqldb.jdbcDriver
 
 
Thanks in advance,
 
Tom K.
 
 
 
I have the hsqldb.jar file in my applications \lib directory and have
the server.xml 
Context set up as follows:
      <Context docBase="C:\\jakarta-tomcat-5.0.19\\webapps\\cheers"
path="/cheers">
                  <Resource name="jdbc/cheerdb"
type="javax.sql.DataSource"/>
                  <ResourceParams name="jdbc/cheerdb">
                        <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>
            </Context>
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003