LiveDocs Comments - coldfusion - 6.1 - htmldocs - tags-c15.htm

coldfusion/6.1/htmldocs/tags-c15.htm

2006-02-13T01:53:34

Hi

the following document is about exception handling in cf mx, but it contains some information about cftransaction and a description of its options.

http://www.how2cf.com/files/papers/exceptions.pdf

mybe it helps understanding.

coldfusion/6.1/htmldocs/tags-c15.htm

carehart — 2005-09-16T07:52:07

The link offered above (in another comment) to some Oracle docs on transaction isolations fails. I found another place where those particular docs are available online:

http://www.mpi-sb.mpg.de/departments/d5/teaching/ss05/is05/oracle/appdev.920/a96590/adg08sql.htm#2655

There may be still better or more modern references to those oracle docs, but I'll leave that for others to explore.

coldfusion/6.1/htmldocs/tags-c15.htm

2005-04-01T05:17:05

tinu8805: Hi. same problem here, but i found the solution.
replace
with

my guess is Macromedia fixed something in the tag parsing code somewhere else and it butterfly-effected and broke this. :)

EjayHire@hotmail.com

coldfusion/6.1/htmldocs/tags-c15.htm

mcollins — 2004-11-16T12:58:04

If you have not found resolution on the User Forums, I would suggest you contact Product Support directly.

coldfusion/6.1/htmldocs/tags-c15.htm

tinu8805 — 2004-11-15T16:54:43

I don't understand cftransaction at all if compared to CF 5.0. I just recently upgraded our business app from CF 5 to CFMX 6.1. However, to achieve this, I had to commet out ALL or ...action="rollback" ... if I let them there, CFMX would ALWAYS generate a runtime error. I could reproduce that silly behavior and also put that problem into the user support forum about 2 years ago. Nobody not even Macromedia could solve the problem I reported.

Another forum member answered my question like this: He was playing with cftransaction and found it to autmatically rollback if an error was thrown and to automtically commit if the was reached. With this help, I commented out all in my code.

For most of the time, I can accept that behavior. But I DO have some transaction where I deliberately want to rollback a transaction. This is now disabled becvause if I uncomment the CFMX would generate an runtime error.

PS: To make it clear: If I completely remove all cftransaction tags, the application works in CFMX as it did in CF 5. So, CFMX throwing a runtiem exception was not because of an exception raised by the execution.

I use Sybase ASA 8 as my ODBC connected RDBMS.

Up to today, I have not yet received any better answer than from that forum member. And of course, my deliberate rollback is still out of order ... :-((

coldfusion/6.1/htmldocs/tags-c15.htm

Daniel Elmore — 2004-11-13T22:05:41

I sniffed the packets generated from ColdFusion to a MS SQL 2000 server and found that CFTRANSACTION adds the following commands to query groups.

SET TRANSACTION ISOLATION LEVEL ... (attribute specifed in tag)
SET IMPLICIT_TRANSACTIONS ON

queries here

IF @@TRANCOUNT > 0 COMMIT TRAN

coldfusion/6.1/htmldocs/tags-c15.htm

bizarrojack — 2004-08-16T17:41:40

Is it possible to simply turn off autocommit, rather than be forced to comply with the constraints enforced by the context validator? I find that requiring the matching and is unreasonable.

For instance, if you have a multi-step process that needs to be part of a transaction, but could also be a required part of a longer transaction, It can't be written as a module that starts a transaction only if it isn't already in one, because putting inside 's will cause a context validator error.

It would be nice to be able to turn off autocommit if it wasnt already off, and not turn it back on until you had completed a parent transaction.

also, it seems peculiar that requires a start tag, but doesnt require an end tag.

coldfusion/6.1/htmldocs/tags-c15.htm

McGarnagle — 2004-08-04T09:20:33

Oracle docs on isolation levels:

http://www.cise.ufl.edu/help/database/oracle-docs/appdev.920/a96590/adg08sql.htm#2655

coldfusion/6.1/htmldocs/tags-c15.htm

bizarrojack — 2004-07-16T12:35:19

Can modules safely be called in a cftransaction? This pseudocode roughly describes my question scenario - assume each module has an insert or update cfquery.

I have gotten at least one test to work like this; That is, the desired result is for the inserts or updates in the first module would not be committed unless the inserts or updates in the latter module should complete. I ask this because some other developers that I know have claimed that they have had problems with similar setups.

Is there some sort of trick to it?
I am specifically curious if it might depend on the type of error that comes from the second module.

coldfusion/6.1/htmldocs/tags-c15.htm

Mike.Schwartz — 2004-07-06T11:35:50

In answer to the previous question, this is all handled entirely by the database. As such, there should be something in the docs that says that this requires a database that handles transactions. Also of interest would be what happens when you use this tag on db's which don't support transactions.

coldfusion/6.1/htmldocs/tags-c15.htm

2004-06-09T08:04:59

How does this work under the hood? If I have 3 inserts within a cftransaction tag and the first 2 inserts succeed but the last one fails, how does CF roll it back?

Did CFautomatically do a Select to store the previous values of the record and then when the 3rd insert blows it updates the first 2 to the orginal status?

What if you were going to do a cascading delete and you had to delete through a hierarchy of 6 tables and the last one blows for some reason? And one of the deletes blew away 1000 rows. Did CF store that 1000 rows and then reinsert them? But what if an identity was bieng used that would blow the relationships?

I haven't tested this but I just don't see how this can work at all and would love an explanation of how it works. I did read the mentioned article which was good but didn't explain how CF handles the processing.

coldfusion/6.1/htmldocs/tags-c15.htm

halL — 2004-04-19T07:32:30

For more detailed information on cftransaction, see the Devnet artilce "Controlling Database Transactions in ColdFusion MX" at http://www.macromedia.com/devnet/mx/coldfusion/articles/cftransaction.html.
I believe that this article anwsers both of the preceding questions.

coldfusion/6.1/htmldocs/tags-c15.htm

Chris.Velevitch — 2004-04-19T00:47:48

Please explain what happens at the end of the transaction block,especially when there are no embedded cftransaction tags in the block.

Please explain what happens to the remainder of the block if an error occurrs.

coldfusion/6.1/htmldocs/tags-c15.htm

myPitboss — 2004-04-04T16:32:34

Please expand the explanation of (read_uncommitted,read_committed,
repeatable_read,serializable) for the CFTRANSACTION tag.