rollback OR commit selected operations only


  • In a transaction block for example i have 5 insert statements:


    Insert A --Should be commited

    Insert B

    Insert C--Should be commited

    Insert D

    Insert E


    Now let's suppose, statement E got failed, and while rolling back the whole bunch of statements, I want statement A and C to be commit ed. Is it possible?


    06 Maret 2012 5:09


  • Hello,

    No, that's not possible in this way. You can commit every changes done within a transaction or rollback everything, bit you can't commit particular operations. In case of a rollback you could only redo this operations, but then you could do them already outside the transaction instead of within it.

    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing

    • Ditandai sebagai Jawaban oleh KJian_ 12 Maret 2012 6:37
    06 Maret 2012 5:55