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 | Method and Description |
|---|---|
| public 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. |
| public Class | |
| public FieldResult[] | fields()
Maps the columns specified in the SELECT list of the query to the properties or fields of the entity class. |
| discriminatorColumn | back to summary |
|---|---|
| public 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. | |
| entityClass | back to summary |
|---|---|
| public Class The class of the result. | |
| fields | back to summary |
|---|---|
| public FieldResult[] fields() Maps the columns specified in the SELECT list of the query to the properties or fields of the entity class. | |