Difference between revisions of "GetAnagrafica ws bottom-up method"
(→SERVICE SECTION) |
|||
| Line 3: | Line 3: | ||
== SYSTEM SECTION == | == SYSTEM SECTION == | ||
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: |
| − | *DBOoperation-->DataSourceConnection | + | *[[DBOoperation]]-->[[DataSourceConnection]] |
**jndi-name: insert the name of jndi DataSource in this example ds.anagrafica | **jndi-name: insert the name of jndi DataSource in this example ds.anagrafica | ||
*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 | ||
| Line 22: | Line 22: | ||
[[File:4buws.png|thumb|WebService Wizard fourth window]] | [[File:4buws.png|thumb|WebService Wizard fourth window]] | ||
| − | This section show the getAnagrafica service configuration. On the elements | + | This section show the getAnagrafica service configuration. On the elements [[Service]] add a service with name "getAnagrafica" |
Revision as of 12:21, 13 February 2012
We start from a GreenVulcano® ESB service "getAnagrafica" that simply returns the anagrafica presents in table Anagrafica.
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:
- 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
SERVICE SECTION
This section show the getAnagrafica service configuration. On the elements Service add a service with name "getAnagrafica"
