DBOSelect - Revision history

M.deluca: /* {{GVESB}} configuration */

2016-01-25T20:33:53Z

‎{{GVESB}} configuration

G.dimaio at 14:17, 2 January 2015

2015-01-02T14:17:09Z

Anonymous: /* {{GVESB}} configuration */

2012-11-12T12:20:18Z

‎{{GVESB}} configuration

Anonymous: /* {{GVESB}} configuration */

2012-03-30T12:55:14Z

‎{{GVESB}} configuration

Anonymous: /* {{GVESB}} configuration */

2012-03-30T12:46:50Z

‎{{GVESB}} configuration

Anonymous: /* {{GVESB}} configuration */

2012-03-30T12:41:55Z

‎{{GVESB}} configuration

Anonymous at 09:28, 29 March 2012

2012-03-29T09:28:57Z

Anonymous at 07:02, 29 March 2012

2012-03-29T07:02:11Z

Anonymous at 19:38, 28 March 2012

2012-03-28T19:38:47Z

Anonymous at 19:38, 28 March 2012

2012-03-28T19:38:28Z

@@ Line 171: / Line 171: @@
 </RowSet>
 </syntaxhighlight>
 </div>

@@ Line 36: / Line 36: @@
 | output-data || optional || The default is the value of @name-Output.
 |}
 For example:
@@ Line 65: / Line 74: @@
 </syntaxhighlight>
+According to the data present into the DB we obtain as output the following XML (also known as 'standard' RowSet mode):
 <syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
 <RowSet>
@@ Line 95: / Line 103: @@
 </RowSet>
 </syntaxhighlight>
 DBOSelect might contain the following sub-elements:

@@ Line 26: / Line 26: @@
 | name || required || DOSelect name
 |-
