[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