Using the example scenarios above, we would
have two SQL files with contents shown in the following table:
customer_address.sql select address1, address2, zip from
customer where customer_id=?
outstanding_invoices.sql select count(*) from invoices where
customer_id=? and isPayed=??™n??™
Chapter 3
[ 41 ]
In order for other JBI components to be able to access our SQL module, we must
have a WSDL file which describes the operations we have defined (customer_
address.sql and outstanding_invoices.sql). NetBeans will generate this file for
us when we select the Generate WSDL option from right-clicking on the project in
the Projects explorer.
SQL Service assembly units cannot be executed directly from within the JBI
container. To execute the SQL Service Unit, it needs to be added as part of
a composite application. This is then called a Service Assembly. Composite
applications are further discussed in Chapter 4.
Service Assembly: a deployable component (jar file) that consists of a
collection of Service Units.
IEP Service Engine
The Intelligent Event Processing service engine allows data to be read from an input
source and then processed into a format that can be used for a variety of different
purposes such as reporting or business intelligence information.
Service Engines
[ 42 ]
For example, an IEP project could be created that takes sales information from a
retail system, collects all information made over the last hour, and then outputs it to
a database table for reporting purposes.
Pages:
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60