Data Service insert problem

Hi, Could you please post your *.dbs so that we can check whether there are any issues? Regards Charitha

Hello Charitha, Thanks for your reply. I use wsas 3.1.3, my db is MySQL. This is my dbs: <?xml version="1.0" encoding="UTF-8"?> <data name="MySQL">     <config id="mysql">         <property name="org.wso2.ws.dataservice.driver">com.mysql.jdbc.Driver</property>         <property name="org.wso2.ws.dataservice.protocol">jdbc:mysql://127.0.0.1:3306/test</property>         <property name="org.wso2.ws.dataservice.user">root</property>         <property name="org.wso2.ws.dataservice.password">123456</property>         <property name="org.wso2.ws.dataservice.minpoolsize"/>         <property name="org.wso2.ws.dataservice.maxpoolsize"/>         <property name="org.wso2.ws.dataservice.autocommit"/>     </config>     <query id="Test" useConfig="mysql">         <sql>Insert into tmp values(?,?,?)</sql>         <result element="Results" rowName="Result" defaultNamespace=""/>         <param name="id" sqlType="INTEGER"/>         <param name="name" sqlType="STRING"/>         <param name="value" sqlType="STRING"/>     </query>     <operation name="t">         <call-query href="Test">             <with-param name="id" query-param="id"/>             <with-param name="name" query-param="name"/>             <with-param name="value" query-param="value"/>         </call-query>     </operation> </data>    

Hi again, I've tested similar data service in Data Service Application Server 2.2.0, unfortunately this problem existed there too. But I do not find any solution or workaround. Thanks

Hi, did you get a soultion until now? The problem is, that you define a <result>-element: <result element="Results" rowName="Result" defaultNamespace=""/> So the system assumes, that you have to return values and performs a 'executeQuery' So, simply omit the 'result'-element. Best regards Dieter

    I want to capture return value from insert/update query. Please let me know, how can I do this. I have following dbs, which is inserting properly. But how will I know, if insert/update is success.   <data name="TestDS">    <config id="testId">       <property name="org.wso2.ws.dataservice.driver">org.postgresql.Driver</property>       <property name="org.wso2.ws.dataservice.protocol">jdbc:postgresql://127.0.0.1:5432/</property>       <property name="org.wso2.ws.dataservice.user">postgres</property>       <property name="org.wso2.ws.dataservice.password">root</property>    </config>    <query id="testQuery2" useConfig="testId">       <sql>insert into employee values(:id,:name,:address)</sql>         <param name="id" sqlType="STRING" ordinal="1" /> <param name="name" sqlType="STRING" ordinal="2" /> <param name="address" sqlType="STRING" ordinal="3" />    </query>        <operation name="getEmployees2">       <call-query href="testQuery2" />    </operation>