The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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

last updated: 28 Jan '16, 11:42