Specifying a Connection Alias

When you use a Select bean to access relational data, you must specify a connection alias for the Select bean. A connection alias specifies database connection characteristics for the Select bean. You can create a new connection alias or select an existing connection alias.

Use the Connection page of the Query property editor to specify a connection alias.

When you create a connection alias, you identify a database access class to hold the connection alias definition. Different Select beans can identify the same connection alias, and if so, they share the database connection associated with that connection alias. If one Select bean commits updates to a database, it commits all uncommitted updates made by any Select bean sharing the database connection.


Connection page of Query property editor

  1. Select a database access class from the drop-down list in the Database Access Class field. The list shows the database access classes that exist in the workspace. The format of each item in the list is packagename.classname, where packagename is the name of the package that contains the database access class, and classname, is the name of the class.

    To define a new database access class and add it to the Database Access Class list, select New.

  2. Select a connection alias from the Connections list. The list identifies the connection aliases that are in the selected database access class. Selecting a connection alias from the list enables the SQL tab (select the SQL tab to make an SQL specification for the Select bean).

    To add a connection alias to the database access class, select Add.

    To edit the definition of a connection alias, select the connection alias name in the Connections list and then select Edit.

    To remove a connection alias from the Connections list, select it in the list and then select Remove.

When you finish specifying the connection alias, select OK.

To cancel specifying a connection alias, select Cancel.


Related procedures
Defining a Database Access Class
Defining or Editing a Connection Alias
Making an SQL Specification