WSO2 EI gives us another feature that allows us to create web services for managing tables in our database. This is an SOAP data service with operations for inserting, deleting, updating, or selecting rows in one or several tables. This can only be performed using the Management Console, under Services | Data Service | Generate. You just have to follow these steps:
- Select a data source and a database name:
- Choose the table or tables you want to manage with the data service:
- Choose whether you want a single data service for all the tables or a data service per table. Enter a namespace for the data service:
- Then the data service will be created, as follows:
You will see the new data service in the service list:
The operations generated are as follows:
You may have noted that there are two select operations. One of them, called select_all...