Package javax.persistence

Annotation Type FieldResult

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

Used in conjunction with the EntityResult annotation to map columns specified in the SELECT list of a SQL query to the properties or fields of an 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")})
       })
 

See Also:

EntityResult, SqlResultSetMapping

Since:

1.0

Required Element Summary

Required Elements

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

Element Detail

name

java.lang.String name

Name of the persistent field or property of the class.

column

java.lang.String column

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