pymssql defaults to auto-commit=True about pymssql

[GoogleCodeExporter]

This is fixed in trunk now, autocommit already defaults to False in trunk but 
now also calls SET IMPLICIT_TRANSACTIONS ON, thanks for the suggestion.

Original comment by [email protected] on 4 Jan 2011 at 7:53

• Changed state: Fixed

[GoogleCodeExporter]

I am going to revert this actually in hindsight. I think you may have 
misinterpreted how IMPLICIT_TRANSACTIONS work, it opens a transaction and then 
leaves it open, which is quite odd behaviour and just caused a few hours 
debugging.

pymssql opens a transaction when it initially connects so there is no 
autocommit, at least in 1.9.909.

Original comment by [email protected] on 24 Feb 2011 at 3:42

• Changed state: WontFix

[GoogleCodeExporter]

> in hindsight. I think you may have misinterpreted how IMPLICIT_TRANSACTIONS 
work

I agree.  Still the issue remains in 1.0.2 that pymssql autocommits after every 
execute.  Glad to hear it's fixed in head tho.  :)

Original comment by [email protected] on 24 Feb 2011 at 4:58