We're using DB2 for Solaris. We have tried using <cftransaction isolation="READ_UNCOMMITTED">, but that doesn't work for some reason.
Ryan -----Original Message----- From: John Morgan [mailto:gameczar@;zbzoom.net] Sent: Monday, October 28, 2002 9:44 AM To: CF-Talk Subject: Re: Locking and clustered servers What DBMS are you using Oracle, MS SQL Sever, Etc? Your Database system may offer a solution. I know Oracle has a way to handle this and I think MS SQL has a way too. -John- At 09:19 AM 10/28/2002 -0600, you wrote: >Ok, we are thinking about setting up 2 port redirectors/load balancers >(hardware) and 5 separate servers running CF 5. So, the only problem is >that some of our code has named locks to prevent simultaneous record >insertions on a particular table. I can't think of any way to make a lock >recognizable to another server, but maybe someone out there has a neat trick >or two. Or, maybe we can eliminate the need for the lock: how do some of >you handle the process of inserting data into a table that generates an >autonumber and then figuring out what number was just generated? Any help >would be greatly appreciated. > >Thanks, > >Ryan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com