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: