error in script file line: 1 Unexpected token UNIQ

2019-07-11 19:04发布

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条回答
神经病院院长
2楼-- · 2019-07-11 19:46

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

查看更多
登录 后发表回答