What are the different Design-time connection URLs for connecting to different Oracle Databases?

book

Article ID: KB0088896

calendar_today

Updated On:

Products	Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database	-
Not Applicable	-

Description

Resolution:
When the Oracle Database is configured with SID, the jdbc URL is:
jdbc:tibcosoftwareinc:oracle://&lthostname>:&ltport>SID=&ltsid>

To specify Service Name of the Oracle database you need to specify ServiceName instead of SID.
jdbc:tibcosoftwareinc:oracle://&lthostname>:&ltport>ServiceName=&ltservice name>

Environment
---------------
All