DBOCallSP - Revision history

G.dimaio at 08:10, 12 January 2016

2016-01-12T08:10:43Z

G.dimaio at 07:58, 12 January 2016

2016-01-12T07:58:04Z

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

2012-11-12T12:41:58Z

‎{{GVESB}} configuration

Anonymous: 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..."

2012-03-29T08:41:30Z

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..."

New page

==Description==

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

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

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

@@ Line 46: / Line 46: @@
 As an example, see the following stored procedure:
 <syntaxhighlight lang="sql">
-PROCEDURE LOAD_XML_FILE (v_file_name in varchar2, v_file in CLOB, v_file_id out number)
+PROCEDURE LOAD_XML_FILE (v_file_name IN VARCHAR2, v_file IN CLOB, v_file_id OUT NUMBER) AS
 ....
 </syntaxhighlight>
@@ Line 86: / Line 86: @@
      &lt;/PersonData&gt;
      &lt;/PersonsData&gt;</col>
          </row>
      </data>
 </RowSet>
 </syntaxhighlight>

@@ Line 11: / Line 11: @@
 Its attributes are:
+{|class="gvtable"
-* ''type'': dbo
+! Attribute !! Type !! Description
-* ''class'': it.greenvulcano.gvesb.datahandling.dbo.DBOCallSP
+|-
-* ''name''
+| type || fixed || This attribute must assume the value '''dbo'''
-* ''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/>  call - call procedure mode
+| class || fixed || This attribute must assume the value '''it.greenvulcano.gvesb.datahandling.dbo.DBOCallSP'''
-* ''execute-query'' (true|false): This parameter specifies is the callable statements must be executed with API CallableStatement#executeQuery(). <br/>   Default is false.
+|-
-* ''jdbc-connection-name'':  DataSource JNDI name. <br/>  Override connection defined in [[DBOBuilder]].
+| name || required || DBOCallSP 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 preceding DBO to use its output as input.
+| transformation || optional || Transformation to be applied on the input data to obtain the internal XML commands.
-* ''output-data'':  The default is the value of @name-Output.
+|-
 For example:

@@ Line 44: / Line 44: @@
 |}
-For example:
+As an example, see the following stored procedure:
-<syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
+<syntaxhighlight lang="sql">
 <dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation"
        name="TestInsertXML" type="call">
@@ Line 67: / Line 71: @@
      </DBOBuilder>
 </dh-call>
 </syntaxhighlight>