Skip to Content.
Sympa Menu

freetds - Re: Transaction problems...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Transaction problems...
  • Date: Thu, 3 Jan 2002 09:04:57 -0800


Michael Horowitz writes:
> I don't know if this is the same issue, but I remember reading about
> issues with disconnects and commit/rollbacks with the Perl DBI module. It
> said, "The transaction effect of explicitly disconnecting from a database
> while AutoCommit is disabled is, sadly, undefined.

Sybase will rollback any transactions that aren't committed when the
connection is dropped. I find Oracle's behaviour inexplicable. I
suspect that MS-SQL has the same behaviour.

Michael
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler AT peppler.org - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com




Archive powered by MHonArc 2.6.24.

Top of Page