QueryFormatter

From GreenVulcano Wiki
Jump to: navigation, search

Description

The QueryFormatter element is the Formatter of a SQL query.

GreenVulcano® ESB Configuration

The QueryFormatter Element is used by: ResultSet.

The following table shows its attributes:

Attribute Type Description
type fixed This attribute must assume the value formatter.
class fixed This attribute must assume the value it.greenvulcano.gvesb.j2ee.db.formatter.QueryFormatter.
success required This attribute defines the return value from SQL query execution if successfully completed.

The attribute's value can't be null.

failure required The attribute defines the return value from SQL query if the execution ends with error.

The attribute's value can't be null.

Might contain the sub-element:

QueryXMLBaseFormatter

This element defines the formatter of a SQL query based on XML.

The QueryXMLBaseFormatter Element is used by: QueryFormatter.

The following table shows its attributes:

Attribute Type Description
type fixed This attribute must assume the value base_formatter.
class fixed This attribute must assume the value it.greenvulcano.gvesb.j2ee.db.formatter.base.QueryXMLBaseFormatter.
encoding optional This element defines the encoding to use for the XML document that wraps the query result.

The attribute's admitted values are:

  • US-ASCII
  • ISO-8859-1
  • ISO-8859-15
  • ISO-LATIN-1
  • UTF-8
  • UTF-16BE
  • UTF-16LE
  • UTF-16

The attribute's value cannot be null.

stylesheet optional This element defines the stylesheet to use for the XML document that wraps the query result.

The attribute's value cannot be null.

structure optional This element defines the structure of the XML document that wraps the query result.
  • ONLY_DATA Inserts the XML document only the output of the query.
  • METADATA_AND_DATA Inserts the XML document the query output, plus some information about DB objects (table, fields)

The attribute's default value is: METADATA_AND_DATA.

Might contain the sub-element: