Skip to Content

JDBC - Rollback

Dear Friends,

I hope you are all doing great! I have some issues with the JDBC Adapter Rollback operations. If anyone had any solutions, please share the same. I'll really appreciate it.

Issue:

For example, let say I'm framing/generating 10 INSERT SQL Statements and sending it to Legacy system. Consider first 5 sql statements went thru successfully and the 6th SQL statement has the Duplicate key and it got failed in the adapter engine, which was correct as I expected.

Since it got failed, the data which got inserted has to be rollbacked, is it possible in communication channel settings?

raj.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 01, 2008 at 05:01 PM

    Hi,

    I don't think the previous inserted data can be rollacked by handling through communication channel monitoring. You need to write a procedure to achieve this functionality.

    Thanks

    amit

    Add comment
    10|10000 characters needed characters exceeded

    • Bhavesh,

      It doesn't seems to be working. Now I'm not getting any errors in the adapter engine. But the data is not consitent.

      If I issue the following statements

      INSERT 'ABC'

      INSERT '1234' --> Duplicate Record

      DELETE 'ABC'

      then in adapter Engine is showing success, it has to show error and it must revert back the inserted 'ABC' right, but it's not!

      Am I doing/missing something wrong?

      raj.