Managing JDBC DataSource Aliases 

Use

You use this procedure to add or remove aliases for JDBC Data Sources.

Aliases are alternative names that are used by application components when they look up a JDBC DataSource. Using aliases provides a level of independence for your applications, since you can redirect the aliases and thus use different JDBC DataSources without changing the application code. This enables you to manage the database connectivity for your application easily. To redirect aliases, you have to use the Visual Administrator tool.

More information about redirecting aliases: Managing Aliases

You can define aliases either when you create a JDBC DataSource, or additionally at runtime. All aliases that have been defined for a JDBC DataSource are visible in the Aliases tab of a JDBC DataSource in the SAP NetWeaver Administrator. The aliases are registered when you start the application to which the aliases are associated, and are removed when you stop the component. They become functional – that is, the system binds them in the naming – when the JDBC DataSource for which they are created is started. If you stop the component with the JDBC DataSource and the component(s) with the aliases is still running, the aliases remain registered but you cannot use them unless you start the JDBC DataSource again.

Procedure

To add or remove aliases for a JDBC DataSource, choose System Management ® Configuration ® Application Resources and select JDBC Data Source Aliases from the Show dropdown list.

Creating New Data Source Aliases

...

       1.      Choose Create.

       2.      Select JDBC Data Source Alias from the Resource Typedropdown list.

       3.      Enter a name for the alias in the Resource Name field.

       4.      Select the relevant system from the System dropdown list.

       5.      Select the relevant Data Source from the JDBC Data Source dropdown list.

       6.      Choose OK.

Deleting Data Source Aliases

...

       1.      Select the JDBC Data Source Alias that you want to remove and choose Delete.

       2.      Confirm the deletion by choosing Delete in the confirmation dialog.

More Information

More information about managing JDBC DataSource Aliases with the Visual Administrator tool: JDBC Connector Service