Skip to Content
Former Member
Nov 07, 2007 at 09:18 AM

Transaction Handling - JDBC Receiver Adapter - Multiple SP Calls



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?