Web services: BEGIN TRANSACTION & COMMIT

[former_SQLA_member326303]

Let ASA-12 database with web services (-xs ...).
Is it possible within a single session, start a transaction in one http(s)-request and finish/COMMIT in another http(s)-request? For example:

request1 to serviceA: ...update ttt set fff=null ...

...

requestN to serviceB: ...COMMIT ...

Or "if the web service finishes normally, by definition the COMMIT will have been executed" © Breck Carter, i.e.:

request1 to serviceA: ...update ttt set fff=null ...  ==> (auto)COMMIT

[MarkCulp · Accepted solution]

Breck is correct: at the end of each web service request the connection will either COMMIT or ROLLBACK depending on the state of the connection - the connection will ROLLBACK if an error state exists (e.g. an exception was raised) otherwise will COMMIT.

So there is no method to start a transaction in one http request and COMMIT it in another http request.