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: