Basically, this is what I'm doing, which works just fine on a single app
server. Multiple servers would be a problem, though. Many thanks.
< cflock timeout="30" name="insertpayment">
< cfquery name="inserttrans" datasource="#ds#">
insert into tblpayment . . .
</ cfquery>
< cfquery name="gettrans" datasource="#ds#">
select max(transid) as transid from tblpayment
</ cfquery>
</ cflock>
-----Original Message-----
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: Monday, October 28, 2002 10:17 AM
To: CF-Talk
Subject: Re: Locking and clustered servers
Ryan Farrell wrote:
> We're using DB2 for Solaris. We have tried using , but that doesn't
> work for some reason.
In combination with what? If you do it in combination with something to
SELECT MAX(id) from your table it indeed won't work. What you are trying
to prevent is a phantom read, which requires a isolation level of
serializable. If you are trying some built-in functionality, show us the
code.
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
