Whenever I connect to HSQLDB from my application deployed on eclipse Juno, it throws an exception as : java.sql.SQLException: error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE]
I have searched for the solution and the same problem was solved under JBoss 5.x, but I am not able to understand which version of hsqldb.jar I should replace the existing jar file with. I am working on CentOS
You need the latest version of HSQLDB jar, currently 2.2.9.
Your database files are version 2.x, but the jar you are using is probably 1.8.x or earlier. It is important to use the same jar version (major.minor).