Skip navigation.
Downloads | Product Documentation | Support

Administration Console Online Help

# Add or remove data sources in a JDBC multi data source

You cannot add or remove data sources to a multi data source while the data source is deployed (referred to as dynamically changing the data source list in the multi data source). You must undeploy the multi data source, add or remove data sources, then redeploy the multi data source. You can do all of these steps in one configuration edit session.

Also, the data sources that you add to a multi data source must be deployed on the same targets on which you intend to deploy the multi data source. You cannot include data sources in a multi data source that are deployed on different servers or clusters. They must all be deployed on the same deployment targets.

To delete 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. Target all data sources that you want to include in the multi data source to the same deployment targets on which you want to deploy the multi data source. For instructions, see Target JDBC data sources

   You can make all data source and multi data source changes in a single edit session. You do not have to activate your changes between steps.

3. In the Domain Structure tree, expand Services > JDBC, then select Multi Data Sources.
4. On the Summary of Multi Data Sources page, click the multi data source name.
5. Select the Target tab, clear the check box for all deployment targets, then click Save.
6. Select the Configuration: Data Sources tab.
7. On the Configuration: Data Sources tab, use the right and left arrow buttons to do the following:
   - Move data sources that you want to include in the multi data source to the Chosen list.
   - Move data sources that you do not want to include in the multi data source to the Available list.
8. If necessary, use the up and down arrow buttons to rearrange the order of the data sources in the Chosen list, then click Save.

   The order in the list determines the order in which the multi data source uses to route connection requests. For multi data sources that use the Failover algorithm, the first data source in the list is considered the primary data source. Others are considered secondary, tertiary, and so forth.

9. Select the Target tab, reselect all deployment targets, then click Save.
10. 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).