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

[Tom Fonteyne (JIRA)]

    [ https://issues.jboss.org/browse/JBDS-3403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13058446#comment-13058446 ] 

Tom Fonteyne commented on JBDS-3403:
------------------------------------

Basically just create a new datasource. Select the Oracle driver - any version will do.

The dialog box present separate fields for all the URL components including the Oracle SID. The URL field then concatenates them.... using a hardcoded ":" separator -> ok for a SID, but invalid for a service name.

and you cannot modify the URL field. Likewise if you go to the driver, you seemingly can change the URL template... except that it does not get used when you try to create a datasource.

workaround is admittedly easy: after creation, open the datasource xml file and modify the url but this should still be fixed.

> 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
>
> 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.11#6341)