I am using hsqldb 2.2.8 version with
here is the error:
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found:
I tried to change versions of both hibernate and hsqldb but couldnt find a solution to solve this problem. Do you have any suggestion on which version of hsqld suitable with which version of hibernate?
The best way to use hsqldb is let hibernate create tables, using schema ddl and data sql files is not a good choice.