Difference between revisions of "ResultSet"

From GreenVulcano Wiki
Jump to: navigation, search
({{GVESB}} Configuration)
 
(One intermediate revision by the same user not shown)
Line 14: Line 14:
 
* TYPE_FORWARD_ONLY : indicating the type for a ResultSet object whose cursor may move only forward
 
* 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_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  
data that underlies the ResultSet  
 
 
Default : TYPE_FORWARD_ONLY
 
Default : TYPE_FORWARD_ONLY
 
|-
 
|-
Line 24: Line 23:
 
|-
 
|-
 
| rsHoldability || optional || This attribute defines the opening and closing of cursors:
 
| 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
 
Default : HOLD_CURSORS_OVER_COMMIT
 
|}
 
|}

Latest revision as of 15:56, 3 April 2012

Description

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

GreenVulcano® ESB Configuration

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: