Create JDBC multi
data sources

Before you begin

Multi data sources provide failover and load balancing for connection
requests between two or more data sources. Before you create a multi
data source, you should create the data sources that the multi data
source will manage, and deploy them to same targets that you want to
deploy the multi data source to. You can create data sources and multi
data sources in a single edit session. See Create JDBC data
sources

To create a JDBC multi data source:

If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).

On the
Configure the Multi Data Source page, enter or
select the following information:

Name - Enter a
name for this JDBC multi data source. This name is used in the
configuration files (config.xml and the JDBC
module) and throughout the Administration Console whenever referring
to this data source.

JNDI
Name - Enter the JNDI path to where this JDBC data
source will be bound. Applications look up the data source on the
JNDI tree by this name when reserving a connection.

Algorithm Type - Select an algorithm
option:

Failover - The multi data source
routes connection requests to the first data source in the list; if
the request fails, the request is sent to the next data source in
the list, and so forth.

On the
Select Targets page, select the servers or
clusters on which you want to deploy the multi data source.

The targets you select will limit the data sources that you can
select as part of the multi data source. You can only select data
sources that are deployed to the same targets as the multi data
source.

On the Select Data Source Type page, select
one of the following options:

XA Driver - The multi data source
will only use data sources that use an XA JDBC driver to create
database connections.

Non-XA Driver - The multi data source
will only use data sources that use a non-XA JDBC driver to create
database connections.

The option you select limits the data sources that you can select
as part of the multi data source in a later step. Limiting data
sources by JDBC driver type enables the WebLogic Server transaction
manager to properly complete or recover global transactions that use
a database connection from a multi data source.

On the Add Data Sources page, select the
data sources that you want the multi data source to use to satisfy
connection requests.

Click
Finish to save the JDBC multi data source
configuration and deploy the data source to the targets that you
selected.

To activate these changes, in the Change Center of the Administration Console, click Activate Changes. Not all changes take effect immediately—some require a restart (see Use the Change Center).