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 !!
-~----------~----~----~----~------~----~------~--~---
