What is the difference between “tibcosoftwareinc.jdbc.oracle.OracleDriver” and “tibcosoftwareinc.jdbc.oracle.OracleDriver (RAC)” in the JDBC Connection setting?
Article ID: KB0088455
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
You can use these two drivers for both non RAC or RAC environments. The only difference is when choosing a RAC driver in Designer. A connection URL with ‘AlternateServers’ will be provided. If you use this URL for tibcosoftwareinc.jdbc.oracle.OracleDriver driver, it will still work.
For example, if using ‘jdbc:tibcosoftwareinc:oracle://localhost:1521;ServiceName=orcl;AlternateServers=(bnanda-dt:1521)’ as the connection URL for tibcosoftwareinc.jdbc.oracle.OracleDriver driver, when an Oracle instance on localhost is not available, the server ‘bnanda-dt’ will be tried. Connection information for alternate servers is specified using the AlternateServers property with either a connection URL through the JDBC Driver Manager or a JDBC data source. The value of the AlternateServers property is a string that has the following format:
(servername1[:port1][;property=value[;...]][,servername2[:port2][;property=value[;...]]]...)
where:
servername1 is the server name of the first alternate database server, servername2 is the server name of the second alternate database server, and so on. The server name is required for each alternate server entry.
port1 is the port number on which the first alternate database server is listening, port2 is the port number on which the second alternate database server is listening, and so on. The port number is optional for each alternate server entry. If unspecified, the port number specified for the primary server is used. If a port number is unspecified for the primary server, the default port number of 1521 is used.
property=value is one of the following connection properties:
ServiceName or SID. These connection properties are optional for each alternate server entry and are mutually exclusive. For example:
jdbc:datadirect:oracle://server1:1521;ServiceName=TEST;User=test;Password=secret;AlternateServers=(server2:1521;ServiceName=TEST2,server3:1521)
or
jdbc:datadirect:oracle://server1:1521;SID=ORCL;User=test;Password=secret;AlternateServers=(server2:1521;SID=ORCL2,server3:1521)
You can use these two drivers for both non RAC or RAC environments. The only difference is when choosing a RAC driver in Designer. A connection URL with ‘AlternateServers’ will be provided. If you use this URL for tibcosoftwareinc.jdbc.oracle.OracleDriver driver, it will still work.
For example, if using ‘jdbc:tibcosoftwareinc:oracle://localhost:1521;ServiceName=orcl;AlternateServers=(bnanda-dt:1521)’ as the connection URL for tibcosoftwareinc.jdbc.oracle.OracleDriver driver, when an Oracle instance on localhost is not available, the server ‘bnanda-dt’ will be tried. Connection information for alternate servers is specified using the AlternateServers property with either a connection URL through the JDBC Driver Manager or a JDBC data source. The value of the AlternateServers property is a string that has the following format:
(servername1[:port1][;property=value[;...]][,servername2[:port2][;property=value[;...]]]...)
where:
servername1 is the server name of the first alternate database server, servername2 is the server name of the second alternate database server, and so on. The server name is required for each alternate server entry.
port1 is the port number on which the first alternate database server is listening, port2 is the port number on which the second alternate database server is listening, and so on. The port number is optional for each alternate server entry. If unspecified, the port number specified for the primary server is used. If a port number is unspecified for the primary server, the default port number of 1521 is used.
property=value is one of the following connection properties:
ServiceName or SID. These connection properties are optional for each alternate server entry and are mutually exclusive. For example:
jdbc:datadirect:oracle://server1:1521;ServiceName=TEST;User=test;Password=secret;AlternateServers=(server2:1521;ServiceName=TEST2,server3:1521)
or
jdbc:datadirect:oracle://server1:1521;SID=ORCL;User=test;Password=secret;AlternateServers=(server2:1521;SID=ORCL2,server3:1521)
Issue/Introduction
What is the difference between “tibcosoftwareinc.jdbc.oracle.OracleDriver” and “tibcosoftwareinc.jdbc.oracle.OracleDriver (RAC)” in the JDBC Connection setting?
Feedback
Yes
No
Powered by
