JUnit/HSQLDB: How to get around errors with Oracle syntax when testing using HSQLDB (no privilege and/or no DUAL object)
If you use Hibernate 3.6 with HSQLDB 2.0.1 or later, you can use a connection property sql.syntax_ora=true
on your connection URL. This enables the DUAL table together with some other Oracle specific syntax.
You probably need a few more connection properties for behaviour that is not covered by the main property. See: http://hsqldb.org/doc/2.0/guide/management-chapt.html#mtc_compatibility_oracle
The HSQL "Oracle style syntax" can also be enabled via a SQL command
SET DATABASE SQL SYNTAX ORA TRUE
See 12.30 . It's an alternative to the property sql.syntax_ora=true
as suggested in fredt's answer. It may be more practical in some cases : the flag can be set via JDBC after the HSQL database has been started.