Show TOC

Managing JDBC DataSource AliasesLocate this document in the navigation structure


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.


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.


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


Creating Aliases

  1. Choose Start of the navigation path Create New Resource  Next navigation step New JDBC Data Source Alias End of the navigation path.

  2. Enter an arbitrary name for the alias.

  3. Select a DataSource for the alias to be directed to from the DataSource Name dropdown list.

  4. 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

  5. Choose Save .

Removing Aliases

  1. Select JDBC DataSource Aliases from the Show dropdown list.

  2. Select the alias to be removed.

  3. Choose Delete Selected Resource .

Redirecting Aliases

  1. Select JDBC DataSource Aliases from the Show dropdown list.

  2. Select an alias from the list.

  3. Choose the Settings tab in the Resource Details area .

  4. Choose the DataSource you want to redirect the alias to from the DataSource Name dropdown list.

  5. To save your changes, choose the Save button in the Resource Details area.