topic Complex Commit sap table & external Oracle DB in Application Development and Automation Discussions

Complex Commit sap table & external Oracle DB

Former Member — Wed, 13 Apr 2011 13:49:33 GMT

Hi everone,

I need to executes 2 commits.

There are dependencies between both commits if one them failed i need to do rollback to sap table & external DB.

the commits are:

1) First fm "bapi_transaction_commit" -> update sap table .

2) Second Class cl_sql_connection method commit -> update external Oracle DB

I'm afarid of the situation that first step will succeed the second will not succeed.

How can i solve this problem ?

naimesh_patel — Thu, 14 Apr 2011 14:52:32 GMT

In your current design, you may have to physically rollback the changes by restoring the old impression.

Is it possible to change the sequence of the commits? You would have better control on updating the SAP DB table.

Regards,

Naimesh Patel

Former Member — Thu, 14 Apr 2011 15:06:32 GMT

Even if you change the order or try to back out the changes, you can still run into problems.

Please Google "two phase commit".

Rob