Hi,

you can use a timestamp and write for example :
update ...
where ...
and timestamp = 'the timestamp read by the select statement and saved in your application'

And then check the number of rows updated.

Antony Paul a écrit :

> Can u pls mention what is that Oracle feature ?. Reading the data again is
> time consuming.
> ----- Original Message -----
> From: "Johan Kok" <jkok@messianic.dyndns.org>
> To: "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>
> Sent: Monday, November 03, 2003 12:17 PM
> Subject: RE: Design advice needed.
>
> > Anthony,
> >
> > Did you consider reading the record without locks, and when an updated are
> > made, to take a write-lock, check that the original record are still the
> > same and then apply, otherwise fail.
> >
> > Your intentions might not work unless all writes are passed through the
> > container, as Oracle will not have any control, until a write occurs, i.e.
> > you will have to open with read only, and only take out a lock when you
> are
> > going to write, as described above. for safety sake your container will
> have
> > to re-read the data in any case, before commiting, otherwise it may update
> > changed data, e.g. updates that are made through other processes or even
> > triggers.
> >
> > If my memory serves me right, that is something you can do easily with
> > Oracle (i.e. there's a standard feature implemented), even with Oracle
> 6/7.

Jean-Louis CLAUSS