GetAnagrafica ws bottom-up method

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

WebService Wizard first window

WebService Wizard second window

WebService Wizard third window

The system section has been configured