Package org.eclipse.persistence.config
Class ResultType
- java.lang.Object
-
- org.eclipse.persistence.config.ResultType
-
public class ResultType extends java.lang.ObjectResult type hint values. The class contains all the valid values for QueryHints.RESULT_TYPE query hint. By default in JPA for non-single select queries an Array of values is returned. If getSingleResult() is called the first array is returned, for getResultList() a List of arrays is returned.i.e. "Select e.firstName, e.lastName from Employee e" returns List<Object[]>
or the native query, "SELECT * FROM EMPLOYEE" returns List<Object[]>
The ResultType can be used to instead return a Map of values (DatabaseRecord, ReportQueryResult).
It can also be used to return a single column, or single value. JPA Query Hint Usage:
query.setHint(QueryHints.RESULT_TYPE, ResultType.Map);or
@QueryHint(name=QueryHints.RESULT_TYPE, value=ResultType.Map)Hint values are case-insensitive. "" could be used instead of default value ResultType.Array.
- See Also:
QueryHints.RESULT_TYPE,Record,DatabaseRecord,ReportQueryResult,ReportQuery.setReturnType(int),DataReadQuery.setResultType(int)- Author:
- James Sutherland
-
-
Field Summary
Fields Modifier and Type Field Description static java.lang.StringArrayAn Object array of values is returned (List<Object[]> or Object[]).static java.lang.StringAttributeA List of the first selected value is returned.static java.lang.StringDEFAULTThe default type is Array.static java.lang.StringMapA Map of key value pairs is returned.static java.lang.StringValueThe first value of the first rows is returned.
-
Constructor Summary
Constructors Constructor Description ResultType()
-
-
-
Field Detail
-
Array
public static final java.lang.String Array
An Object array of values is returned (List<Object[]> or Object[]).- See Also:
- Constant Field Values
-
Map
public static final java.lang.String Map
A Map of key value pairs is returned. For a native queries the keys are the column names, (List<DatabaseRecord>, or DatabaseRecord). For JPQL queries the keys are the attribute names, (List<ReportQueryResult>, or ReportQueryResult).- See Also:
- Constant Field Values
-
Attribute
public static final java.lang.String Attribute
A List of the first selected value is returned.- See Also:
- Constant Field Values
-
Value
public static final java.lang.String Value
The first value of the first rows is returned.- See Also:
- Constant Field Values
-
DEFAULT
public static final java.lang.String DEFAULT
The default type is Array.- See Also:
- Constant Field Values
-
-