Administration Console Online Help

    Previous Next  Open TOC in new window 
Content starts here

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

Related Topics


  Back to Top