Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-29755

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

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? 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

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

            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3154191 ] New: JAC Suggestion Workflow 3 [ 3640460 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - TEMP [ 2348625 ] New: JAC Suggestion Workflow [ 3154191 ]
            Status Original: Closed [ 6 ] New: Resolved [ 5 ]
            Eric S (Inactive) made changes -
            Component/s Original: System Administration - Configuration Tool [ 46583 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 2107947 ] New: JIRA Bug Workflow w Kanban v6 - TEMP [ 2348625 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - TEMP [ 2071087 ] New: JIRA Bug Workflow w Kanban v6 [ 2107947 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 1853521 ] New: JIRA Bug Workflow w Kanban v6 - TEMP [ 2071087 ]
            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 Cloud*. Using *JIRA Server*? [See the corresponding suggestion|http://jira.atlassian.com/browse/JRASERVER-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 is related to JRASERVER-29755 [ JRASERVER-29755 ]
            vkharisma made changes -
            Project Import New: Sat Apr 01 19:36:47 UTC 2017 [ 1491075407146 ]
            Oswaldo Hernandez (Inactive) made changes -

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

                Created:
                Updated:
                Resolved: