Databases Reference
In-Depth Information
17. Finally, click on the Activate Changes button.
How it works...
The multi data source ds-XA was created with the data sources ds-XA-rac01
and ds-XA-rac02 as members.
The multi data source manages the application requests for a database connection
and uses Algorithm Type to define the strategy for high availability.
If using the Failover algorithm, be sure to enable the Failover Request if
Busy checkbox of the multi data source.
The multi data source is responsible for managing the load and failover; so if the Oracle
database uses the SCAN address feature, it's recommended to set up a GridLink data
source instead.
It is still possible to use the SCAN address with the multi data source by
defining the instance name in the data source URL. Also, data source
members of a multi data source must always target to a unique Oracle RAC
node, so using JDBC URL parameters such as LOAD_BALANCE=ON and
FAILOVER=ON is not supported when using XA multi data sources.
The Oracle driver class name used for XA data sources is oracle.jdbc.xa.client.
OracleXADataSource .
 
Search WWH ::




Custom Search