But we may well need to study in more depth the relation between autocommit and implicit transactions. Sunday, April 9, 8: Obviously you know when to commit a transaction, so then you should know when to start one. Monday, March 27, 9: But you never know
|Date Added:||7 September 2004|
|File Size:||36.3 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
But we do explicitly commit or rollback when we’re done. Obviously you know when to commit a transaction, so then you should know when to start one.
I agree it would be better to start the transactions explicitly, but unfortunately that is not how our drivers work.
ODBC – who is using it? | Uniface Deployment | Forum
This hasn’t caused problems for our customers so far, but one customer uses snapshot isolation on their DB and are observing massive bloat of the tempdb, apparently caused by the fact that each process always has a transaction unfiace.
Hi David, Thanks for your reply.
Or at least I think that is why we turn autocommit OFF. But you never know Edited by cbreemer Tuesday, April 11, 1: Monday, May 1, 3: Sunday, April 9, 1: As I pointed out, in the day I did live in a world with no autocommit, I still unifade to start the transactions explicitly.
Now, the SQlExecDirect call does not produce a transaction, which seems contrary to the documentation too Tuesday, April 11, 1: I have not posted in these forums before. All fine, this is as expected and odbbc. This is not as documented.
In both cases the transaction will have begun by the time you run the first query. Tuesday, April 11, 4: Microsoft Technology Center – Dallas My blog.
Remove From My Forums. Tuesday, April 11, 9: Yes I realize that.
ODBC – who is using it? | Uniface Deployment | Forum – Uniface
David, thanks for your verbose reply. Why is that obvious? Erland, a belated thanks for your reply. Also note that you are not constrained by the ODBC driver’s transaction handling. Edited by davidbaxterbrowne Microsoft employee Tuesday, April 11, The content you requested has been removed.
Besides, if you want to end a transaction, you could have a try to explicitly call commit or rollback. I guess if there is a bit of terminology confusion here.
ODBC Connector Options
In that case autocommit would be ignored. Alas, this is not very good in production environments, as if you are not aware of the behaviour or just obliviousyou can cause blocking situations. At that particular place we can add. Sunday, April 9, 6: Thanks for your reply. I don’t know exactly what Uniface does although I have a faint memory of that it is a so-called 4GL productbut you can control transactions in more way than relying on implicit transactions.
This can be beneficial to other community members reading this thread.