Difference between revisions of "GetAnagrafica ws bottom-up method"

From GreenVulcano Wiki
Jump to: navigation, search
Line 6: Line 6:
 
*Statement
 
*Statement
 
**StatementValue: in this field insert the following query "select cognome,nome,citta from anagrafica"
 
**StatementValue: in this field insert the following query "select cognome,nome,citta from anagrafica"
*ResultSet--QueryFormatter
+
*ResultSet-->QueryFormatter
 
**type: choose base_formatter
 
**type: choose base_formatter
 
**structure: ONLY_DATA, remember if you don't want also metadata form query select for filed structure the value ONLY_DATA
 
**structure: ONLY_DATA, remember if you don't want also metadata form query select for filed structure the value ONLY_DATA

Revision as of 11:15, 13 February 2012

We start from a GreenVulcano® ESB service "getAnagrafica" that simply returns the anagrafica presents in table Anagrafica. The first image show how create an operation system section. In the tag system define a new Channel "CH_DB" and add a db-call operation, in db-call operation set the parameters for the Element DBOoperation, Statement and ResultSet:

  • DBOoperation-->DataSourceConnection
    • jndi-name: insert the name of jndi DataSource in this example ds.anagrafica
  • Statement
    • StatementValue: in this field insert the following query "select cognome,nome,citta from anagrafica"
  • ResultSet-->QueryFormatter
    • type: choose base_formatter
    • structure: ONLY_DATA, remember if you don't want also metadata form query select for filed structure the value ONLY_DATA
WebService Wizard first window
WebService Wizard second window
WebService Wizard third window

The system section has been configured