Java EE 5 SDK

javax.persistence
Annotation Type FieldResult


@Target(value={})
@Retention(value=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
 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 Detail

name

public abstract String name
Name of the persistent field or property of the class.


column

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


Java EE 5 SDK

Copyright 2006 Sun Microsystems, Inc. All rights reserved.

This documentation is deprecated and will be removed in the next release of WebLogic Server.


Oracle Fusion Middleware Sun Microsystems Persistence API Reference (DEPRECATED)
12c Release 1 (12.1.1)
Part Number E24399_01