data service

Introduction

Data Service configuration Language (http://wso2.org/wiki/display/wsf/Data+Services+and+Resources)  allows you to call a query using results returned from prior. (i.e. nested query support). What follows is a small example demonstrating how to use nested query feature.

Introduction

MySQL 5 stored procedures support INOUT type variables. This type of variable carries a value into the procedure & bring back a value after execution is complete. Data services support exposing stored procedures which use INOUT type parameters. 

This tutorial explains how to use INOUT type parameters in your Data Service.

Step 1: Creating & Populating sample database

DROP DATABASE IF EXISTS DATASERVICE_SAMPLE;
CREATE DATABASE DATASERVICE_SAMPLE;
GRANT ALL ON DATASERVICE_SAMPLE.* TO 'dsuser'@'localhost' IDENTIFIED BY 'user123';

USE DATASERVICE_SAMPLE;

DROP TABLE IF EXISTS  Salary;

CREATE TABLE Salary(
        employeeNumber INTEGER,
        salary DOUBLE,
        lastRevisedDate DATE
);

INSERT into Salary (employeeNumber,salary,lastRevisedDate) values (1002,13000,'2007/11/30');