[freetds] Fw: FreeTDS patch for MSSQL autocommit

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Tue Apr 1 04:11:52 EDT 2008


> 
> Peter Deacon wrote:
> > On Mon, 31 Mar 2008, James K. Lowden wrote:
> > > I received the attached AUTOCOMMIT patch by private mail.  I don't
> > > know how/if it would be merged with CVS HEAD and/or 0.82.
> > > What do you think?
> > 
> > Running profiler on .82 both FreeTDS and the MS driver sent 
> the same 
> > commands over the wire when switching autocommit on and off.
> > 
> > XACT_ABORT is OFF by default.  The driver must not enable it
> > 'implicitly'  when toggling autocommit.
> 
> IOW, the 0.82 driver is OK as is, and the patch should not be 
> applied?  
> 

I would also add that changing autocommit inside a transaction is an
error to commit transaction before setting autocommit.

freddy77



More information about the FreeTDS mailing list