Class ResultSetType


  • public class ResultSetType
    extends Object
    JDBC ResultSet type hint values. The class contains all the valid values for QueryHints.RESULT_SET_TYPE query hint. This can be used on ScrollableCursor queries to set the JDBC ResultSet scroll type. JPA Query Hint Usage:

    query.setHint(QueryHints.RESULT_SET_TYPE, ResultSetType.ForwardOnly);

    or

    @QueryHint(name=QueryHints.RESULT_SET_TYPE, value=ResultSetType.ForwardOnly)

    Hint values are case-insensitive. "" could be used instead of default value ResultSetType.ScrollInsensitive.

    Author:
    James Sutherland
    See Also:
    QueryHints.RESULT_SET_TYPE, ScrollableCursorPolicy.setResultSetType(int)
    • Field Detail

      • Forward

        public static final String Forward
        The rows in a result set will be processed in a forward direction; first-to-last.
        See Also:
        Constant Field Values
      • ForwardOnly

        public static final String ForwardOnly
        The type for a ResultSet object whose cursor may move only forward.
        See Also:
        Constant Field Values
      • Unknown

        public static final String Unknown
        The order in which rows in a result set will be processed is unknown.
        See Also:
        Constant Field Values
      • Reverse

        public static final String Reverse
        The rows in a result set will be processed in a reverse direction; last-to-first.
        See Also:
        Constant Field Values
      • ScrollInsensitive

        public static final String ScrollInsensitive
        The type for a ResultSet object that is scrollable but generally not sensitive to changes made by others.
        See Also:
        Constant Field Values
      • ScrollSensitive

        public static final String ScrollSensitive
        The type for a ResultSet object that is scrollable and generally sensitive to changes made by others.
        See Also:
        Constant Field Values
    • Constructor Detail

      • ResultSetType

        public ResultSetType()