When you use a Select, Modify, or ProcedureCall bean to access relational data, you must specify a connection alias for the bean. A connection alias specifies database connection characteristics for the bean. You can create a new connection alias or select an existing connection alias.
Use the Connection page of the data 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, Modify or ProcedureCall beans can use the same connection alias, and if so, they share the database connection associated with that connection alias at runtime. If one bean commits updates to a database, it commits all uncommitted updates made by any bean sharing the database connection.
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.
See Defining a Database Access Class.
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 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.
Defining a database access class
Defining or editing a connection alias
Making an SQL specification