Skip to Content

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

SQL Transactions in XI - limited to 1 insert and 1 update?

I would like to implement the following SQL logic in XI:

Start Transaction (Serializable)

- Select Statement (Header Data)

- Select Statement (Line Item Data)

- Update Statement (Update Processed Flag)

End Transaction

The JDBC Sender Adapter allows SQL transactions but only allows 1 SQL Query statement and 1 SQL Update statement.

I could use BPM to make multiple SQL calls (multiple JDBC Sender Comm Channels) and then map the results together, but then each call would be in a separate transaction.

Is there a way to accomplish this without writing my own JDBC code in a Java Map?

Thanks,

Jesse

Former Member

Helpful Answer

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