Re: Record Locking ???

TurkBear wrote:
> Michael Hill <hillmw_at_ram.lmtas.lmco.com> wrote:
>
> >I have a Coldfusion web application that makes calls to Oracle tables,
> >inserts, updates, et. al and one of my users wants to add "Record
> >Locking". I am thinking this is not practical and is only valid in a
> >client-server environment.
> >
> >Am I wrong?
> >
> >Comments?
> Ask your user why he wants to manually do what Oracle will handle automatically?
>
> Just curious...

While Oracle handles row locking automagically within a transaction, the issue as I see it is how to preserve a transaction across multiple web requests. i.e. the interaction is something like

1. begin a transaction
2. get the data with a select for update
3. update the data
4. commit or rollback the transaction

The issue is item 2 and item 3 are handled in separate web requests - when the user comes back to update the data, how does he pick up the transaction that he opened in item 1?

There's no reason that I see that would make this technically impossible, but I have no idea how to do it in Cold Fusion.

-- 
//-Walt
// 
//