tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Antony Paul" <antonypau...@hotmail.com>
Subject Re: Design advice needed.
Date Mon, 03 Nov 2003 11:22:26 GMT
But this requires adding a column to every table.
I found two ways of doing this.
1.  Using time stamp. It requires adding a column to table.
2. Checking data for equality before updating. It requires querying database
again.
Any alternative way.

thanks for the replies

Antony Paul

----- Original Message -----
From: "Jean-Louis" <claussj@hager.fr>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Monday, November 03, 2003 3:13 PM
Subject: Re: Design advice needed.


> 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
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message