Multiple Inserts

[Former Member]

Hi Guys,

I am new to XI, I have a query.

I have a interface which inserts data in SQL server. I am entering data in 3 different tables at a time.

When any error occurs insert in all 3 tables is rolled back. I want to avoid this, I would like to continue inserting data in one of the 3 tables even if error occured in either of the 2.

Is this possible??

Thanks in advance...

[Former Member · Accepted solution]

Hi Anand,

in the communication channel it is not possible.

The workaround is to call the adapter n-times; for each table separate.

Regards Mario

[Former Member]

Hi ,

You can do this by calling stored procedure in your JDBC adapter.

We can use stored procedure to insert the data into two tables.

http://help.sap.com/saphelp_nw04/helpdata/en/e2/cb610b230c9c4cb4b800989196b63a/frameset.htm

Please use this structure while calling Store procedure from communication channel.

Nanda