- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Mary,
by my opinion xtk.session.Write() is final statement (after execution an automatically COMMIT is done).
It is best option to open one ticket towards Adobe Support to clarify usage of rollback().
You might try to create a procedure on DB level (basic Oracle example below) and then adapt your web service to invoke procedure and then everything will be done by your database.
CREATE PROCEDURE foo (x NUMBER) IS
BEGIN
SAVEPOINT update_bar;
-- Do some inserts here.
INSERT INTO bar VALUES (x);
-- Sometimes there might be an error.
IF x = 3 THEN
RAISE_APPLICATION_ERROR(-20000, 'Wooops...');
END IF;
EXCEPTION
WHEN OTHERS THEN
-- Rollback everything which was made after `SAVEPOINT update_bar`
ROLLBACK TO update_bar;
RAISE;
END foo;
Regards,
Milan