[jbosstools-issues] [JBoss JIRA] (JBDS-3403) cannot use oracle service name in datasource creation
[
https://issues.jboss.org/browse/JBDS-3403?page=com.atlassian.jira.plugin....
]
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)