Difference between revisions of "GetAnagrafica ws bottom-up method"
| 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. | ||
| − | |||
| − | |||
| − | |||
The first image show how create an operation system section. | 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: | 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: | ||
| Line 12: | Line 9: | ||
**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 | ||
| + | == Example == | ||
| + | {| class="gvtable" | ||
| + | |- | ||
| + | !first web service screen shot | ||
| + | !second web service screen shot | ||
| + | !third web service screen shot | ||
| + | ! | ||
| + | |- | ||
| + | | [[File:1buws.png|thumb|WebService Wizard first window]] | ||
| + | | [[File:2buws.png|thumb|WebService Wizard second window]] | ||
| + | | [[File:3buws.png|thumb|WebService Wizard third window]] | ||
| + | |} | ||
The system section has been configured | The system section has been configured | ||
Revision as of 11:13, 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
Example
| first web service screen shot | second web service screen shot | third web service screen shot | |
|---|---|---|---|
The system section has been configured
