I am upgrading a large app from CF5 to MX7 and in testing have discovered a
bunch of problems associated with Oracle database access. The error is
"ORA-08177: can't serialize access for this transaction". After looking a bit
into this error I have discovered that the default database access mode of cold
fusion MX6 or MX7 after applying the client variable hot fix is now
"serializeable" instead of "read committed". I want teh db access to continue
to be "read committed" as it was - I can override the coldfusion default access
by establishing a <cftransaction> for each query and plugging in a database
access mode for each - but there's got to be a better way . Can I override the
Coldfusion default database access mode and set it back to read-committed w/o
wrapping a transaction around all my queries? Why was this changed in the
first place? The solution offered by macomedia does not address the fact that
I need to run in read-committed mode. Thanks!