SQLCA.AutoCommit = TRUE
- Advice
- John Vanleeuwe
- PowerBuilder
- Monday, 13 May 2019 03:16 PM UTC
Hi guys,
Recently one of our customers is complaining about "lost data". I am not yet sure how this happens, but i have a feeling it has to do with the autocommit property of the transaction object.
I am using PB2017 R3 with a SQLAnywhere 11 database. Once or twice in a month this particular customer looses data. When i try to translate the logfile, all i can see is "checkpoints", but not one actual sql statement of update/insert/delete of any table.
We do have a function to upload blobs in our db and i am guessing an autocommit is wrongly set... It's just a hunch , a feeling ... Could the db connection autocommit be the cause of this behaviour ?
Sadly because there's not one single sql statement in the translated logfile , i can't recover customers lost data...
TIA
John
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.