Difference between revisions of "DBOInsertOrUpdate"

From GreenVulcano Wiki
Jump to: navigation, search
(Created page with "==Description== The DBOInsertOrUpdate element running the insert, and in case of collision, the corresponding update. =={{GVESB}} configuration== [[File:DBOInsertOrUpdate.jpg|t...")
 
Line 1: Line 1:
 
==Description==
 
==Description==
  
The DBOInsertOrUpdate element running the insert, and in case of collision, the corresponding update.
+
The DBOInsertOrUpdate element runs the insert, and in case of collision, the corresponding update.
  
 
=={{GVESB}} configuration==
 
=={{GVESB}} configuration==

Revision as of 08:25, 29 March 2012

Description

The DBOInsertOrUpdate element runs the insert, and in case of collision, the corresponding update.

GreenVulcano® ESB configuration

DBOInsertOrUpdate with VulCon

DBOInsertOrUpdate might contain the following sub-elements:

Its attributes are:

  • type: dbo
  • class: it.greenvulcano.gvesb.datahandling.dbo.DBOInsertOrUpdate
  • name
  • transformation
  • duplicate-insert-code: Specifies the error code when inserting with duplicate key.
  • 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" isXA="true" jdbc-connection-name="ds.gv_cama"
         name="UpdateCDREvent" type="dbobuilder">
      <DBOInsertOrUpdate class="it.greenvulcano.gvesb.datahandling.dbo.DBOInsertOrUpdate" duplicate-insert-code="-104"
                 name="UpdateCDREvent-update" transformation="UpdateCDRData" type="dbo">
            <statement id="0" type="insert">insert into cama.cdr_event (......) values (?, ?, ?, ?, sysdate)</statement>
            <statement id="0" type="update">update cama.cdr_event set EVENT_TIME = ?, ... where MSG_ID=? and ...</statement>
      </DBOInsertOrUpdate>
 </DBOBuilder>