Overview Package Class Tree Deprecated Index Help
PREV CLASS NEXT CLASS FRAMES NO FRAMES All Classes
SUMMARY: REQUIRED | OPTIONAL DETAIL: ELEMENT

javax.persistence
Annotation Type SqlResultSetMapping


@Target(value=TYPE)
@Retention(value=RUNTIME)
public @interface SqlResultSetMapping

Specifies the mapping of the result of a native SQL query.

 Example:
 Query q = em.createNativeQuery(
 "SELECT o.id AS order_id, " +
 "o.quantity AS order_quantity, " +
 "o.item AS order_item, " +
 "i.name AS item_name, " +
 "FROM Order o, Item i " +
 "WHERE (order_quantity> 25) AND (order_item = i.id)",
 "OrderResults");
 
 @SqlResultSetMapping(name="OrderResults", 
 entities={ 
 @EntityResult(entityClass=com.example.Order.class, fields={
 @FieldResult(name="id", column="order_id"),
 @FieldResult(name="quantity", column="order_quantity"), 
 @FieldResult(name="item", column="order_item")})},
 columns={
 @ColumnResult(name="item_name")}
 )
 

Since:
Java Persistence 1.0

Required Element Summary
java.lang.String name
The name given to the result set mapping, and used to refer to it in the methods of the Query API.
Optional Element Summary
ColumnResult[] columns
Specifies the result set mapping to scalar values.
EntityResult[] entities
Specifies the result set mapping to entities.

Element Detail

name

public abstract java.lang.String name
The name given to the result set mapping, and used to refer to it in the methods of the Query API.

entities

public abstract EntityResult[] entities
Specifies the result set mapping to entities.

Default:
{}

columns

public abstract ColumnResult[] columns
Specifies the result set mapping to scalar values.

Default:
{}

Overview Package Class Tree Deprecated Index Help
PREV CLASS NEXT CLASS FRAMES NO FRAMES All Classes
SUMMARY: REQUIRED | OPTIONAL DETAIL: ELEMENT

Submit a bug or feature

Copyright © 2009-2011, Oracle Corporation and/or its affiliates. All Rights Reserved. Use is subject to license terms.

Generated on 10-February-2011 12:41

Scripting on this page tracks web page traffic, but does not change the content in any way.

AltStyle によって変換されたページ (->オリジナル) /