Administration Console Online Help

Create a Multi Data Source

Use this page to create a multi data source. A multi data source is a
data source object that provides load balancing and failover processing
for database connection requests between other data source objects.

The algorithm determines the connection request processing for
the multi data source.

You can specify one of the following algorithm types:

Failover

Connection requests are sent 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. The process is repeated until a
valid connection is obtained, or until the end of the list is
reached, in which case an exception is thrown.

Load balancing

The multi data source distributes connection requests evenly to
its member data sources. With this algorithm, the multi data source
also provides failover processing. That is, if a request fails, the
multi data source sends the request to the next data source in the
list until a valid connection is obtained, or until the end of the
list is reached, in which case an exception is thrown.

Select the servers and clusters on which you want to deploy your
new multi data source. The targets you select will determine the data
sources you can select for the multi data source to use to handle
connection requests. All data sources must be deployed on the same
targets as the new multi data source.

Select the type of data source that you want the multi data source
to use when processing connection requests: data sources that use an
XA JDBC driver or those that use a non-XA JDBC driver to create
database connections.

The selection you make will determine which data sources you can
select for this multi data source to use. It is important that all
data sources used by the multi data source use the same transaction
protocol so that WebLogic Server can properly handle transaction
processing.

Select the data sources that you want the new multi data source to
use when handling connection requests. The multi data source will
route connection requests to the data sources you select in the order
specified in the Chosen list and according the Algorithm
Type previously selected.