Advanced Settings (Mapping Mode)

Enterprise Bean -> General tabbed pane -> Sun-specific Settings button -> Sun-specific Settings dialog box -> CMP Database view -> Mapping Mode -> Advanced Settings button

Or

Enterprise Bean -> Entity tabbed pane -> Sun-specific Settings button -> Sun-specific Settings -> CMP Database view -> Mapping Mode -> Advanced Settings button

Or

EJB JAR file -> Relationships tabbed pane -> Sun-specific Settings button -> Sun-specific Settings -> CMP Database view -> Mapping Mode -> Advanced Settings button

Or

EJB JAR File -> General tabbed pane -> Sun-specific Settings button -> Sun-specific Settings -> CMP Database view -> Mapping Mode -> Advanced Settings button

The Advanced Settings dialog box enables you to modify the advanced bean-level settings.

If you want to use tables from a different database schema, you can choose the schema from the Database Schema drop-down list. This list contains the database schema files (.dbschema) in the EJB JAR file. This action will remove all of the current field mappings that refer to this schema.

The consistency level identifies the consistency semantics which will be applied to this bean. If you want to change the consistency level of the enterprise bean, choose any of the following options from the list.

If you want to map to columns from tables other than the primary table, you must add a definition to one or more secondary tables.

A secondary table allows you to map fields in your enterprise bean to columns that are not part of your primary table. When secondary tables are defined for an enterprise bean, fields in that bean may be mapped to columns in different tables.

A secondary table must be related to the primary table by one or more columns whose associated rows have the same values in both tables. Normally, this is defined as a foreign key between the tables. When you select a secondary table from the list, if there is an existing foreign key between the two tables, it will be used as the default association.

See also

Sun-specific Settings - CMP Database

Primary and Secondary Tables

Mapped Secondary Table Setup


Legal Notices