KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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
Tags (comma-separated)
Save Edits
Cancel