Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 12, 2006 at 10:25 PM

    hi,

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

    u could also use Java proxies instead of java mappings. Much more straight forward.

    cheers,

    naveen

    Add comment
    10|10000 characters needed characters exceeded