Top Description Methods
jakarta.persistence

public @Interface FieldResult

extends Annotation
Annotations
@Target
@Retention:RUNTIME
Imports
java.lang.annotation.Target, .Retention
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") }) }) 
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
1.0
See Also
EntityResult, SqlResultSetMapping

Method Summary

Modifier and TypeMethod and Description
public String
column()

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

public String
name()

Name of the persistent field or property of the class.

Inherited from java.lang.annotation.Annotation:
annotationTypeequalshashCodetoString

Method Detail

columnback to summary
public String column()

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

nameback to summary
public String name()

Name of the persistent field or property of the class.