I'm not saying this should or should not be fixed but is there a real world scenario where you would do this? I would like to think not, if there is I would think that you should explicitly state you want the transaction rolled back, or committed.
Adam On Fri, Jul 24, 2009 at 6:39 AM, Victor Balada Diaz < [email protected]> wrote: > > Hello, > > When we do a cfabort inside a cftransaction the transaction > never ends and leaves the table locked instead of rolling back > the transaction. > > Example code: > > <cftransaction action="begin"> > <cfquery name="X" datasource="ds">INSERT INTO table > VALUES('a')</cfquery> > <cfabort/> > </cftransaction> > > If you execute this code, the first time it leaves the connection > and the transaction opened. So if i try a second execution of the same > code it waits forever until the first one is terminated, which never > happens. > > FIX: > > cfabort should close all currently running transactions. > > Thanks in advance. > Regards. > > > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
