DBOCallSP
Description
The DBOCallSP element represents the DBO optimized for operations on store procedures.
GreenVulcano® ESB configuration
DBOCallSP might contain the following sub-elements:
Its attributes are:
- type: dbo
- class: it.greenvulcano.gvesb.datahandling.dbo.DBOCallSP
- 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
call - call procedure mode - execute-query (true|false): This parameter specifies is the callable statements must be executed with API CallableStatement#executeQuery().
Default is false. - 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"?>
<dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation"
name="TestInsertXML" type="call">
<DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"
isXA="true" jdbc-connection-name="ds.gv_test"
name="TestInsertXML" transacted="true"
type="dbobuilder">
<DBOCallSP class="it.greenvulcano.gvesb.datahandling.dbo.DBOCallSP"
name="InsertXML" transformation="InsertXML"
type="dbo">
<CallDescriptor>
<statement id="0" type="callsp">begin load_xml_file(?, ?, ?); end;</statement>
<SPOutputParameters>
<SPOutputParameter db-type="number"
java-type="string" position="3"
prop-name="RESULT"
return-in-prop="false"/>
</SPOutputParameters>
</CallDescriptor>
</DBOCallSP>
</DBOBuilder>
</dh-call>