Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Transaction Handling - JDBC Receiver Adapter - Multiple SP Calls

Hello,

I have the following scenario:

I send an XML-SQL structure with multiple statment elements (each of them calling a different stored procedure). A stored procedure raises an error back to the JDBC Receiver Adapter in case of error.

Is it possible to have transaction handling in the JDBC Receiver to ensure:

- Commit only after ALL stored procedures where succesful (no error risen during calls)

- Rollback of ALL already called stored procedures in case an error has been risen

How can I implement these requirements in the JDBC Receiver Adapter?

Former Member
Not what you were looking for? View more on this topic or Ask a question