Re: oracle row level locking with JSP?

"Nicolas Bronke" <newsgroup_at_trinity.de> wrote in message news:98vs8r$4rt$01$1_at_news.t-online.com...
> > > Is it True, that the oracle row level locking is with Java JSP
 impossible?
> > >
> > Why do you assume that is true?
> > It isn't, BTW
> >
> Because our java developers said that. In our "standard" client server
> application, we are using
>
> select * from tablename where <whereclause> for update nowait
>
> so that one record is locked and another user gets immediatly an error
> message if he starts updating the same record. Thats works really fine and
> handy.
>
> Now we are transferring some parts to an intranet application using oracle
> as the database backend and Apache as the application server, so that we
> have an thin client. Now these developers told me, that this way is not
> possible (select ... for update nowait) if we are developing JSPs. I could
> not believe that. This is the reason why I am looking for another meaning.
>
> Regards
>
> Nicolas
>
>

In my experience such general assertions by developers have always be proven to be wrong, and instead of that showed their lack of knowledge of jdbc and other tools.
In one of the applications I am aware of no bind variables have been used. This is not because it is not possible, it is just because they have been too lazy to write the extra code.
In the JSP applications I have been monitoring I have *never* seen any sign of table level locking.
So I would ask *written proof* from your developers (JSP manuals etc) and without any doubt you could proof it is not true. If they too never use bind variables in their code, you already know enough: they are being lazy.

Regards,

Sybrand Bakker, Oracle DBA Received on Sat Mar 17 2001 - 13:57:49 CST