Difference between revisions of "DBOUpdateOrInsert"
(Created page with "==Description== The DBOUpdateOrInsert element runs the update, and if no record updated, the corresponding insert. =={{GVESB}} configuration== [[File:DBOUpdateOrInsert.jpg|thum...") |
(→{{GVESB}} configuration) |
||
| Line 16: | Line 16: | ||
* ''name'' | * ''name'' | ||
* ''transformation'' | * ''transformation'' | ||
| − | * ''force-mode'' (caller|xml2db): Force mode of the DBO, can be used in DBOBuilder whit more heterogeneous DBO. <br/> Mode:<br/> caller - inherit the mode of the caller<br/> xml2db - data entry mode | + | * ''force-mode'' (caller|xml2db): Force mode of the DBO, can be used in [[DBOBuilder]] whit more heterogeneous DBO. <br/> Mode:<br/> caller - inherit the mode of the caller<br/> xml2db - data entry mode |
| − | * ''jdbc-connection-name'': DataSource JNDI name. <br/> Override connection defined in DBOBuilder. | + | * ''jdbc-connection-name'': DataSource JNDI name. <br/> Override connection defined in [[DBOBuilder]]. |
* ''ignore-input'' (true|false): Tell the engine do not use the input data. | * ''ignore-input'' (true|false): Tell the engine do not use the input data. | ||
* ''input-data'': The default is the value of @name-Input.<br/> Can be set as the @output-data of a preceding DBO to use its output as input. | * ''input-data'': The default is the value of @name-Input.<br/> Can be set as the @output-data of a preceding DBO to use its output as input. | ||
Revision as of 08:31, 29 March 2012
Description
The DBOUpdateOrInsert element runs the update, and if no record updated, the corresponding insert.
GreenVulcano® ESB configuration
DBOUpdateOrInsert might contain the following sub-elements:
Its attributes are:
- type: dbo
- class: it.greenvulcano.gvesb.datahandling.dbo.DBOUpdateOrInsert
- 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 preceding 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="CreditUpdate"type="dbobuilder">
<DHVariables>
<DHVariable name="decimal-separator" value="."/>
<DHVariable name="grouping-separator" value=","/>
<DHVariable name="format" value="#0.00"/>
</DHVariables>
<DBOUpdateOrInsert class="it.greenvulcano.gvesb.datahandling.dbo.DBOUpdateOrInsert"
name="CreditUpdate" transformation="CreditUpdate" type="dbo">
<statement id="0" type="insert">insert into CREDIT_CARD (......) values (SEQ_PERSON_ID.nextval, ?, ?, ?, ?)</statement>
<statement id="0" type="update">update CREDIT_CARD set CREDIT=?, ENABLED=? where CNUMBER=? and ID_OWNER=?</statement>
</DBOUpdateOrInsert>
</DBOBuilder>
