SQL service engine allows SQL DDL (Data Definition Language), SQL DML (Data
Manipulation Language), and stored procedures to be executed against a database.
This, therefore, allows different scenarios to be executed against the database. For
example, obtaining a customer's address or the number of outstanding invoices a
customer may have.
Within NetBeans, the SQL module is used to interact with the SQL Service Engine.
The SQL module project consists of three artifacts as follows:
configuration xml file (connectivityInfo.xml)
one or more SQL files containing distinct SQL statements
WSDL file describing the SQL operations.
??? ??? ???
Service Engines
[ 40 ]
SQL Modules are created by choosing File | New Project and then selecting the
SQL Module option from within the SOA projects category.
Within a SQL Module, there is a configuration file called connectivityInfo.xml
which contains connection details for the database. This can either be specified as a
driver connection or as a JNDI name for a data source.
Each SQL statement that is to be presented to client applications as a new operation
must be stored in a separate SQL file.
Pages:
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59