While executing BatchInsert adapter service, first I kept the transaction type as ‘Local’ and then I gave two set of inputs, one with correct data format while the other with wrong format.
Since it is local so the error was thrown and no rows got inserted in the db.
Then I changed the transaction type as ‘No_Transaction’ then also it worked the same way.
Then what is the difference between No and Local transactions if they are acting same??
And also in what scenarios we use startTransaction and commitTransaction builtin services as without them also the transaction is autocommitted.
Please help me with the same.