Class ScrollableCursorPolicy

All Implemented Interfaces:
Serializable, Cloneable, CoreContainerPolicy<AbstractSession>

public class ScrollableCursorPolicy extends CursorPolicy
PUBLIC: ScrollableCursorPolicy allows for additional options to be specified for ReadAllQuery or DataReadQuery. These options are passed through to the JDBC result set, the JDBC driver must support JDBC2 scrolling cursors and the options used. Example:

ScrollableCursorPolicy policy = new ScrollableCursorPolicy()

policy.setResultSetType(ScrollableCursorPolicy.TYPE_SCROLL_INSENSITIVE);

query.useScrollableCursor(policy);

See Also:
  • Field Details

    • resultSetType

      protected int resultSetType
    • resultSetConcurrency

      protected int resultSetConcurrency
    • FETCH_FORWARD

      public static final int FETCH_FORWARD
      JDBC 2.0 The rows in a result set will be processed in a forward direction; first-to-last.
      See Also:
    • FETCH_REVERSE

      public static final int FETCH_REVERSE
      JDBC 2.0 The rows in a result set will be processed in a reverse direction; last-to-first.
      See Also:
    • FETCH_UNKNOWN

      public static final int FETCH_UNKNOWN
      JDBC 2.0 The order in which rows in a result set will be processed is unknown.
      See Also:
    • TYPE_FORWARD_ONLY

      public static final int TYPE_FORWARD_ONLY
      JDBC 2.0 The type for a ResultSet object whose cursor may move only forward.
      See Also:
    • TYPE_SCROLL_INSENSITIVE

      public static final int TYPE_SCROLL_INSENSITIVE
      JDBC 2.0 The type for a ResultSet object that is scrollable but generally not sensitive to changes made by others.
      See Also:
    • TYPE_SCROLL_SENSITIVE

      public static final int TYPE_SCROLL_SENSITIVE
      JDBC 2.0 The type for a ResultSet object that is scrollable and generally sensitive to changes made by others.
      See Also:
    • CONCUR_READ_ONLY

      public static final int CONCUR_READ_ONLY
      JDBC 2.0 The concurrency mode for a ResultSet object that may NOT be updated.
      See Also:
    • CONCUR_UPDATABLE

      public static final int CONCUR_UPDATABLE
      JDBC 2.0 The concurrency mode for a ResultSet object that may be updated.
      See Also:
  • Constructor Details

    • ScrollableCursorPolicy

      public ScrollableCursorPolicy()
      PUBLIC: Create a new scrollable cursor policy.
    • ScrollableCursorPolicy

      public ScrollableCursorPolicy(ReadQuery query, int pageSize)
      INTERNAL: Create a cursor policy with the pagesize.
  • Method Details

    • execute

      public Object execute()
      INTERNAL: Execute the cursored select and build the stream.
      Specified by:
      execute in class CursorPolicy
    • getResultSetConcurrency

      public int getResultSetConcurrency()
      PUBLIC: The ResultSetConcurrency specifies if the resultset is updatable. It is one of, CONCUR_READ_ONLY, CONCUR_UPDATABLE
    • getResultSetType

      public int getResultSetType()
      PUBLIC: The ResultSetType specifies if the resultset is sensitive to changes made by others. It is one of, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE
    • isScrollableCursorPolicy

      public boolean isScrollableCursorPolicy()
      Overrides:
      isScrollableCursorPolicy in class ContainerPolicy
    • remoteExecute

      public Object remoteExecute()
      INTERNAL: Execute the cursored select and build the stream.
      Specified by:
      remoteExecute in class CursorPolicy
    • setResultSetConcurrency

      public void setResultSetConcurrency(int resultSetConcurrency)
      PUBLIC: The ResultSetConcurrency specifies if the resultset is updatable. It is one of, CONCUR_READ_ONLY, CONCUR_UPDATABLE
    • setResultSetType

      public void setResultSetType(int resultSetType)
      PUBLIC: The ResultSetType specifies if the resultset is sensitive to changes made by others. It is one of, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE