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

From GreenVulcano Wiki
Jump to: navigation, search
(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 servce add a Service with name "getAnagrafica"
+
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
WebService Wizard first window
WebService Wizard second window
WebService Wizard third window

The system section has been configured

SERVICE SECTION

WebService Wizard fourth window

This section show the getAnagrafica service configuration. On the elements Service add a service with name "getAnagrafica"