Automatic creation of foreign keys and indices fails on Oracle database

XMLWordPrintable

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Turning on automatic creation of foreign keys and indices while using Oracle database results in a lot of errors. This is due to the Oracle restriction that all foreign keys must be uniquely named. JIRA has multiple foreign keys with the same name. There are, for example, multiple 'ParentIssue' relations.

      I was able to make a workaround extending GenericHelperDAO to uniquely name all the foreign keys. Maybe JIRA should do that way by default.

      Uniquely naming all the foreign keys won't solve all the errors though. See the related issue.

            Assignee:
            Unassigned
            Reporter:
            Jarno Peltoniemi
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: