Difference between revisions of "Retriever Config"
(→TableRetriever) |
(→TableRetriever) |
||
| Line 29: | Line 29: | ||
===TableRetriever=== | ===TableRetriever=== | ||
| − | This element allows you to define helper running SQL select and return the result as an XML string in following form: | + | This element allows you to define helper running SQL select and return the result as an XML string in the following form: |
<syntaxhighlight lang="XML"> | <syntaxhighlight lang="XML"> | ||
<?xml version="1.0" encoding="UTF-8"?> | <?xml version="1.0" encoding="UTF-8"?> | ||
| Line 53: | Line 53: | ||
</RowSet> | </RowSet> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | + | ||
| + | The statement to be executed might contain metadata resolved at runtime. | ||
| + | |||
| + | The following table shows TableRetriever element's attributes: | ||
{|class="gvtable" | {|class="gvtable" | ||
! Attribute !! Type !! Description | ! Attribute !! Type !! Description | ||
| Line 61: | Line 64: | ||
| class || fixed || it.greenvulcano.gvesb.datahandling.utils.TableRetriever | | class || fixed || it.greenvulcano.gvesb.datahandling.utils.TableRetriever | ||
|} | |} | ||
| − | + | ||
| + | Might contain the sub-elements: | ||
* [[Description]] | * [[Description]] | ||
* [[DataRetriever]] | * [[DataRetriever]] | ||
Revision as of 20:45, 30 March 2012
Contents
Description
The RetrieverConfig element allows you to define helper for use in DataHandler data transformations.
GreenVulcano® ESB Configuration
This element does not have attributes but accepts the following children:
GenericRetriever
This element allows you to define helper running SQL select and return the first field of the first selected record as string. It has the parameters:
| Attribute | Type | Description |
|---|---|---|
| type | fixed | retriever (unmodifiable) |
| class | fixed | it.greenvulcano.gvesb.datahandling.utils.GenericRetriever |
and the subelements:
TableRetriever
This element allows you to define helper running SQL select and return the result as an XML string in the following form:
<?xml version="1.0" encoding="UTF-8"?>
<RowSet>
<data>
<row>
<col>value1</col>
<col>value2</col>
<col>value3</col>
</row>
<row>
<col>value4</col>
<col>value5</col>
<col>value6</col>
</row>
..
<row>
<col>valuex</col>
<col>valuey</col>
<col>valuez</col>
</row>
</data>
</RowSet>
The statement to be executed might contain metadata resolved at runtime.
The following table shows TableRetriever element's attributes:
| Attribute | Type | Description |
|---|---|---|
| type | fixed | retriever (unmodifiable) |
| class | fixed | it.greenvulcano.gvesb.datahandling.utils.TableRetriever |
Might contain the sub-elements:
JavaScriptRetriever
It has the parameters:
| Attribute | Type | Description |
|---|---|---|
| type | fixed | retriever (unmodifiable) |
| class | fixed | it.greenvulcano.gvesb.datahandling.utils.JavaScriptRetriever |
and the subelements:
