Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE])

jboss5.x hsqldb sqldatasource
Satya picture Satya · Feb 9, 2011 · Viewed 9.2k times · Source

Whenever I connect to HSQLDB from my application deployed on JBoss 5.1, it throws exception as : Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE]) .

My HSQLDB script file reads something as below : `SET DATABASE UNIQUE NAME HSQLDB2E0BAD63B3

SET DATABASE GC 0

SET DATABASE DEFAULT RESULT MEMORY ROWS 0

SET DATABASE EVENT LOG LEVEL 0

.....`

Does anyone have idea what thos exception means or should I change something in my HSQLDB configuration?

Regards, Satya

Answer

fredt picture fredt · Feb 9, 2011

Your database files are created with version 2.x, but the version of database engine running on JBoss 5.1 is 1.8.x. You should be able to replace the hsqldb.jar in the JBoss configuration with a new version.

Related questions

How to deploy a war file in JBoss AS 7?

I downloaded JBoss Application Server 5 and successfully deployed a war file. I copypasted the Hello.war which has a simple index.jsp file into \jboss-5.1.0.GA-jdk6\jboss-5.1.0.GA\server\default\deploy and it worked fine. However when I used JBoss …

Read More
Error starting jboss server

I've just finished re-installing my OS, and as always install and test standard tools which I use, and now I get this error like never before when I tried to start Jboss 5 from eclipse, its quite big exeption : 3:53:10,693 ERROR [AbstractKernelController] …

Read More
JBoss transaction timeout setting?

We have a timer service triggered task in JBoss 5.1.0.GA application and the problem is that we cannot change the transaction time out. This long Lucene indexing can take longer than the default 300 second limit. The question is how to …

Read More