Web services: BEGIN TRANSACTION & COMMIT

former_SQLA_member326303 — Thu, 28 Jan 2016 07:11:17 GMT

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

Re: Web services: BEGIN TRANSACTION & COMMIT

MarkCulp — Thu, 28 Jan 2016 08:05:39 GMT

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.

Question Re: Web services: BEGIN TRANSACTION & COMMIT in Technology Q&A

Web services: BEGIN TRANSACTION & COMMIT

Re: Web services: BEGIN TRANSACTION & COMMIT