examples
package: Using SQL services
SQL services are special services that execute SQL statements.
Under the sqlServices.sql
code directory in the examples
package are example SQL services
that demonstrate how to perform simple and batch SQL operations in Gloop. To show how SQL services work with
regular services, some sample services are provided under sqlServices.invoke
, which invoke the provided
SQL services.
Related articles
Please see the following articles for more information:
Try it!
In the Navigator, expand the examples
package and navigate to the
code
folder, then expand the sqlServices
package. This package contains
files and directories as shown below:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
|
BLOB and CLOB usage
Services that demonstrate BLOB and CLOB usage (in HSQL) are also included. You'll be
able to tell which services these are as they have a a AdditionalData
suffix on their names. Different database
servers may handle BLOBS and CLOBS differently, so please refer to your chosen database server's documentation on
how it handles BLOBs and CLOBs.
Open the services under sqlServices.sql
to see how the SQL services are defined in order to perform
CRUD operations against a database. Open and run the services under
sqlServices.invoke
to see how regular services can invoke Gloop SQL services to perform database operations.