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

cannot use oracle service name in datasource creation

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • 4.30.x
    • 4.2.2.Final
    • upstream
    • None
    • 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...)

      Attachments

        Activity

          People

            kaers@redhat.com Koen Aers
            tfonteyn Tom Fonteyne (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: