What are the different Design-time connection URLs for connecting to different Oracle Databases?
Article ID: KB0088896
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://<hostname>:<port>SID=<sid>
To specify Service Name of the Oracle database you need to specify ServiceName instead of SID.
jdbc:tibcosoftwareinc:oracle://<hostname>:<port>ServiceName=<service name>
Environment
---------------
All
When the Oracle Database is configured with SID, the jdbc URL is:
jdbc:tibcosoftwareinc:oracle://<hostname>:<port>SID=<sid>
To specify Service Name of the Oracle database you need to specify ServiceName instead of SID.
jdbc:tibcosoftwareinc:oracle://<hostname>:<port>ServiceName=<service name>
Environment
---------------
All
Issue/Introduction
What are the different Design-time connection URLs for connecting to different Oracle Databases?
Feedback
Yes
No
Powered by