-| transformation || optional ||
+| transformation || optional || Transformation to be used for converting internal rowset representation in user desired XML document.
 |-
 | force-mode || required || (caller or db2xml): Force mode of the DBO, can be used in [[DBOBuilder]] whit more heterogeneous [[DBOBuilder#DBO|DBO]]. <br/> Mode:<br/> caller - inherit the mode of the caller<br/> db2xml - data extraction mode

@@ Line 13: / Line 13: @@
 Can be defined, for every statement and field, the FieldFormatter that allows you to force the formatting of the values extracted from the database.
 The following table shows the DBOSelect attributes:
@@ Line 24: / Line 26: @@
 | name || required || DOSelect name
 |-
-| transformation || required ||
+| transformation || optional ||
 |-
-| force-mode || required || (caller|xml2db): Force mode of the DBO, can be used in [[DBOBuilder]] whit more heterogeneous DBO. <br/> Mode:<br/> caller - inherit the mode of the caller<br/> db2xml - data extraction mode
+| force-mode || required || (caller or db2xml): Force mode of the DBO, can be used in [[DBOBuilder]] whit more heterogeneous [[DBOBuilder#DBO|DBO]]. <br/> Mode:<br/> caller - inherit the mode of the caller<br/> db2xml - data extraction mode
 |-
 | jdbc-connection-name || required || DataSource JNDI name. <br/>  Override connection defined in [[DBOBuilder]].
 |-
-| ignore-input || optional || (true|false):   Tell the engine do not use the input data.
+| ignore-input || optional || (true or false): Tells the engine do not use the input data.
 |-
 | output-data || optional || The default is the value of @name-Output.

@@ Line 14: / Line 14: @@
 Can be defined, for every statement and field, the FieldFormatter that allows you to force the formatting of the values extracted from the database.
-Its attributes are:
+The following table shows the DBOSelect attributes:
-* ''type'': dbo
+{|class="gvtable"
-* ''class'': it.greenvulcano.gvesb.datahandling.dbo.DBOSelect
+! Attribute !! Type !! Description
-* ''name''
+|-
-* ''transformation''
+| type || fixed || This attribute must assume the value '''dbo'''
-* ''force-mode'' (caller|xml2db): Force mode of the DBO, can be used in [[DBOBuilder]] whit more heterogeneous DBO. <br/> Mode:<br/> caller - inherit the mode of the caller<br/> db2xml - data extraction mode
+|-
-* ''jdbc-connection-name'':  DataSource JNDI name. <br/>  Override connection defined in [[DBOBuilder]].
+| class || fixed || This attribute must assume the value '''it.greenvulcano.gvesb.datahandling.dbo.DBOSelect'''
-* ''ignore-input'' (true|false):   Tell the engine do not use the input data.
+|-
-* ''output-data'':  The default is the value of @name-Output.
+| name || required || DOSelect name
 For example:
 <syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
-<DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"   jdbc-connection-name="ds.gv_test"
+<DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"
-                        name="SearchPerson"   type="dbobuilder">
+            jdbc-connection-name="ds.gv_test"
        <DHVariables>
               <DHVariable name="decimal-separator" value="."/>

@@ Line 5: / Line 5: @@
 =={{GVESB}} configuration==
 [[File:DBOSelect.jpg|thumb|DBOSelect with VulCon]]
-DBOSelect might contain the following sub-elements:
-* [[Description]]
+DBOSelect allows you to perform a select on database.
-* [[DHVariables]]
-* [[FieldFormatters]]
+The result of the select(s) is an XML document in internal format that can then be transformed into a useful document for the client.
-* [[statement]]
 Its attributes are:
@@ Line 23: / Line 26: @@
 For example:
 <syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
- <DBOSelect class="it.greenvulcano.gvesb.datahandling.dbo.DBOSelect"
+<DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"   jdbc-connection-name="ds.gv_test"
-          name="SearchPerson" transformation="SearchPerson" type="dbo">
+                        name="SearchPerson"   type="dbobuilder">
-     <statement id="1" keys="1,2,3" type="select">select p.NAME, p.BIRTHDATE, c.NAME, cc.CNUMBER, cc.CREDIT, cc.ENABLED
+      <DHVariables>
-                                    from PERSON p, CITY c, CREDIT_CARD cc
+             <DHVariable name="decimal-separator" value="."/>
-                                    where p.ID_CITY = c.ID and p.ID = cc.ID_OWNER</statement>
+             <DHVariable name="grouping-separator" value=","/>
- </DBOSelect>
+             <DHVariable name="format" value="#0.00"/>
 </syntaxhighlight>

@@ Line 12: / Line 12: @@
 Its attributes are:
-** ''type'': dbo
+* ''type'': dbo
-** ''class'': it.greenvulcano.gvesb.datahandling.dbo.DBOSelect
+* ''class'': it.greenvulcano.gvesb.datahandling.dbo.DBOSelect
-** ''name''
+* ''name''
-** ''transformation''
+* ''transformation''
-** ''force-mode'' (caller|xml2db): Force mode of the DBO, can be used in DBOBuilder whit more heterogeneous DBO. <br/> Mode:<br/> caller - inherit the mode of the caller<br/> db2xml - data extraction mode
+* ''force-mode'' (caller|xml2db): Force mode of the DBO, can be used in DBOBuilder whit more heterogeneous DBO. <br/> Mode:<br/> caller - inherit the mode of the caller<br/> db2xml - data extraction mode
-** ''jdbc-connection-name'':  DataSource JNDI name. <br/>  Override connection defined in DBOBuilder.
+* ''jdbc-connection-name'':  DataSource JNDI name. <br/>  Override connection defined in DBOBuilder.
-** ''ignore-input'' (true|false):   Tell the engine do not use the input data.
+* ''ignore-input'' (true|false):   Tell the engine do not use the input data.
-** ''output-data'':  The default is the value of @name-Output.
+* ''output-data'':  The default is the value of @name-Output.
 For example:

@@ Line 1: / Line 1: @@
 ==Description==
-[[File:DBOSelect.jpg|thumb|DBOSelect with VulCon]]
 The DBOSelect element represents the DBO optimized for select operations.