Hi, I'm trying to learn Hibernate, so I'm doing a tutorial (Michael Glögl's,
www.gloegl.de)
which uses HSQLDB, but in the start-up, when the configuration is
asked to build a session factory, it hums along, but then I get:
Error- could not get database metadata
java.sql.SQLException: Table not found in statement [select sequence_name from system_sequence]
My dialect property is set to org.hibernate.dialect.HSQLDialect.
I switched to MySQL and my code works (with the appropriate dialect property),
but I'd still like to be able to use HSQLDB in unit testing. Does anyone
know what's going wrong?
I had just downloaded the current production versions of Hibernate
and HSQLDB for this tutorial.
Hibernate version: 3.0.5
HSQLDB version: 1.8.0.2