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

[Snjezana Peco (JIRA)]

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

Snjezana Peco updated JBDS-3403:
--------------------------------
    Fix Version/s: 9.0.x


> cannot use oracle service name in datasource creation
> -----------------------------------------------------
>
>                 Key: JBDS-3403
>                 URL: https://issues.jboss.org/browse/JBDS-3403
>             Project: Developer Studio (JBoss Developer Studio)
>          Issue Type: Bug
>          Components: runtime
>    Affects Versions: 8.0.2.GA
>            Reporter: Tom Fonteyne
>             Fix For: 9.0.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.3.15#6346)