Configure BW6 JDBC connection to use tns names file for Database details (host, port, etc.)
Article ID: KB0093468
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Description:
Some customers may want to use tnsnames.ora to specify database details. This KB shows how.
Some customers may want to use tnsnames.ora to specify database details. This KB shows how.
Issue/Introduction
Configure BW6 JDBC connection to use tns names file for Database details (host, port, etc.)
Resolution
For Design time, add the following property to TIBCOBusinessStudio.ini and restart:
-Doracle.net.tns_admin=C:\myfolder\ADMIN
Note: The directory shown above should point to the location where tnsnames.ora is stored. When running the project from BusinessStudio, add the above as a VM argument in the Run configurations. For deploy time, add the above in appnode tra.
Example: java.extended.properties=-Doracle.net.tns_admin=C:/myfolder/ADMIN
Feedback
Yes
No
Powered by
