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 shows 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:

• DBOperations-->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

SERVICE SECTION

This section shows the getAnagrafica service configuration. To configure the service performs the following steps:

1. On the elements Service add a service with name "getAnagrafica".
2. On the "request" node set db-call as operation
3. As output-service set a xsl trasformation to transform the data as Web Service XSD expected.

To create a new trasformation go in section GvDataTrasformation and execute the following steps:

1. On section Trasformation add new xsl trasformation
2. On the opened page set:
   1. trasformation name:"getAnagrafica"
   2. Data source:Default
   3. xsd input: choose database.xsd
   4. root xsd input: RowSet (is the root element that return the query)
   5. xsd output: anagrafica.xsd (the schema that the Web Service expected)
   6. root XSD output: the root element of the xsd.

To create the xsl trasformation between the file Database.xsd and anagrafica.xsd you can use XML Data mapper tool

WebService Wizard fourth window

WebService Wizard five window

Xml data mapper