[ http://wso2.org/jira/browse/WSAS-626?page=all ]
Charitha Kankanamge closed WSAS-626. ------------------------------------ Verified in WSAS-2.2 latest builds and closed the bug. > 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
