The multi data source should be used when connecting to an Oracle RAC database. The multi data source is a data source abstraction that groups all the individual data sources that connect to each node of the Oracle RAC database.
Consider that the DBApp
application requires an XA connection with a JNDI name jdbc/ds-XA
added to a database.
The database is an Oracle RAC database with two nodes. The first node has an instance name instance-rac01
and runs in the dbhost-rac01
hostname and listens to the port 1521
. The listener accepts requests to the service name dbservice-rac01
. The second node is the instance instance-rac02
, and it runs in the dbhost-rac02
hostname, listens to the port 1521
, and has a service name dbservice-rac02
.
In this recipe, a new JDBC multi data source will be created and configured for the DBApp
application.