Hi, I am new to hibernate, and could not find any topic on hsqldb as a servlet - Has anyone tried to install hsqldb as a servlet in tomcat 5.x? From what i could find on the web, it looks like all i need are the following changes. It doesn't work... any ideas??

1) In the web.xml file, add the servlet lines to start hsqldb as a servlet

<servlet>
<servlet-name>HSQLDB-Servlet</servlet-name>
<servlet-class>org.hsqldb.Servlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>

2) In the hibernate.cfg.xml, set the url to http://localhost

<!-- Settings for a local HSQL (testing) database. -->
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="connection.url">jdbc:hsqldb:http://localhost</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>


thanks,
Suresh
--

Any JDBC connect string that works for JDBC will work for Hibernate. If you think something isn't working inside Hibernate, please follow the directions and post error logs, etc. I am reasonably sure that this is a configuration issue with HSQLDB though.

Thanks,

Chris