Hi,

I am using the hsqldb db version 1.7.3.3. I am able to create the tables and I see the tables from the Database Manager. Hibernate version is 3.0.

When I run the example to save Product object I get SQL exception : Table Not Found in the insert statement "products". I am able to see the products table in the Database Manager. This happens at the line tx.commit.

Any pointers on how to use hsqldb with Hibernate is appreciated.

Thanks,
BP

P.S : I did read the "Read this first!", but after reading it I have spent almost 5 hours trying to resolve this by myself.

Here is some more information :

My properties file is:
hibernate.connection.username=sa
hibernate.connection.password=
hibernate.connection.url=jdbc:hsqldb:D:\db\order
hibernate.connection.driver_class=org.hsqldb.jdbcDriver
hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect


And I am getting the following exception:
SEVERE: could not insert: [test.hibernate.Product#2c999c44fb821dc300fb821dc64c0001]
java.sql.SQLException: Table not found: PRODUCTS in statement [insert into products (name, price, amount, id) values (?, ?, ?, ?)]