[jbosstools-issues] [JBoss JIRA] (JBIDE-20983) cannot use oracle service name in datasource creation

[Alexey Kazakov (JIRA)]

     [ https://issues.jboss.org/browse/JBIDE-20983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alexey Kazakov updated JBIDE-20983:
-----------------------------------
              Project: Tools (JBoss Tools)  (was: Developer Studio (JBoss Developer Studio))
                  Key: JBIDE-20983  (was: JBDS-3403)
             Workflow: GIT Pull Request workflow   (was: CDW v1)
               Status: Open  (was: New)
       Docs QE Status:   (was: NEW)
          Component/s: upstream
                           (was: runtime)
    Affects Version/s: 4.2.2.Final
                           (was: 8.0.2.GA)
        Fix Version/s: 4.4.x
                           (was: 9.x)


> cannot use oracle service name in datasource creation
> -----------------------------------------------------
>
>                 Key: JBIDE-20983
>                 URL: https://issues.jboss.org/browse/JBIDE-20983
>             Project: Tools (JBoss Tools)
>          Issue Type: Bug
>          Components: upstream
>    Affects Versions: 4.2.2.Final
>            Reporter: Tom Fonteyne
>             Fix For: 4.4.x
>
>
> 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...)



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)