Details
-
Bug
-
Resolution: Won't Fix
-
Low
-
None
-
3.13
-
MSSQL 2005
-
3.13
-
Description
JIRA does not escape the schema name stored in the entityengine.xml file. This can lead to SQL Errors if the schema name contains special characters.
Steps to recreate:
- create a schema such as jira-schema
- set the schema to jira-schema in entityengine.xml
- start JIRA
In the case above with the schema name as jira-schema JIRA will throw SQL Exceptions java.sql.SQLException: Incorrect syntax near '-'. when it tires to create the tables for JIRA.
The workaround is to manually escape the schema name in the entityengine.xml file. In the case of SQL Server 2005 you simply enter [jira-schema]