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

From GreenVulcano Wiki
Jump to: navigation, search
(Created page with "We start from a {{GVESB}} service "getAnagrafica" that simply returns the anagrafica presents in table Anagrafica. thumb|WebService Wizard first window")
 
Line 1: Line 1:
 
We start from a {{GVESB}} service "getAnagrafica" that simply returns the anagrafica presents in table Anagrafica.
 
We start from a {{GVESB}} service "getAnagrafica" that simply returns the anagrafica presents in table Anagrafica.
 
[[File:1buws.png|thumb|WebService Wizard first window]]
 
[[File:1buws.png|thumb|WebService Wizard first window]]
 +
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
 +
The system section has been configured

Revision as of 11:06, 13 February 2012

We start from a GreenVulcano® ESB service "getAnagrafica" that simply returns the anagrafica presents in table Anagrafica.

WebService Wizard first window

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

The system section has been configured