SQL service engine allows SQL statements to be executed against relational databases and allows the results of SQL statements to be returned to the client application or other Service Engines for further processing.
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: