|
|
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]] | |