db-call

Defines the parameters to perform an operation on DB.

Fixed attributes:

  • type: Unmodifiable. Used by GreenVulcanoESB factory framework.
  • class: Unmodifiable. Used by GreenVulcanoESB factory framework.

Required attributes:

  • name: Operation name. Used in the ‘Flow’ section to associate workflow nodes to VCL operations.

Subelements

db-call has the followong subelements:

  • Description (optional).
  • DBOperations (one element).

DBOperations

This element configures an interaction with a database.

Subelements

DBOperations has the followong subelements:

Statement

Required attributes:

  • statementType: This element represents the type of statement to use. We recommend using a CallableStatement to process stored procedures.

Subelements

Statement has the followong subelements:

  • StatementValue (one element).
  • ParamResolvers (optional).

ParamResolvers

This element contains the list of Resolver used to resolve the parameters included in the statement. Resolvers are applied in sequence, the order of definition, and can be of different types.

Subelements

ParamResolvers has the followong subelement:

  • ParamResolver (at least one element).

ParamResolver

This element represents the type of a resolver to use to solve the parameters included in the statement.

Subelements

ParamResolver has the followong subelements:

ResultSet

Implied attributes:

  • rsConcurrency: 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: 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 is commited
    • CLOSE_CURSORS_AT_COMMIT : indicating that open ResultSet objects with this holdability will be closed when the current transaction is commited Default : HOLD_CURSORS_OVER_COMMIT.
  • rsType: 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 changes to the data that underlies 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.

Subelements

ResultSet has the followong subelements: