Difference between revisions of "DBOThreadSelect"

From GreenVulcano Wiki
Jump to: navigation, search
({{GVESB}} configuration)
 
(4 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
The DBOThreadSelect element represents the DBO optimized for select operations.
 
The DBOThreadSelect element represents the DBO optimized for select operations.
  
Every statement is execute in a separate thread, then the results are merged before making the transformation.
+
Every statement is execute in a separated thread, then the results are merged before making the transformation.
  
 
=={{GVESB}} configuration==
 
=={{GVESB}} configuration==
 +
 +
The DBOThreadSelect element allows to perfom select operations from the DB, each one into a separated thread.
 +
 +
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.
 +
 +
Can be executed more select statements, each one associated to an id, with the possibility of aggregating, using keys, the extracted data.
 +
 +
Can be defined, for every statement and field, the FieldFormatter that allows you to force the formatting of the values ​​extracted from the database.
 +
 +
It is used by [[DBOBuilder]].
 +
 +
The following table shows the DBOThreadSelect attributes:
 +
{|class="gvtable"
 +
! Attribute !! Type !! Description
 +
|-
 +
| type || fixed || This attribute must assume the value '''dbo'''
 +
|-
 +
| class || fixed || This attribute must assume the value '''it.greenvulcano.gvesb.datahandling.dbo.DBOThreadSelect'''
 +
|-
 +
| name || required || DOThreadSelect name
 +
|-
 +
| transformation || optional || Transformation to be used for converting internal rowset representation in user desired XML document.
 +
|-
 +
| force-mode || optional || (caller or db2xml): Force mode of the DBO, can be used in DBOBuilder whit more heterogeneous [[DBOBuilder#DBO|DBO]]. <br/> Mode:
 +
* caller - inherits the mode of the caller
 +
* db2xml - data extraction mode
 +
|-
 +
| jdbc-connection-name || optional || DataSource JNDI name. <br/>  Overrides the connection defined in [[DBOBuilder]].
 +
|-
 +
| 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.
 +
|}
  
 
DBOThreadSelect might contain the following sub-elements:
 
DBOThreadSelect might contain the following sub-elements:
Line 12: Line 45:
 
* [[FieldFormatters]]
 
* [[FieldFormatters]]
 
* [[statement]]
 
* [[statement]]
 
 
Its attributes are:
 
* ''type'': dbo
 
* ''class'': it.greenvulcano.gvesb.datahandling.dbo.DBOThreadSelect
 
* ''name''
 
* ''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
 
* ''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.
 
* ''output-data'':  The default is the value of @name-Output.
 

Latest revision as of 12:21, 12 November 2012

Description

The DBOThreadSelect element represents the DBO optimized for select operations.

Every statement is execute in a separated thread, then the results are merged before making the transformation.

GreenVulcano® ESB configuration

The DBOThreadSelect element allows to perfom select operations from the DB, each one into a separated thread.

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.

Can be executed more select statements, each one associated to an id, with the possibility of aggregating, using keys, the extracted data.

Can be defined, for every statement and field, the FieldFormatter that allows you to force the formatting of the values ​​extracted from the database.

It is used by DBOBuilder.

The following table shows the DBOThreadSelect attributes:

Attribute Type Description
type fixed This attribute must assume the value dbo
class fixed This attribute must assume the value it.greenvulcano.gvesb.datahandling.dbo.DBOThreadSelect
name required DOThreadSelect name
transformation optional Transformation to be used for converting internal rowset representation in user desired XML document.
force-mode optional (caller or db2xml): Force mode of the DBO, can be used in DBOBuilder whit more heterogeneous DBO.
Mode:
  • caller - inherits the mode of the caller
  • db2xml - data extraction mode
jdbc-connection-name optional DataSource JNDI name.
Overrides the connection defined in DBOBuilder.
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.

DBOThreadSelect might contain the following sub-elements: