Skip navigation.
Downloads | Product Documentation | Support

Administration Console Online Help

# JDBC Multi Data Sources

Column Display Related Tasks Related Topics

A JDBC multi data source is an abstraction around a group of data sources that provides load balancing and failover between data sources. As with data sources, multi data sources are also bound to the JNDI tree. Applications can look up a multi data source on the JNDI tree and then reserve a database connection from a data source. The multi data source determines from which data source to provide the connection.

Use this page to create or view multi data sources in your domain.

#### Column Display

You can show fewer or additional data points on this page by expanding Customize this table and modifying the Column Display list. Each data point displays in its own table column.

The following table lists all of the data points that you can display in columns on this page.

Name | Description
--- | ---
Name | A unique name that identifies this data source in the WebLogic domain. MBean Attribute (Does not apply to application modules): `JDBCDataSourceBean.Name` Changes take effect after you redeploy the module or restart the server.
JNDI Name | The JNDI name of this JDBC multi data source. MBean Attribute (Does not apply to application modules): `JDBCDataSourceParamsBean.JNDINames` Changes take effect after you redeploy the module or restart the server.
Algorithm Type | 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. MBean Attribute (Does not apply to application modules): `JDBCDataSourceParamsBean.AlgorithmType` Changes take effect after you redeploy the module or restart the server.
Targets | The servers and clusters to which this multi data source is targeted. MBean Attribute: `TargetInfoMBean.Targets`

Related Tasks

- Create JDBC multi data sources
- Create JDBC data sources
- Delete JDBC multi data sources

Related Topics

- Configuring and Deploying WebLogic JDBC Resources
- JDBC Multi Data Sources