Ask a Question related to Coldfusion Database Access, Design and Development.
-
andygeers #1
cftransaction across cfcs
Hi there,
There seems to be a REALLY irritating 'feature' of Coldfusion MX, to do with
using cftransaction across function call boundaries, which is even present in
CFMX 7.0.1.
If I do this:
<cftransaction>
<cfset myTestFunction()>
</cftransaction>
... then any cfquerys inside myTestFunction() will automatically commit
straight away - in other words, it acts as though it's not inside a
cftransaction when clearly it should be.
This is especially significant when it comes to unit testing your CFCs, and
from a general encapsulation point of view. Our whole methodology revolves
around having all our business logic inside CFCs, and most of our business
logic is transactional, so this is a real problem.
Macromedia/Adobe - do you have any plans to change this in future releases? I
would urge you to consider doing so - this does not make your language look
like a good choice for our future developments.
andygeers Guest
-
cftransaction
I have a question about CFTRANSACTION. We are currently using CF6.0 with various versions of Oracle and SQL Server. In our server settings we do... -
CFTransaction rollbacks
When I am in a transaction and an an error forces me to issue a rollback, my database effectively locks up. I have the feeling that isolation level... -
CFtransaction error
I'm getting the following error: Nested transactions are not supported. A cftransaction tag can not be nested within another cftransaction tag. ... -
CFTRANSACTION w/ ROLLBACK
Here's what I'm trying to do, this worked in CF 5, but bombs with the following error in CFMX 6: The <CFCATCH> tag requires an end tag to nest... -
is this possible - cftransaction
I don't want to get into the whole 'users shouldn't have access to the db' discussion. It's a battle that's been lost. We are looking at...



Reply With Quote

