Difference between revisions of "ResultSet"

From GreenVulcano Wiki
Jump to: navigation, search
(Created page with "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_SCROL...")
 
Line 13: Line 13:
 
and the following attributes:
 
and the following attributes:
  
* rsType: defines the type of result set;
+
* ''rsType'': defines the type of result set;
* rsConcurrency: defines the access to the result set: <br/> CONCUR_READ_ONLY (Default): indicating the concurrency mode for a ResultSet object that may NOT be updated. <br/> CONCUR_UPDATABLE : indicating the concurrency mode for a ResultSet object that may be updated;
+
* ''rsConcurrency'': defines the access to the result set: <br/> CONCUR_READ_ONLY (Default): indicating the concurrency mode for a ResultSet object that may NOT be updated. <br/> CONCUR_UPDATABLE : indicating the concurrency mode for a ResultSet object that may be updated;
* rsHoldability: This attribute defines the opening and closing of cursors: <br/> HOLD_CURSORS_OVER_COMMIT (Default): indicating that open ResultSet objects with this holdability will remain open when the current transaction is committed <br/> CLOSE_CURSORS_AT_COMMIT : indicating that open ResultSet objects with this holdability will be closed when the current transaction is committed.
+
* ''rsHoldability'': This attribute defines the opening and closing of cursors: <br/> HOLD_CURSORS_OVER_COMMIT (Default): indicating that open ResultSet objects with this holdability will remain open when the current transaction is committed <br/> CLOSE_CURSORS_AT_COMMIT : indicating that open ResultSet objects with this holdability will be closed when the current transaction is committed.

Revision as of 13:36, 26 January 2012

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:

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.