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:
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.
Algorithm Type - Select an algorithm option:
For more information about these choices, refer to Configuration Options
Click Next to continue.
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.
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.