Skip to Content.
Sympa Menu

freetds - Re: Transaction problems...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Jeff Fisher <JFisher AT Emery-Waterhouse.com>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Transaction problems...
  • Date: Thu, 3 Jan 2002 12:13:43 -0500


I don't believe Oracle commits the transaction. I've killed many users with
open transactions and they do not get commited. I suppose I could create a
test app and verify it.

-----Original Message-----
From: Michael Peppler [mailto:mpeppler AT peppler.org]
Sent: Thursday, January 03, 2002 12:05 PM
To: TDS Development Group
Subject: [freetds] Re: Transaction problems...


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

---
You are currently subscribed to freetds as: [jfisher AT emery-waterhouse.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')




Archive powered by MHonArc 2.6.24.

Top of Page