ResultSet

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:

• Description
• Simpleformatter or DMLWriteFormatter or CallSPFormatter or QueryFormatter