Skip to Content
avatar image
Former Member

JDBC

Could someone tell me is this possible...

I have a scenario where by I receive multiple messages in XI probably an Integration Process.

Then I want to send these messages in a certain order to the Database using the JDBC adapter.

But what I want to happen is if something goes wrong from the Database side and we get some sort or error with one of the messages then all previous messages within that Integration Process will automatically get rolled back.

So essentially if one of the messages fail in my IP then the database is returned to its original state before the access from XI.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 02, 2007 at 08:17 PM

    Hey

    have a stored proc on DB side which will be called from a exception branch in BPM(in case of any errors),this stored proc will do the roll back for you.

    Thanx

    Aamir

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 03, 2007 at 05:37 AM

    Hi

    You definitely need a Stored procedure.It cannot be done otherwise.Just code your stored procedure according to the requirements, the scenario will become a normal JDBC Scenario.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 03, 2007 at 08:47 AM

    Interesting.... We have a similar scenario and I was looking at this:

    http://help.sap.com/saphelp_nw04s/helpdata/en/45/058023846b2460e10000000a1553f7/frameset.htm

    Could this not be a possibility? Anyone?

    Add comment
    10|10000 characters needed characters exceeded