Annotation Type FieldResult

@Target({})
@Retention(RUNTIME)
public @interface FieldResult

Is used to map the columns specified in the SELECT list of the query to the properties or fields of the entity class.

Example:
  Query q = em.createNativeQuery(
      "SELECT o.id AS order_id, " +
          "o.quantity AS order_quantity, " +
          "o.item AS order_item, " +
        "FROM Order o, Item i " +
        "WHERE (order_quantity > 25) AND (order_item = i.id)",
      "OrderResults");

  @SqlResultSetMapping(name="OrderResults",
      entities={
          @EntityResult(entityClass=com.acme.Order.class, fields={
              @FieldResult(name="id", column="order_id"),
              @FieldResult(name="quantity", column="order_quantity"),
              @FieldResult(name="item", column="order_item")})
      })

Since:

Java Persistence 1.0

Required Element Summary

Required Elements

Modifier and Type	Required Element	Description
String	column	Name of the column in the SELECT clause - i.e., column aliases, if applicable.
String	name	Name of the persistent field or property of the class.

Element Details

name

String name

Name of the persistent field or property of the class.

column

String column

Name of the column in the SELECT clause - i.e., column aliases, if applicable.