General information

This table lists the General properties available in the Java Details view for each mapping type.

Property Description Default Available for Mapping Type
Mapping Type Hyperlink Clicking the name of the mapping type, which is represented as a hyperlink, invokes the Mapping Type Selection dialog. Use this dialog to specify the type of attribute. Basic All mapping types
Column The database column that contains the value for the attribute. This field corresponds to the @Column annotation. By default, the Column is assumed to be named identically to the attribute. Basic mapping, Embedded mapping, ID mapping, Version mapping
  Name Name of the database column.

This field corresponds to the @Column annotation.


Basic mapping, Embedded mapping, ID mapping
  Table Name of the database table that contains the selected column.
Basic mapping, Embedded mapping, ID mapping
  Insertable Specifies if the column is always included in SQL INSERT statements. True Basic mapping, Embedded mapping, ID mapping
  Updatable Specifies if this column is always included in SQL UPDATE statements. True Basic mapping, Embedded mapping, ID mapping
  Unique Sets the UNIQUE constraint for the column. False Basic mapping, Embedded mapping, ID mapping
  Nullable Specifies if the column allows null values. True Basic mapping, Embedded mapping, ID mapping
  Length Sets the column length. 255 Basic mapping, Embedded mapping, ID mapping
  Precision Sets the precision for the column values. 0 Basic mapping, Embedded mapping, ID mapping
  Scale Sets the number of digits that appear to the right of the decimal point. 0 Basic mapping, Embedded mapping, ID mapping
  Column Definition Define the DDL for a column. This is used when a table is being generated.
Basic mapping, Embedded mapping, ID mapping
Fetch Type Defines how data is loaded from the database:
  • Eager – Data is loaded in before it is actually needed.

  • Lazy – Data is loaded only when required by the transaction.

Eager Basic mapping, One-to-one mapping, Many-to-many mapping, Many-to-one mapping
Optional Specifies if this field is can be null. Yes Basic mapping, One-to-one mapping, Many-to-one mapping
Lob Specify if the field is mapped to java.sql.Clob or java.sql.Blob.

This field corresponds to the @Lob annotation.


Basic mapping
Temporal Specifies if this field is one of the following:
  • Date – java.sql.Date

  • Time – java.sql.Time

  • Timestamp – java.sql.Timestamp

This field corresponds to the @Temporal annotation.


Basic mapping, ID mapping
Enumerated Specify how to persist enumerated constraints if the String value suits your application requirements or to match an existing database schema.
  • ordinal

  • String

This field corresponds to the @Enumerated annotation.

Ordinal
Target Entity The persistent entity to which the attribute is mapped.
One-to-one mapping, One-to-many mapping Many-to-many mapping, Many-to-one mapping
Cascade Type Specify which operations are propagated throughout the entity.
  • All – All operations

  • Persist

  • Merge

  • Move

  • Remove

  • Refresh


One-to-one mapping, One-to-many mapping, Many-to-many mapping, Many-to-one mapping
Mapped By The field in the database table that "owns" the relationship. This field is required only on the non-owning side of the relationship.
One-to-one mapping, One-to-many mapping
Order By Specify the default order for objects returned from a query:
  • No ordering

  • Primary key

  • Custom ordering

This field corresponds to the @OrderBy annotation.

Primary key One-to-many mapping. Many-to-many mapping, Many-to-one mapping
Attribute Overrides Overrides Basic mappings of a mapped superclass (for example, if the inherited column name is incompatible with a pre-existing data model, or invalid as a column name in your database).
Embedded mapping

Embedded mapping



 

Related task

Mapping an entity