> Just curious, why do you care if multiple threads are reading the database > from this gateway at the same time? > > There are always "race" conditions in shared scopes, but you only need to > lock them when actually have consequences.
It's a multi-tenant application. People in one account were seeing other accounts' information. I'd say that counts as consequences. As I said I've never needed nor wanted to use locks before, but this definitely looks like a situation where one is warranted. I was thinking about using a named lock, but I thought since this CFC is cached in the Application scope that would be more appropriate. I'll give the named lock a try. -- Josh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
