Skip to Content
author's profile photo Former Member
Former Member

JDBC Rollback

Hi Gurus!

I have two doubt:

I have a process that with a Sender JDBC I do SELECTs and UPDATE to a DATABASE. Then when I select a list of entries, these entries are flagged to not be processed again.

1. If there is a problem when I process these entries, by example an error in a Message Mapping, could the changes on the database be rolledback? If could be, is done by XI in a standard way.

2. I have the same doubt to Receiver JDBC, I update an entry on a table, this call to the JDBC is on a BPM, when we get the response the BPM continues running, if there is an error on the BPM, could this entry be rolled back?

Thanks and regards,

Manuel.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2009 at 02:32 PM

    A better alternative would be to use a Store Procedure with Select and Update statements. This will eliminate data inconsistency.

    In case of any Message mapping errors, use BPM to reset the flags for your original Resultset. (like what Krish suggested)

    Hope this helps.

    Ravi.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2009 at 10:26 AM

    Hi,

    By reality it is not possible to rollback as the adapter is the one which performs the selection and updation . It wont check whether the mapping is successful or not.

    But you can design in such a way that if there is a mapping error, you can create one more jdbc channel to select the records and update the Flag back .

    With BPM, you can check whether the mapping got successful and depending upon that can do the process.

    This applies on the receiver side also.

    Regards

    Krish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2009 at 03:16 PM

    Hi Manuel,

    Please take a look at this blogs and threads:

    /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

    /people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

    jdbc-sender---different-number-of-records-selected

    jdbc-sender-adapter-consistency-and-transaction-le

    Regards,

    ---Satish

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.