Databases Reference
In-Depth Information
See also
F
Creating the JMS servers
Creating the JDBC stores
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
.
Getting ready
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
,
PROD_Server02
,
PROD_Server03
, and
PROD_Server04
respectively.
Managed Server
Persistent store
PROD_Server01
JDBCStore01
PROD_Server02
JDBCStore02
PROD_Server03
JDBCStore03
PROD_Server04
JDBCStore04
How to do it...
Create the data sources and the multi data source:
1. Access the Administration Console with your web browser at
http://adminhost.
domain.local:7001/console
.
2. Click on the Lock & Edit button to start a new edit session.
3. Click on the Services tree on the left and then click on Data Sources.
4. Click on the New button and click on Generic Data Source.
Search WWH ::
Custom Search