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

Categories: Development Notes; Tagged with: HSQL • JIRA; @ March 14th, 2013 15:32

HTTP Status 500 – com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. (error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE])

type Exception report

message com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. (error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE])

description The server encountered an internal error (com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. (error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE])) that prevented it from fulfilling this request.

I got this Error after I use DbVisualizer to connect to JIRA HSQL database.

the HSQL driver version I’m using in DbVis is 2.2.9, but the driver in my JIRA is 1.8.0.5.

Solution

Update the JIRA_HOME/lib hsdb driver and restart the JIRA server.

Link: http://stackoverflow.com/questions/12969109/error-in-script-file-line-1-unexpected-token-unique-requires-collation-in-stat

SSIS: Trim the Join Fields for Merge Join <-> WordPress: change language 更改语言中文/英文