edocs Home > BEA WebLogic Server 9.2 Documentation > Administration Console Online Help > Create JDBC multi data sources

Administration Console Online Help

    Previous Next  Open TOC in new window 
Content starts here

Create JDBC multi data sources

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:

  1. If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
  2. In the Domain Structure tree, expand Services > JDBC, then select Multi Data Sources.
  3. On the Summary of Multi Data Sources page, click New.
  4. On the Configure the Multi Data Source page, enter or select the following information:

    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.

    JNDI Name - Enter the JNDI path to where this JDBC data source will be bound. Applications look up the data source on the JNDI tree by this name when reserving a connection.

    Algorithm Type - Select an algorithm option:

    • Failover - The multi data source routes connection requests 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.
    • Load-Balancing - The multi data source distributes connection requests evenly to its member data sources.

    For more information about these choices, refer to Configuration Options

    Click Next to continue.

  5. On the Select Targets page, select the servers or clusters on which you want to deploy the multi data source.

    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.

  6. On the Select Data Source Type page, select one of the following options:
    • XA Driver - The multi data source will only use data sources that use an XA JDBC driver to create database connections.
    • Non-XA Driver - The multi data source will only use data sources that use a non-XA JDBC driver to create database connections.

    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.

  7. On the Add Data Sources page, select the data sources that you want the multi data source to use to satisfy connection requests.
  8. Click Finish to save the JDBC multi data source configuration and deploy the data source to the targets that you selected.
  9. To activate these changes, in the Change Center of the Administration Console, click Activate Changes.
    Not all changes take effect immediately—some require a restart (see Use the Change Center).

  Back to Top