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 Summary

      Fields 
      Modifier and Type Field Description
      static String DEFAULT
      The default type is ScrollInsensitive.
      static String Forward
      The rows in a result set will be processed in a forward direction; first-to-last.
      static String ForwardOnly
      The type for a ResultSet object whose cursor may move only forward.
      static String Reverse
      The rows in a result set will be processed in a reverse direction; last-to-first.
      static String ScrollInsensitive
      The type for a ResultSet object that is scrollable but generally not sensitive to changes made by others.
      static String ScrollSensitive
      The type for a ResultSet object that is scrollable and generally sensitive to changes made by others.
      static String Unknown
      The order in which rows in a result set will be processed is unknown.
    • Constructor Summary

      Constructors 
      Constructor Description
      ResultSetType()  
    • 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()