Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks | - |
Not Applicable | - |
Resolution:
A new option called 'AlternateServers', allows a list of additional database servers to be specified. The value of the AlternateServers connection option is a string that specifies the server name and port number of alternate servers that can be tried if the primary server is not accepting connections for some reason.
This string has the format:
AlternateServers= (servername1:port1,servername2:port2, ..., servernameN:portN)
To use the AlternateServers connection option, you must specify the primary ServerName and PortNumber values in the URL or DataSource
Here is an example URL to connect to an Oracle 9i RAC :
jdbc:tibcosoftwareinc:oracle://server1:1521;SID=TEST;AlternateServers=(server2:1521,server3:1521,server4:1521)
Specifying the above URL causes the driver to attempt to connect to the TEST database on server1 using port 1521. If that connection attempt fails, the driver tries to connect to the TEST database on server2. If that attempt fails, the driver attempts to connect to server3, and so on, until all servers in the list are tried