DBOUpdate

Description

The DBOUpdate element represents the DBO optimized for update operations.

GreenVulcano^® ESB configuration

DBOUpdate with VulCon

DBOUpdate might contain the following sub-elements:

• Description
• DHVariables
• statement

Its attributes are:

• type: dbo
• class: it.greenvulcano.gvesb.datahandling.dbo.DBOUpdate
• name
• transformation
• 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
  xml2db - data entry 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.
• input-data: The default is the value of @name-Input.
  Can be set as the @output-data of a preceeding DBO to use its output as input.
• 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_test" name="PersonInsertFull" type="dbobuilder">
       <DHVariables>
             <DHVariable name="decimal-separator" value="."/>
             <DHVariable name="grouping-separator" value=","/>
             <DHVariable name="format" value="#0.00"/>
       </DHVariables>
       <DBOUpdate class="it.greenvulcano.gvesb.datahandling.dbo.DBOUpdate"
               name="PersonInsertFull" transformation="PersonInsertFull" type="dbo">
             <statement id="0" type="update">update PERSON set ID_CITY=? where ID=?</statement>
             <statement id="1" type="update">update CREDIT_CARD  set CREDIT=?, ENABLED=? where ID=?</statement>
       </DBOUpdate>
 </DBOBuilder>