Difference between revisions of "Statement"

From GreenVulcano Wiki
Jump to: navigation, search
(Replaced content with "==Description== This element defines the statement to be evaluated. Can contains placeholders that will be replaced at runtime. =={{GVESB}} Configuration== The elemen...")
Line 1: Line 1:
 
==Description==
 
==Description==
  
−
The [[Statement]] element contains the statement to be evaluated. Those statements might contain [[placeholders]] that will be replaced at runtime.
+
This element defines the statement to be evaluated.
  
−
It is used by: [[DBOperations]].
+
Can contains [[placeholders]] that will be replaced at runtime.
  
−
The following table shows its attributes:
+
=={{GVESB}} Configuration==
−
{|class="gvtable"
 
−
! Attribute !! Type !! Description
 
−
|-
 
−
| statementType || required || This element represents the type of statement to use.
 
−
We recommend using a CallableStatement to process stored procedures.
 
−
The attribute's admitted values are:
 
−
* CallableStatement
 
−
* PreparedStatement
 
−
|}
 
  
−
Might contain the sub-elements:
+
The element statement can be used by:
−
* [[#StatementValue|StatementValue]]
+
* [[CallDescriptor]]
−
* [[#ParamResolvers|ParamResolvers]]
+
* [[DBOFlatSelect]]
−
 
+
* [[DBOInsert]]
−
===StatementValue===
+
* [[DBOInsertOrUpdate]]
−
 
+
* [[DBOMultiFlatSelect]]
−
StatementValue contains the value of the statement to be performed.
+
* [[DBOSelect]]
−
 
+
* [[DBOThreadSelect]]
−
The StatementValue Element is used by: [[Statement]].
+
* [[DBOUpdate]]
−
 
+
* [[DBOUpdateOrInsert]]
−
===ParamResolvers===
+
* [[Sheet]]
−
 
 
−
This element contains the list of Resolver used to resolve the parameters included in the statement.
 
−
 
 
−
Resolvers are applied in sequence, following the order of definition, and can be of different types.
 
−
 
 
−
The ParamResolvers Element is used by: [[Statement]].
 
−
 
 
−
Might contain more sub-elements:
 
−
* [[#ParamResolver|ParamResolver]]
 
−
 
 
−
====ParamResolver====
 
−
 
 
−
This element represents the type of a resolver to use for solving the parameters included in the statement.
 
−
 
 
−
The ParamResolver Element is used by: [[#ParamResolvers|ParamResolvers]]
 
−
 
 
−
Might contain the sub-elements:
 
−
* [[Description]]
 
−
* [[#XPathParamResolver|XPathParamResolver]] or [[#GVBufferParamResolver|GVBufferParamResolver]]
 
−
 
 
−
=====XPathParamResolver=====
 
−
 
 
−
Defines the type of Resolver based on XPath.
 
−
 
 
−
The XPathParamResolver Element is used by:  [[#ParamResolver|ParamResolver]].
 
−
The following table shows its attributes:
 
−
{|class="gvtable"
 
−
! Attribute !! Type !! Description
 
−
|-
 
−
| type || fixed || This attribute must assume the value '''resolver'''.
 
−
|-
 
−
| class || fixed || This attribute must assume the value '''it.greenvulcano.gvesb.j2ee.db.resolver.XPathResolver'''.
 
−
|}
 
−
 
 
−
Might contain the sub-elements:
 
−
* [[Description]]
 
−
* [[#Param|Param]]
 
−
 
 
−
======Param======
 
−
 
 
−
This element defines the parameter to be solved according to an XPath expression applied to the [[GVBuffer]] body.
 
−
 
 
−
The Param Element is used by: [[#XPathParamResolver|XPathParamResolver]].
 
−
 
 
−
The following table shows its attributes:
 
−
{|class="gvtable"
 
−
! Attribute !! Type !! Description
 
−
|-
 
−
| XPath || required || This attribute defines the XPath applied to the body of GVBuffer.
 
−
The attribute's value cannot be null.
 
−
|-
 
−
| position || required || This attribute defines the position parameter has in the statement.
 
−
The attribute's value cannot be null.
 
−
|-
 
−
| type || required || This attribute defines the type of the parameter.
 
−
The attribute's admitted values are:
 
−
* string
 
−
* int
 
−
* long
 
−
* float
 
−
* date
 
−
* binary
 
−
* blob
 
−
* clob
 
−
|-
 
−
| format || optional || This attribute lets you configure the date format in the event that has been defined type = 'date'.
 
−
The attribute's value cannot be null.
 
−
|}
 
−
 
 
−
Might contain the sub-elements:
 
−
* [[Description]]
 
−
 
 
−
 
 
−
=====GVBufferParamResolver=====
 
−
 
 
−
This element defines the Resolver based GVBuffer fields.
 
−
 
 
−
The GVBufferParamResolver Element is used by: [[#ParamResolver|ParamResolver]].
 
−
 
 
−
The following table shows its attributes:
 
−
{|class="gvtable"
 
−
! Attribute !! Type !! Description
 
−
|-
 
−
| type || fixed || This attribute must assume the value '''resolver'''.
 
−
|-
 
−
| class || fixed || This attribute must assume the value '''it.greenvulcano.gvesb.j2ee.db.resolver.GVBufferResolver'''.
 
−
|}
 
−
 
 
−
Might contain the sub-elements:
 
−
* [[Description]]
 
−
* [[#GVBufferParam|GVBufferParam]]
 
−
 
 
−
======GVBufferParam======
 
−
 
 
−
This element represents the field of GVBuffer which is inserted in the statement.
 
−
 
 
−
The GVBufferParam Element is used by: [[#GVBufferParamResolver|GVBufferParamResolver]].
 
−
The following table shows its attributes:
 
−
{|class="gvtable"
 
−
! Attribute !! Type !! Description
 
−
|-
 
−
| type || required || This attribute defines the type of the parameter.
 
−
The attribute's admitted values are:
 
−
* string
 
−
* int
 
−
* long
 
−
* float
 
−
* date
 
−
* binary
 
−
* blob
 
−
* clob
 
−
|-
 
−
| position || required || This attribute defines the position parameter has in the statement.
 
−
The attribute's value cannot be null.
 
−
|-
 
−
| format || optional || This attribute lets you configure the date format in the event that has been defined type = 'date'.
 
−
The attribute's value cannot be null.
 
−
|-
 
−
| GVBufferMethod || required || The attribute defines the GVBuffer method that solves the parameter.
 
−
The attribute's admitted values are:
 
−
* getSystem
 
−
* getService
 
−
* getId
 
−
* getRetCode
 
−
* getObject
 
−
* getProperty
 
−
|-
 
−
| propertyName || optional || This attribute defines the name of the property if the method is getProperty().
 
−
|}
 
−
 
 
−
 
 
−
Might contain the sub-elements:
 
−
* [[Description]]
 

Revision as of 13:19, 12 November 2012

Description

This element defines the statement to be evaluated.

Can contains placeholders that will be replaced at runtime.

GreenVulcano® ESB Configuration

The element statement can be used by: