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)
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?