tracker issue : CF-3367378

select a category, or use search below
(searches all categories and all time range)
Title:

How to create Oracle DSN using service name

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): / ext-user (Asha K S)

Created: 11/19/2012

Components: Documentation, General

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final /

Priority/Frequency: Normal / All users will encounter

Locale/System: ALL / Mac 10 All,Win XP All

Vote Count: 0

Problem:Some of the documentation information from ColdFusion 8 "Connecting to other data sources" (http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=datasources_ADV_MJS_15.html) is missing in ColdFusion 10.

Method:The following info is missing -

Updated April 3, 2008: Added information on Oracle RAC
You can also use this option to create a datasource for Oracle Real Application Cluster (RAC). Specify the following settings:

JDBC URL jdbc:macromedia:oracle://hostname:port;ServiceName=servicename;AlternateServers=(alternatehostname:port);ConnectionRetryCount=2;ConnectionRetryDelay=5 
(servicename,a name that is typically composed of the database name and domain name, is used to specify connections to Oracle RAC because the nodes in a RAC system share a common service name. AlternateServers is a comma separated list of servers and port names.)
Driver class macromedia.jdbc.MacromediaDriver
Username A user defined to the database
Password The password for the username


Result:

Expected:Have the same info from ColdFusion 8 in ColdFusion 10 as well (http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe9.html)

Workaround:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3367378

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:

Attachments:

Comments:

Assigning to Frank (Comment added from ex-user id:ramachan)
Comment by Adobe D.
17180 | June 26, 2013 01:17:21 AM GMT
The following page has been updated: https://learn.adobe.com/wiki/display/coldfusionen/Data+Source+Management+for+ColdFusion
Comment by Frank J.
17181 | January 27, 2014 12:29:18 PM GMT
Nimit, Take a look at: https://wikidocs.adobe.com/wiki/display/coldfusionen/Data+Source+Management+for+ColdFusion#DataSourceManagementforColdFusion-ConnectingtoOracle
Comment by Frank J.
17182 | February 10, 2014 01:15:09 AM GMT