OXF will by default do what you expect, which is to do a commit at the end of processing a page. This means that by default your three updates will be part of the same transaction and your updates will be rolled back if an error occurs before the page request completes.
-Erik
Tony Tay wrote:
> hi, > > How do i get OXF SQL processor to do a commit only when all tables > were updated successfully, otherwise, it should rollback.
> For example, there are 3 tables to update and only 2 out of the 3 > were successfully updated. In this situation, a Rollback should > happen to the other 2 previously updated tables. It will only do a > commit when all 3 tables were successfully updated. > > Regards, > Tony _______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
