Fusion Middleware Control Help for WebLogic Server

Create a JDBC Multi Data Source: Data Source Properties

Use this page to create a JDBC 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.

Configuration Options

Name	Description
Data Source Name	A unique name that identifies this data source object in the domain. The name must be unique among all JDBC data sources and multi data sources in the 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 path to where this data source object is bound. By default, the JNDI name is the name of the data source. To specify multiple JNDI names for the data source, enter each JNDI name on a separate line. Applications that look up the JNDI path will get a javax.sql.DataSource instance that corresponds to this 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.