ResultSet

The attribute ResultSet defines the type of result set:

• TYPE_FORWARD_ONLY (Default): indicating the type for a ResultSet object whose cursor may move only forward
• TYPE_SCROLL_INSENSITIVE: indicating the type for a ResultSet object that is scrollable but generally not sensitive to changes to the data that underlies the ResultSet
• TYPE_SCROLL_SENSITIVE: indicating the type for a ResultSet object that is scrollable and generally sensitive to changes to the data that underlies the ResultSet

It has two subelements:

• Description
• Formatter

and the following attributes:

• rsType: defines the type of result set;
• rsConcurrency: defines the access to the result set:
  CONCUR_READ_ONLY (Default): indicating the concurrency mode for a ResultSet object that may NOT be updated.
  CONCUR_UPDATABLE : indicating the concurrency mode for a ResultSet object that may be updated;
• rsHoldability: This attribute defines the opening and closing of cursors:
  HOLD_CURSORS_OVER_COMMIT (Default): indicating that open ResultSet objects with this holdability will remain open when the current transaction is committed
  CLOSE_CURSORS_AT_COMMIT : indicating that open ResultSet objects with this holdability will be closed when the current transaction is committed.