DBOInsertOrUpdate - Revision history

Anonymous: /* {{GVESB}} configuration */

2012-11-12T12:11:33Z

‎{{GVESB}} configuration

Anonymous: /* {{GVESB}} configuration */

2012-04-02T12:05:06Z

‎{{GVESB}} configuration

Anonymous at 08:25, 29 March 2012

2012-03-29T08:25:55Z

Anonymous: Created page with "==Description== The DBOInsertOrUpdate element running the insert, and in case of collision, the corresponding update. =={{GVESB}} configuration== [[File:DBOInsertOrUpdate.jpg|t..."

2012-03-29T08:22:56Z

Created page with "==Description== The DBOInsertOrUpdate element running the insert, and in case of collision, the corresponding update. =={{GVESB}} configuration== [[File:DBOInsertOrUpdate.jpg|t..."

New page

==Description==

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

=={{GVESB}} configuration==
[[File:DBOInsertOrUpdate.jpg|thumb|DBOInsertOrUpdate with VulCon]]
DBOInsertOrUpdate might contain the following sub-elements:
* [[Description]]
* [[DHVariables]]
* [[statement]]

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:
<syntaxhighlight lang="XML"><?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>
</syntaxhighlight>

@@ Line 20: / Line 20: @@
 | name || required || DBOUpdate name
 |-
-| transformation || required || Transformation name
+| transformation || required || Transformation to be applied on the input data to obtain the internal XML commands.
 |-
 | duplicate-insert-code || optional || Specifies the error code when inserting with duplicate key.

@@ Line 10: / Line 10: @@
 * [[statement]]
-Its attributes are:
+The following table shows the DBOInsertOrUpdate attributes:
+{|class="gvtable"
-* ''type'': dbo
+! Attribute !! Type !! Description
-* ''class'': it.greenvulcano.gvesb.datahandling.dbo.DBOInsertOrUpdate
+|-
-* ''name''
+| type || fixed || This attribute must assume the value '''dbo'''
-* ''transformation''
+|-
-* ''duplicate-insert-code'': Specifies the error code when inserting with duplicate key.
+| class || fixed || This attribute must assume the value '''it.greenvulcano.gvesb.datahandling.dbo.DBOInsertOrUpdate'''
-* ''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.
+| name || required || DBOUpdate name
-* ''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 preceeding DBO to use its output as input.
+| transformation || required || Transformation name
-* ''output-data'':  The default is the value of @name-Output.
+|-
 For example:

@@ Line 1: / Line 1: @@
 ==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==