Difference between revisions of "ResultSet"

Latest revision as of 15:56, 3 April 2012

The element ResultSet allows to define the type of the result set.

The ResultSet Element is used by: DBOperations.

The following table shows its attributes:

Attribute

Type

Description

rsType

optional

This attribute defines the type of result set:

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 data changes that underly the ResultSet

Default : TYPE_FORWARD_ONLY

rsConcurrency

optional

This attribute defines the access to the result set:

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

Default : CONCUR_READ_ONLY

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

Might contain the following sub-elements:

@@ 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
-* 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
 |}