Difference between revisions of "ResultSet"
Line 1: | Line 1: | ||
− | + | ==Description== | |
− | + | The element ResultSet allows to define the type of the result set. | |
− | |||
− | |||
+ | =={{GVESB}} Configuration== | ||
− | + | The ResultSet Element is used by: [[DBOperations]]. | |
− | * | + | The following table shows its attributes: |
− | * | + | {|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 changes to the | ||
+ | data that underlies 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: | |
− | + | * [[Description]] | |
− | + | * [[Simpleformatter]] or [[DMLWriteFormatter]] or [[CallSPFormatter]] or [[QueryFormatter]] | |
− | * | ||
− | * |
Revision as of 14:29, 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:
data that underlies the ResultSet Default : TYPE_FORWARD_ONLY |
rsConcurrency | optional | This attribute defines the access to the result set:
Default : CONCUR_READ_ONLY |
rsHoldability | optional | This attribute defines the opening and closing of cursors:
transaction will be committed
transaction will be committed Default : HOLD_CURSORS_OVER_COMMIT |
Might contain the following sub-elements: