The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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: 16%

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: 282 times

last updated: 28 Jan '16, 11:42