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

Configuration tool should generate thin-style service name Oracle JDBC URLs

XMLWordPrintable

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

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

      The current JIRA configuration tool generates old-style Oracle JDBC URLs that specify a SID. This can be problematic for two reasons:

      1. High-availability clusters can only be connected to using the service name using a newer URL syntax
      2. The Oracle documentation says that the old syntax is no longer supported as of 10g

      Please update the configuration tool to generate the service name type URLs. Right now customers like us who are using HA configurations are forced to edit dbconfig.xml by hand.

      More info:
      http://docs.oracle.com/cd/E11882_01/java.112/e16548/urls.htm#BEIDHCBA
      http://www.orafaq.com/wiki/JDBC#Thin_driver

            [JRASERVER-29755] Configuration tool should generate thin-style service name Oracle JDBC URLs

            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3057750 ] New: JAC Suggestion Workflow 3 [ 3686038 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2612296 ] New: JAC Suggestion Workflow [ 3057750 ]
            Rachel Lin (Inactive) made changes -
            Workflow Original: JIRA PM Feature Request Workflow v2 - TEMP [ 2573894 ] New: Confluence Workflow - Public Facing v4 [ 2612296 ]
            Status Original: Closed [ 6 ] New: Resolved [ 5 ]
            Ignat (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - TEMP [ 2354588 ] New: JIRA PM Feature Request Workflow v2 - TEMP [ 2573894 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 2121912 ] New: JIRA Bug Workflow w Kanban v6 - TEMP [ 2354588 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - TEMP [ 2083316 ] New: JIRA Bug Workflow w Kanban v6 [ 2121912 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 884791 ] New: JIRA Bug Workflow w Kanban v6 - TEMP [ 2083316 ]
            jonah (Inactive) made changes -
            Description Original: The current JIRA configuration tool generates old-style Oracle JDBC URLs that specify a SID. This can be problematic for two reasons:

            # High-availability clusters can only be connected to using the service name using a newer URL syntax
            # The Oracle documentation says that the old syntax is no longer supported as of 10g

            Please update the configuration tool to generate the service name type URLs. Right now customers like us who are using HA configurations are forced to edit dbconfig.xml by hand.

            More info:
            http://docs.oracle.com/cd/E11882_01/java.112/e16548/urls.htm#BEIDHCBA
            http://www.orafaq.com/wiki/JDBC#Thin_driver
            		New: {panel:bgColor=#e7f4fa}
              *NOTE:* This suggestion is for *JIRA Server*. Using *JIRA Cloud*? [See the corresponding suggestion|http://jira.atlassian.com/browse/JRACLOUD-29755].
              {panel}

            The current JIRA configuration tool generates old-style Oracle JDBC URLs that specify a SID. This can be problematic for two reasons:

            # High-availability clusters can only be connected to using the service name using a newer URL syntax
            # The Oracle documentation says that the old syntax is no longer supported as of 10g

            Please update the configuration tool to generate the service name type URLs. Right now customers like us who are using HA configurations are forced to edit dbconfig.xml by hand.

            More info:
            http://docs.oracle.com/cd/E11882_01/java.112/e16548/urls.htm#BEIDHCBA
            http://www.orafaq.com/wiki/JDBC#Thin_driver
            jonah (Inactive) made changes -
            Link New: This issue relates to JRACLOUD-29755 [ JRACLOUD-29755 ]
            Oswaldo Hernandez (Inactive) made changes -
            Workflow Original: JIRA PM Feature Request Workflow v2 [ 712246 ] New: JIRA Bug Workflow w Kanban v6 [ 884791 ]

              mlassau Mark Lassau (Inactive)
              35ff593b8f05 Lars Hannelius
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: