Difference between revisions of "DBOBuilder"
| Line 1: | Line 1: | ||
| − | DBOBuilder | + | ==Description== |
| + | |||
| + | The DBOBuilder element represents a DataHandler service. | ||
| + | |||
| + | =={{GVESB}} configuration== | ||
| + | |||
| + | The DBOBuilder element is used by [[dh-call]] plugin. | ||
| + | |||
| + | Might contain more DBOs, which will be executed in order of definition. By default returns the output as a result of the last DBO. | ||
| + | |||
| + | The output of a DBO can be used as input of the next. | ||
| + | |||
| + | DBOBuilder returns the following statistics about the operations done: | ||
| + | * Records read | ||
| + | * Records inserted | ||
| + | * Records updated | ||
| + | * Records discarded | ||
| + | * Report about discarded records | ||
It has the following attributes: | It has the following attributes: | ||
| Line 24: | Line 41: | ||
For example: | For example: | ||
<syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?> | <syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?> | ||
| − | <dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation" name="TestInsertXML" type="call"> | + | <dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation" |
| − | <DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder" jdbc-connection-name="" name="" type="dbobuilder"> | + | name="TestInsertXML" type="call"> |
| − | <DBOSelect class="it.greenvulcano.gvesb.datahandling.dbo.DBOSelect" name="" type="dbo"> | + | <DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder" |
| + | jdbc-connection-name="" name="" type="dbobuilder"> | ||
| + | <DBOSelect class="it.greenvulcano.gvesb.datahandling.dbo.DBOSelect" | ||
| + | name="" type="dbo"> | ||
<statement type="select"/> | <statement type="select"/> | ||
</DBOSelect> | </DBOSelect> | ||
| Line 32: | Line 52: | ||
</dh-call> | </dh-call> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| + | |||
DBOBuilder accepts as children: | DBOBuilder accepts as children: | ||
| − | * Description | + | * [[Description]] |
* DHAliasList: List of aliases for a given DataHandler service. It contains | * DHAliasList: List of aliases for a given DataHandler service. It contains | ||
| Line 45: | Line 66: | ||
*** ''value'': variable value | *** ''value'': variable value | ||
| − | * [[DBOSelect]] | + | * [[#BDO|DBO]] |
| + | |||
| + | ====DBO==== | ||
| + | |||
| + | The DBO elements represent the elementary operations of DataHandler that can be combined in a service. Those are: | ||
| + | |||
| + | * [[DBOSelect]] | ||
* [[DBOThreadSelect]] | * [[DBOThreadSelect]] | ||
* [[DBOUpdate]] | * [[DBOUpdate]] | ||
| Line 54: | Line 81: | ||
* [[DBOFlatSelect]] | * [[DBOFlatSelect]] | ||
* [[DBOMultiFlatSelect]] | * [[DBOMultiFlatSelect]] | ||
| + | |||
| + | Inside of it you can include SQL statements which may contain metadata that will be resolved prior to execution. | ||
| + | |||
| + | You can also add more DHVariable elements that define default values for properties that may be missing in [[GVBuffer]]. | ||
Revision as of 11:33, 30 March 2012
Description
The DBOBuilder element represents a DataHandler service.
GreenVulcano® ESB configuration
The DBOBuilder element is used by dh-call plugin.
Might contain more DBOs, which will be executed in order of definition. By default returns the output as a result of the last DBO.
The output of a DBO can be used as input of the next.
DBOBuilder returns the following statistics about the operations done:
- Records read
- Records inserted
- Records updated
- Records discarded
- Report about discarded records
It has the following attributes:
| Attribute | Type | Description |
|---|---|---|
| type | fixed | This attribute must assume the value dbobuilder. |
| class | fixed | This attribute must assume the value it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder |
| name | required | Service name |
| jdbc-connection-name | required | DataSource JNDI name |
| transacted | optional | Defines if the services must be executed in transaction. Default true. |
| isXA | optional | If the service is transacted, this attributes indicates if it participates in a distributed transaction or not. If false the DataHandler handle a local transaction. Default false |
| output-data | optional | The default is the value of @output-data of the last DBOxxx; |
| make-dump | optional | If set to none not perform the input/output data dump. If set to text or hex then the dump is performed as text or hexadecimal string. Default to text. |
For example:
<?xml version="1.0" encoding="UTF-8"?>
<dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation"
name="TestInsertXML" type="call">
<DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"
jdbc-connection-name="" name="" type="dbobuilder">
<DBOSelect class="it.greenvulcano.gvesb.datahandling.dbo.DBOSelect"
name="" type="dbo">
<statement type="select"/>
</DBOSelect>
</DBOBuilder>
</dh-call>
DBOBuilder accepts as children:
- DHAliasList: List of aliases for a given DataHandler service. It contains
- DHAlias: Alias for a DataHandler service with its Description
- DHVariables: List of default values for DataHandler service's variables. It contains
- DHVariable: Default value for DataHandler service's variable including the parameters
- Description
- name: variable name
- value: variable value
- DHVariable: Default value for DataHandler service's variable including the parameters
DBO
The DBO elements represent the elementary operations of DataHandler that can be combined in a service. Those are:
- DBOSelect
- DBOThreadSelect
- DBOUpdate
- DBOInsert
- DBOInsertOrUpdate
- DBOUpdateOrInsert
- DBOCallSP
- DBOFlatSelect
- DBOMultiFlatSelect
Inside of it you can include SQL statements which may contain metadata that will be resolved prior to execution.
You can also add more DHVariable elements that define default values for properties that may be missing in GVBuffer.
