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.

One of our clients had a program crash while the programm was inserting a bunch of data. Although the programm hadn't run to the point where the commit would have been executed, the data is still there [SA 12.0.1].

So I wonder if there is a connection option triggering a commit it the connection is closed, similar to that option setting in ISQL. I searched the help and checked sa_conn_options, but to no avail. Did I overlook something, or is there another explanation?

asked 31 Jul '12, 09:57

Reimer%20Pods's gravatar image

Reimer Pods
accept rate: 12%


SQL Anywhere shouldn't commit a transaction unless the application tells it to. Have you looked at the transaction log to try and figure out what may have happened?

(31 Jul '12, 11:28) Reg Domaratzki
Replies hidden

If it's a PowerBuilder application the default for CommitOnDisconnect is 'Yes'.

(31 Jul '12, 11:59) Breck Carter
Replies hidden

The application has been build with Power++, not PowerBuilder. But the Power++ IDE uses a subset of PowerBuilder 6.5 to create DataWindows and Reports. So there might be a similar property behind the scenes (undocumented).

(01 Aug '12, 04:06) Reimer Pods

I don't have access to the log file. But I don't think I could learn much from that: surely there will be a commit, but it's hard to tell where it comes from.

(01 Aug '12, 04:10) Reimer Pods

I'm sure you're running in ODBC's manual-commit mode (and not the default auto-commit mode), right?

(07 Aug '12, 09:29) Volker Barth
Be the first one to answer this question!
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: 31 Jul '12, 09:57

question was seen: 744 times

last updated: 07 Aug '12, 09:29