> The default still depends on the DB and how it is set up. > > "If you do not specify a value for the isolation attribute, > ColdFusion uses the default isolation level for the > associated database." > > http://livedocs.macromedia.com/coldfusion/7/htmldocs/00000346.htm > > For Oracle this is often Read Committed.
For most databases, the default isolation level is read committed, but I believe that the documentation may be in error on the point you quoted. This came up a while back, according to my somewhat hazy memory, and I thought the documentation was correct, but was told by someone (I forget who) that this was no longer the case. Prior to CFMX, it was in fact the case that the default isolation level of the database would be used. In any case, you should set your isolation level explicitly, I suppose! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
