Note: This ORM/SQL annotation is silently ignored by ObjectDB

265 words

javax.persistence.EntityResult - JPA annotation

javax.persistence
Annotation EntityResult

Target:
Used 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)
   })
Since:
JPA 1.0
See Also:
SqlResultSetMapping
Specifies the column name (or alias) of the column in the SELECT list that is used to determine the type of the entity instance.
Specifies the column name (or alias) of the column in the SELECT list that is used to determine the type of the entity instance.
Default value:
""
Since:
JPA 1.0
The class of the result.
The class of the result.
Since:
JPA 1.0
Maps the columns specified in the SELECT list of the query to the properties or fields of the entity class.
Maps the columns specified in the SELECT list of the query to the properties or fields of the entity class.
Default value:
{}
Since:
JPA 1.0

This documentation page is derived (with some adjustments) from the open source JPA 2 RI (EclipseLink)
and is available under the terms of the Eclipse Public License, v. 1.0 and Eclipse Distribution License, v. 1.0.
Object Relational Mapping (ORM) JPA 2 providers include Hibernate, EclipseLink, TopLink, OpenJPA and DataNucleus.
Object DB is not an ORM JPA implementation but an Object Database for Java with built in JPA 2 support.