error in script file line: 1 Unexpected token UNIQ

问题:

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

回答1:

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).