Show TOC

Procedure documentationManaging JDBC DataSource Aliases Locate 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.

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

End of the note.

Prerequisites

You are in the   Configuration   Infrastructure   Application Resources   function.

Procedure

Creating Aliases
  1. Choose   Create New Resource   New JDBC Data Source Alias  .

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