@Target(value={}) @Retention(value=RUNTIME) public @interface EntityResult
SqlResultSetMapping
annotation to map the SELECT
clause of a SQL query to an entity result.
If this annotation is used, the SQL statement should select all of the columns that are mapped to the entity object. This should include foreign key columns to related entities. The results obtained when insufficient data is available are undefined.
Example: Query q = em.createNativeQuery( "SELECT o.id, o.quantity, o.item, i.id, i.name, i.description "+ "FROM Order o, Item i " + "WHERE (o.quantity > 25) AND (o.item = i.id)", "OrderItemResults"); @SqlResultSetMapping(name="OrderItemResults", entities={ @EntityResult(entityClass=com.acme.Order.class), @EntityResult(entityClass=com.acme.Item.class) })
SqlResultSetMapping
Modifier and Type | Required Element and Description |
---|---|
Class |
entityClass
The class of the result.
|
Modifier and Type | Optional Element and Description |
---|---|
String |
discriminatorColumn
Specifies the column name (or alias) of the column in
the SELECT list that is used to determine the type of
the entity instance.
|
FieldResult[] |
fields
Maps the columns specified in the SELECT list of the
query to the properties or fields of the entity class.
|
public abstract Class entityClass
public abstract FieldResult[] fields
public abstract String discriminatorColumn
Copyright © 1996-2017, Oracle and/or its affiliates. All Rights Reserved. Use is subject to license terms.