Is it possible to use an entry from "tnsnames.ora" (e.g. enable=broken) in my Oracle data source's JDBC connection string?
Article ID: KB0082831
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.0 and higher |
Description
This article discusses inserting an entry from "tnsname.ora" into an Oracle data source's connection string.
Issue/Introduction
Is it possible to use an entry from "tnsnames.ora" (e.g. enable=broken) in my Oracle data source's JDBC connection string?
Resolution
Yes, you can copy the entire description from "tnsname.ora" into the Connection URL Pattern field, located on the data source Advanced panel.
Example
jdbc:oracle:thin:@(DESCRIPTION =(enable=broken)(ADDRESS = (PROTOCOL = TCP)(HOST = redwood.mycompany.com)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = XE)))
Example
jdbc:oracle:thin:@(DESCRIPTION =(enable=broken)(ADDRESS = (PROTOCOL = TCP)(HOST = redwood.mycompany.com)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = XE)))
Feedback
Yes
No
Powered by
