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:
If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
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
You can make all data source and multi data source changes in a
single edit session. You do not have to activate your changes
Domain Structure tree, expand
Services > JDBC, then select
Multi Data Sources.
Summary of Multi Data Sources page, click the
multi data source name.
Target tab, clear the check box for all
deployment targets, then click Save.
the Configuration: Data Sources tab.
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
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.
Target tab, reselect all deployment targets,
then click Save.
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).