Skip to Content.
Sympa Menu

freetds - Re: [freetds] begin atomic in procedures

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Pickett, David" <David.Pickett AT phlx.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] begin atomic in procedures
  • Date: Wed, 23 Nov 2005 12:54:16 -0500

It sounds like it might be from one connection being in autocommit mode, and
the other not. In autocommit mode when you do an update, it is implicitly
committed immediately. That is a usual cause for transaction handling
differences between clients.

http://sybooks.sybase.com/onlinebooks/group-sasarc/awg0702e/dbugen7/@Generic
__BookTextView/30474

> CREATE PROCEDURE test()
> BEGIN
> begin atomic
> message 'Entered Inner';
> update test set id=id+1;
> exception
> when others then
> message 'Error INNER', @@error,' text: ', errormsg();
> message 'Leaving Inner';
> end;
> END
>
> When I call test() from sybase interactive sql, all is ok.
> When I call it from php via freetds, ends with:
> Error -267: COMMIT/ROLLBACK not allowed within atomic operation
















-----Original Message-----
From: Petr ZEMAN [mailto:petrz AT aswsyst.cz]
Sent: Wednesday, November 23, 2005 11:10 AM
To: freetds AT lists.ibiblio.org
Subject: [freetds] begin atomic in procedures


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page