Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-15952

JIRA does not escape database schema when it contains special characters

    XMLWordPrintable

Details

    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:

      1. create a schema such as jira-schema
      2. set the schema to jira-schema in entityengine.xml
      3. 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]

      Attachments

        Activity

          People

            Unassigned Unassigned
            andrew.myers Andrew Myers [Atlassian]
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: