DBOCallSP

From GreenVulcano Wiki
Revision as of 08:41, 29 March 2012 by Anonymous (talk) (Created page with "==Description== The DBOCallSP element represents the DBO optimized for operations on store procedures. =={{GVESB}} configuration== [[File:DBOCallSP.jpg|thumb|DBOCallSP with Vul...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Description

The DBOCallSP element represents the DBO optimized for operations on store procedures.

GreenVulcano® ESB configuration

DBOCallSP with VulCon

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>