Re: Hypersonic/Tomcat-5/ WinXP config

[Peter Rossbach]

Hello Tom,

a resource generate with the server Classloader. Please put  your 
hsqldb.jar also at
common/lib and all working well.

regards
Peter
http://tomcat.objektpark.org

Tom K schrieb:

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
 



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