[wsas-java-dev] [jira] Updated: (WSAS-682) Data services: Invoking a data service which includes MySQL functions

[Charitha Kankanamge (JIRA)]

     [ http://wso2.org/jira/browse/WSAS-682?page=all ]

Charitha Kankanamge updated WSAS-682:
-------------------------------------

    Attachment: sqlfunctionService.dbs

Attached data service configuration

> Data services: Invoking a data service which includes MySQL functions 
> ----------------------------------------------------------------------
>
>                 Key: WSAS-682
>                 URL: http://wso2.org/jira/browse/WSAS-682
>             Project: WSO2 WSAS
>          Issue Type: Bug
>          Components: data-services
>            Reporter: Charitha Kankanamge
>         Assigned To: sumedha rubasinghe
>            Priority: Critical
>         Attachments: sqlfunctionService.dbs
>
>
> I have a mysql function as follows.
> mysql> delimiter //
> mysql> create function myFunction(p_inparam varchar(20)) returns
>     -> varchar(20)
>     -> begin
>     -> declare output_text varchar(20);
>     -> set output_text = p_inparam;
>     -> return output_text;
>     -> end //
> I couldn't get the expected output if I include a function call in a data service. The data service configuration is attached here with.
> Also, there are no instructions/user docs available for configuring a data service with functions. It will be great if user guide is updated with necessary instructions on how to use functions inside data services.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira