Uploaded image for project: 'Tools (JBoss Tools)'
  1. Tools (JBoss Tools)
  2. JBIDE-20983

cannot use oracle service name in datasource creation

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.2.2.Final
    • Fix Version/s: 4.10.x
    • Component/s: upstream
    • Labels:
      None
    • Workaround Description:
      Hide

      after creating with a ":", edit the resulting datasource manually and set the "/"

      Show
      after creating with a ":", edit the resulting datasource manually and set the "/"

      Description

      When connecting to an Oracle data source, a SID is required for a connection and a service name can not be used.

      The Oracle URL formats are:

      With a SID you use ":sid" at the end

      jdbc:oracle:thin:@//oraclehost:1521:mysid

      with a service name you use "/myservicename"

      jdbc:oracle:thin:@//oraclehost:1521/myservicename

      The dialog box prevent removing the ":" and replacing it with the needed "/"
      (not even via the driver definition where you seem to be allowed to set the url format...)

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                koen.aers Koen Aers
                Reporter:
                tfonteyn Tom Fonteyne
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: