Home > Blockchain >  How to commit a transaction after insert on WSO2 Data Services
How to commit a transaction after insert on WSO2 Data Services

Time:03-04

I have created a query to insert data into an Oracle Database Table (12c), and I have also created an operation on WSO2 ESB DSS to expose this query via WebServices. I am getting back the following response from my WSO2 call:

{
    "REQUEST_STATUS": "SUCCESSFUL"
}

However, when I look in the database, my data has not been inserted. How do I do a commit after the insert so that the data is written to the database?

CodePudding user response:

Please use this property in the configuration for the data service.

<property name="autoCommit">true</property>
  • Related