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 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: