The persistent store can also persist the data in the database by using the JDBC store. In this recipe a new JDBC store will be created in all Managed Servers of the PROD_Cluster
cluster.
The database that will host the stores is an Oracle RAC database with two nodes. The first node has an instance name instance-rac01
, 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
, runs in the dbhost-rac02
hostname, listens to the port 1521
, and has a service name dbservice-rac02
.
A multi data source will be created with the name ds-store
and JNDI name jdbc/ds-store
. The data source members will be called ds-store-rac01
and ds-store-rac02
with the JNDI names jdbc/ds-store-rac01
and jdbc/ds-store-rac02
.
For the cluster PROD_Cluster
, we will consider the JDBC stores JDBCStore01
, JDBCStore02
, JDBCStore03
, and JDBCStore04
for the instances PROD_Server01...