RDBMS

Follow the instructions below to create a data service using a relational database as the data source. We take MySQL (http://dev.mysql.com/downloads) as the example database here.

First, copy the JDBC driver to:

DSS_HOME/repository/components/lib directory
DSS_HOME/repository/components/dropins

For example, cp mysql-connector-java-5.XX-bin.jar /home/user/wso2ds/wso2-dataservices-XX/repository/components/lib.

1. Log on to the Data Services Server Management Console.

2. Click the Main tab and select the Create link under Data Services.

3. The Create Data Service page appears. Fill in the fields and click Next. The Data Service name is mandatory.

Info:
For more information on Advanced Configurations in creating data services, refer to the Transaction Handling section.

4. The Data Sources page appears. Click on the Add New Data Source link and add your Data Source details. Then click Save.

For a RDBMS data source, select the data source type as RDBMS. We use a MySQL database as an example.

Note:

Before saving, you can click on the 'Test Connection' button. If the database connection is successful, you will get the following message:

5. After saving, the added data source page appears. You can edit or delete the Data Source. To proceed click Next.

6. The Queries page appears.

Initially your service does not include any queries. Click on 'Add New Query' to add a new query, input/output mappings, events etc. to your Data Service. Enter query details using which values will be extracted. Specify how the SQL response is mapped to output XML.

Example 1:

Query ID : customersInBostonSQL

SQL Statement : select *, from Customers where city = 'Boston' and country ='USA'

Example 2:

Query ID : customerAddressSQL

SQL Statement : select *, from Customers where contactLastName = ? and contactFirstName = ?

The following query needs two parameters for execution. The Input Mapping section is used to specify these input parameters.

For information on adding validations to your input mappings in the query, refer to section Input Validators.

7. Once a new query is added, it will be listed as follows:

You have added one query to your data service configuration.

You can edit or delete your query. To continue, click Next.

8. The Operations page appears. Click the Add new operation link to create an operation. Select a query to be executed when this operation is called.

Click Save once done. For example,

9. The operation will be listed in the operations page. You can edit or delete your operation. To continue click Next.

10. The Resources page appears. Click Add new resource and give your resource details. Click Save once done. For example,

11. The resource will be listed in the Resources page. You can edit or delete your resource.

The Data Service configuration is done. Click Finish.

12. You will be navigated to the Deployed Services page.

From here, you can manage your service.