ResultSet - Revision history

Anonymous: /* {{GVESB}} Configuration */

2012-04-03T15:56:07Z

‎{{GVESB}} Configuration

Anonymous: /* {{GVESB}} Configuration */

2012-04-03T15:55:41Z

‎{{GVESB}} Configuration

Anonymous at 14:29, 3 April 2012

2012-04-03T14:29:41Z

Anonymous at 13:36, 26 January 2012

2012-01-26T13:36:30Z

Anonymous: 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..."

2012-01-23T14:11:48Z

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..."

New page

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: <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.

@@ Line 23: / Line 23: @@
 |-
 | rsHoldability || optional || This attribute defines the opening and closing of cursors:
-* HOLD_CURSORS_OVER_COMMIT : indicating that open ResultSet objects with this holdability will remain open when the current
+* HOLD_CURSORS_OVER_COMMIT : indicating that open ResultSet objects with this holdability will remain open when the current transaction will be committed
-transaction will be committed
+* CLOSE_CURSORS_AT_COMMIT : indicating that open ResultSet objects with this holdability will be closed when the current transaction will be committed
 Default : HOLD_CURSORS_OVER_COMMIT
 |}

@@ Line 14: / Line 14: @@
 * TYPE_FORWARD_ONLY : 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 data changes that underly the ResultSet
-* TYPE_SCROLL_SENSITIVE : indicating the type for a ResultSet object that is scrollable and generally sensitive to changes to the
+* TYPE_SCROLL_SENSITIVE : indicating the type for a ResultSet object that is scrollable and generally sensitive to data changes that underly the ResultSet
 Default : TYPE_FORWARD_ONLY
 |-

@@ Line 1: / Line 1: @@
-The attribute ResultSet defines the type of result set:
+==Description==
-* TYPE_FORWARD_ONLY (Default): indicating the type for a ResultSet object whose cursor may move only forward
+The element ResultSet allows to define the type of the result set.
-It has two subelements:
+The ResultSet Element is used by: [[DBOperations]].
-* Description
+The following table shows its attributes:
-* [[Formatter]]
+{|class="gvtable"
-and the following attributes:
+Might contain the following sub-elements:
+* [[Description]]
-* ''rsType'': defines the type of result set;
+* [[Simpleformatter]] or [[DMLWriteFormatter]] or [[CallSPFormatter]] or [[QueryFormatter]]

@@ Line 13: / Line 13: @@
 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.