Re: A row locking problem that baffles all...

On Fri, 15 Jan 1999 14:13:57 -0800, Rick <Rick.UK_at_nospam.btinternet.com> wrote:

>It would appear that what you want can't be done. No-one here seems
>able to answer your question and Oracle can't.
Exactly, but why? The problem's requirements seem so simple.

>However, various
>sensible suggestions have been made as to how you can avoid the original
>problem occurring.

And I do appreciate them. Unfortunately, it's simply not a case of redesigning everything / avoid these problems in the future. I am confined by an existing architecture. I'd love to use some of the ideas.

>If it is such a big problem that it needs solving then I think you'll
>have to make changes to the application.
The system is massive and major architectural alteration costs would be too extreme and too expensive to justify, simply to show an exception dialog with a bit of information in it.

> If it ain't then why not just
>accept people's suggestions with grace? - or are you just out to show
>that you've got a problem which no-one can solve?
Rick, that really isn't the case at all ;o). It is a simple request on the world's best RDBMS (Oracle) but it can't seem to be done. I've had some superb E-mail replies from people who obviously know what they are talking about, and have had some extremely innovative alternative locking approaches. I've also had plenty of requests from others who want to know what the solution is, because they use the same locking techniques.

But people are avoiding the question which exists within a bounded scenario. All I need is a query to join the locker SID to the refused locker SID after a pessimistic Nowait record lock. That is what I'm asking for.

>If so I guess you've
>probably got more of a problem than you think....
<Laughing> I know the lock problem is a big one, but as for me.... thanks for the vote of confidence.

>Rick:-)

Kind Regards
Paul Scott
aspscott_at_tcp.co.uk
^^ remove 'as' anti-spam prefix to E-mail Received on Fri Jan 15 1999 - 08:38:41 CST