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
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).
Domain Structure tree, expand
Services > JDBC, then select
Multi Data Sources.
Summary of Multi Data Sources page, click
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.
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
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.
Load-Balancing - The multi data
source distributes connection requests evenly to its member data
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
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
Non-XA Driver - The multi data source
will only use data sources that use a non-XA JDBC driver to create
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
Finish to save the JDBC multi data source
configuration and deploy the data source to the targets that you
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).