Class ResultType


  • public class ResultType
    extends Object
    Result 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.

    Author:
    James Sutherland
    See Also:
    QueryHints.RESULT_TYPE, Record, DatabaseRecord, ReportQueryResult, ReportQuery.setReturnType(int), DataReadQuery.setResultType(int)
    • Field Detail

      • Array

        public static final String Array
        An Object array of values is returned (List<Object[]> or Object[]).
        See Also:
        Constant Field Values
      • Map

        public static final 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
    • Constructor Detail

      • ResultType

        public ResultType()