CFTransaction doesn't rollback on error

[CFGumby]

Hi all, years ago on CF 4.5, our cftransaction tags used to rollback changed
data when something inbetween <cftransaction> and </cftransaction> failed or
even a <cfabort>. But ever since we upgraded to CFMX, they do not roll back
data. We also went to JDBC at the same time, I don't know if that has anything
to do with it. About the same time, we also changed from MSSQL 7 to MSSQL
2000. And we are currently on CFMX7. Somewhere in all this changing,
cftransaction broke. I'm at a loss. What should we check to get this working
again? Thanks in advance.

[CF_Oracle]

Please present your code. Hope you use somethging like that within cftransaction tags
<cfcatch type="database">
<cftransaction action = "rollback"/>
</cfcatch>

[CF_Oracle]

Please present your code. Hope you use somethging like that within cftransaction tags
<cfcatch type="database">
<cftransaction action = "rollback"/>
</cfcatch>

[CFGumby]

That was one version. Normally, it was like this;
<cftransaction>
<cfquery...>
</cfquery>
<cfquery...>
</cfquery>
</cftransaction>

That used to work. I've tried that in a test script and also your way;
<cftransaction>
<cftry>
<cfquery...>
</cfquery>
<cfquery...>
</cfquery>
<cfcatch type="any">
<cftransaction action = "rollback"/>
</cfcatch>
</cftry>
</cftransaction>

Niether one works, but they used to.

Thanks.

[BKBK]

<cftransaction>
<cftry>
<cfquery...>
</cfquery>
<cfquery...>
</cfquery>
<cfcatch type="any">
<cftransaction action = "rollback"/>
</cfcatch>
</cftry>
</cftransaction>

Better is

<cftry>
<cftransaction>
<cfquery...>
</cfquery>
<cfquery...>
</cfquery>
<cfcatch type="any">
<cftransaction action = "rollback"/>
</cfcatch>
</cftransaction>
</cftry>


But ever since we upgraded to CFMX, they do not roll back data.

If the queries run without errors, Coldfusion's default behaviour is to
commit. It's therefore not clear to me why you expect the transaction to roll
back. Was there an error?

[CFGumby]

Sorry, this is basically a copy of our test cfm. I purposely misspelled a
field name in the second query, forcing it to fail and it does. However, the
update from the first queries still exits in the database. In the second
query, I misspelled UserID (UserIDx).
Here are the two queries. Thanks.
<cfquery name="qUpd" datasource="MSSQLDB" dbtype="query">
UPDATE Access
SET Access = 1
WHERE UserID = 1
</cfquery>

<cfquery name="qUpd2" datasource="MSSQLDB" dbtype="query">
UPDATE Access
SET Access = 2
WHERE UserID = 1
AND UserIDX = 1
</cfquery>

[CFGumby]

I found the problem, it is dbtype="query". This is left over from CF 4.5 and
now (from CF help) "all values of the attribute DBTYPE have been depricated
except for QUERY. They do not work, and might cause an error, in releases
later than ColdFusion 5." Why would MM (or Adobe) depricate something and then
let it cause a problem? Sloppy (or lazy) upgrade mentality if you ask me.
"Seamless upgrade" my asterisk.