[ http://wso2.org/jira/browse/WSAS-682?page=all ]
sumedha rubasinghe resolved WSAS-682.
-------------------------------------
Resolution: Invalid
The SQL should be entered like the following :
select myFunction('WSAS') as ABC
Then this ABC should be used in the result to output mapping section.
> 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
_______________________________________________
Wsas-java-dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/wsas-java-dev
