The forum will be down for maintenance at some point between Friday, September 25, 2020 at 5pm PDT and Sunday, September 27, 2020 at 11:59 PDT. Downtime is unknown but will be minimized.

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

asked 28 Jan '16, 07:11

Ilia63's gravatar image

accept rate: 44%

edited 28 Jan '16, 11:42

Mark%20Culp's gravatar image

Mark Culp

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.

permanent link

answered 28 Jan '16, 08:05

Mark%20Culp's gravatar image

Mark Culp
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 28 Jan '16, 07:11

question was seen: 1,094 times

last updated: 28 Jan '16, 11:42