Difference between revisions of "ResultSet"

From GreenVulcano Wiki
Jump to: navigation, search
({{GVESB}} Configuration)
 
(2 intermediate revisions by the same user not shown)
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.
* 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
 
  
 +
=={{GVESB}} Configuration==
  
It has two subelements:
+
The ResultSet Element is used by: [[DBOperations]].
  
* Description
+
The following table shows its attributes:
* [[Formatter]]
+
{|class="gvtable"
 +
! 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
 +
|}
  
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]]
* ''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.
 

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: