[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 reassigned JBIDE-20983:
--------------------------------------

    Assignee: Koen Aers


> 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
>            Assignee: Koen Aers
>             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)