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.
To define a new database access class and add it to the Database Access Class list, select New.
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