Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

Ilia63
1.2k515782
accept rate: 44%

edited 28 Jan '16, 11:42

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297


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
24.9k10141297
accept rate: 41%

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×438
×59
×24

question asked: 28 Jan '16, 07:11

question was seen: 1,808 times

last updated: 28 Jan '16, 11:42