|  |   | 
| Line 1: | Line 1: | 
|  | ==Description== |  | ==Description== | 
|  |  |  |  | 
| − | The [[Statement]] elementcontains 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 elementcontains 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 beof 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]] |  |