freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Transaction problems...

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

Transaction problems..., Kalyan Chakaravarthy, 01/03/2002
- <Possible follow-up(s)>
- RE: Transaction problems..., Jeff Fisher, 01/03/2002
- RE: Transaction problems..., Winkless, Geoff, 01/03/2002
- Re: Transaction problems..., Michael Horowitz, 01/03/2002
- Re: Transaction problems..., Michael Peppler, 01/03/2002
- Re: Transaction problems..., Jeff Fisher, 01/03/2002
- Re: Transaction problems..., Michael Horowitz, 01/03/2002
- Re: Transaction problems..., Mark J. Lilback, 01/03/2002
- RE: Transaction problems..., Kalyan Chakaravarthy, 01/03/2002
- RE: Transaction problems..., nnklak, 01/04/2002
- RE: Transaction problems..., Jeff Fisher, 01/04/2002
- RE: Transaction problems..., Michael Horowitz, 01/04/2002
- RE: Transaction problems..., Kalyan Chakaravarthy, 01/04/2002