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:
