Configure BW6 JDBC connection to use tns names file for Database details (host, port, etc.)

book

Article ID: KB0093468

calendar_today

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.

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



Issue/Introduction

Configure BW6 JDBC connection to use tns names file for Database details (host, port, etc.)