DBOFlatSelect

Description

The DBOFlatSelect element represents the DBO optimized for select operations and conversion in CSV rows.

GreenVulcano^® ESB configuration

DBOFlatSelect with VulCon

DBOFlatSelect allows you to run a select on the database. The result of the select will be a CSV document.

Must be defined for each field the FieldFormatter, that allows you to force the formatting of the values ​​extracted from the database

Might contain the following sub-elements:

• Description
• DHVariables
• FieldFormatters
• statement

Its attributes are:

• type: dbo
• class: it.greenvulcano.gvesb.datahandling.dbo.DBOFlatSelect
• name
• force-mode (caller|xml2db): Force mode of the DBO, can be used in DBOBuilder whit more heterogeneous DBO.
  Mode:
  caller - inherit the mode of the caller
  db2xml - data extraction mode
• jdbc-connection-name: DataSource JNDI name.
  Override connection defined in DBOBuilder.
• ignore-input (true|false): Tell the engine do not use the input data.
• output-data: The default is the value of @name-Output.

For example:

<?xml version="1.0" encoding="UTF-8"?>
 <DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"
            jdbc-connection-name="ds.gv_cama" make-dump="none" name="Partners_FinalReport" type="dbobuilder">
       <DBOFlatSelect class="it.greenvulcano.gvesb.datahandling.dbo.DBOFlatSelect" name="Partners_FinalReport-select" type="dbo">
            <FieldFormatters id="0">
                  <FieldFormatter field-id="1,2,3" terminator-char=","  type="field-formatter"/>
                  <FieldFormatter date-format="yyyyMMddHHmmssSSS" field-id="4" type="field-formatter"/>
            </FieldFormatters>
            <statement id="0" type="select">SELECT m.CAMPAIGN, c.MSISDN, c.EVENT_TIME, c.EVENT
                  FROM CAMA.CDR_EVENT c, CAMA.MESSAGES m, CAMA.PARTNERS p
                  where m.ID = c.MSG_ID, ...</statement>
       </DBOFlatSelect>
 </DBOBuilder>