[ http://wso2.org/jira/browse/WSAS-626?page=all ]
sumedha rubasinghe resolved WSAS-626.
-------------------------------------
Resolution: Fixed
> Issue with sql insert or update in data services
> ------------------------------------------------
>
> Key: WSAS-626
> URL: http://wso2.org/jira/browse/WSAS-626
> Project: WSO2 WSAS
> Issue Type: Bug
> Components: data-services
> Affects Versions: 2.1
> Environment: winxp, jdk15, mysql5
> Reporter: Charitha Kankanamge
> Assigned To: sumedha rubasinghe
> Priority: Critical
> Fix For: 2.2
>
> Attachments: EmployeeMySQLservice.dbs
>
>
> I couldn't get sql insert or update worked using WSAS data services. I tried
> in the last few days with no luck. Hence, I'm reporting this issue for some
> developer to try it out and check whether insert/update works in your
> environment.
> Steps to reproduce:
> ===========
> 1. Create a data service with a query which has insert or update statement
> (Note that I tested with mysql 5)
> i.e:-
> INSERT INTO employee(id, name, address) VALUES(12, 'Chamikara', 'Piliyandala')
> 2. Save the query
> 3. Add an operation by selecting the above query
> 4. save the data service
> 5. Try the data service or invoke the operation using REST
> When invoking the insert opeartion i did not get any results back. The
> strange thing was there were no exceptions/errors. The table was not updated
> after executing the query through wsas data service.
> A sample mysql5 data service configuration is attached here with.
--
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
