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

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -