Difference between revisions of "ResultSet"
(→{{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 | + | * 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 | 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:
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:
Default : HOLD_CURSORS_OVER_COMMIT |
Might contain the following sub-elements: