Managing JDBC DataSource Aliases

Use

You use this procedure to add or remove aliases for JDBC DataSources. Aliases are alternative names that are used by application components when they look up JDBC DataSource objects. All aliases that are defined for a JDBC DataSource are available in the DataSource Aliases tab of a selected JDBC DataSource Resource Details area in the SAP NetWeaver Administrator.

Note

When you perform an operation involving the default DataSource, you must restart the cluster node for the changes to take effect. For single-node systems, restart is not necessary.

Prerequisites

You are in the Start of the navigation path Configuration Next navigation step Infrastructure Application Resources End of the navigation path function.

Procedure

Creating Aliases

Choose Create New Resource New JDBC Data Source Alias .
Enter an arbitrary name for the alias.
Select a DataSource for the alias to be directed to from the DataSource Name dropdown list.
If you want to override the Isolation Level or the Maximum Connections values of the selected DataSource, specify these settings for the particular DataSource alias.

For more information about alias-specific isolation level and maximum connections, see data-source-aliases.dtd
Choose Save .

Removing Aliases

Select JDBC DataSource Aliases from the Show dropdown list.
Select the alias to be removed.
Choose Delete Selected Resource .

Redirecting Aliases

Select JDBC DataSource Aliases from the Show dropdown list.
Select an alias from the list.
Choose the Settings tab in the Resource Details area .
Choose the DataSource you want to redirect the alias to from the DataSource Name dropdown list.
To save your changes, choose the Save button in the Resource Details area.