jboss5.x - Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE]) -
whenever connect hsqldb application deployed on jboss 5.1, throws exception : caused by: org.jboss.resource.jbossresourceexception: 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 below : `set database unique name hsqldb2e0bad63b3
set database gc 0
set database default result memory rows 0
set database event log level 0
.....`
does have idea thos exception means or should change in hsqldb configuration?
regards, satya
your database files created version 2.x, version of database engine running on jboss 5.1 1.8.x. should able replace hsqldb.jar in jboss configuration new version.
Comments
Post a Comment