ResultSet

From GreenVulcano Wiki
Jump to: navigation, search

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: