[freetds] begin atomic in procedures

Pickett, David David.Pickett at phlx.com
Wed Nov 23 12:54:16 EST 2005


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



More information about the FreeTDS mailing list