Connector Guides › Connector Xpress Guide › Screens and Dialogs › Indirect Association Dialog (JDBC only)

Indirect Association Dialog (JDBC only)

You can use the Indirect Association dialog to specify a two-way association between any two classes of objects. The association between the two objects is bi-directional and contained in a third entity, that is a table, which holds the association links between the objects.

Each entry indicates an association between instances of each object. The node representing the association appears under the Associations node in the mapping tree.

Due to the symmetrical nature of containing the association in a third entity, lookups in either direction are equally fast and reverse associations are automatically assumed and created.

This dialog contains the following fields:

• Schema

  Specifies the schema (for example, tablespace or database) name for which the tables are displayed in the Membership Table field.

• Membership Table

  Specifies the tables that define the members of each group.

  Note: The database table that you select requires at least two columns and cannot have more than two required columns.

• Source Class Attribute

  Specifies the attribute of the source class whose value is held in the membership table.

• Membership Table Columns

  Specifies the membership table columns that refer to the source and target class attributes.

• Target Class Attribute

  Specifies the attribute of the target class whose value is held in the membership table.

• Source Class Attribute

  Specifies the name of the virtual attributes on the source class that contain the list of names of associated objects.

• Target Class Attribute

  Specifies the name of the virtual attributes on the target object that contain the list of names of associated objects.

• Objects Must Exist

  Specifies whether the associated entries must exist.

  Default: Selected.

• Use DNs in Attributes

  Specifies whether the virtual membership attributes contain a list of DNs, or just a list of the target object's naming attributes.

  Default: Unselected.