Re: I don't know what to call this SQL Exception.

2008-08-06 Thread Owen Berry
"Optimistic locking" will give you some information. One way to do
this is to have a column in your database table that denotes a version
number, which is incremented every time the row changes. Include that
value in your form, and then you will be able compare the form version
to the database version, making sure they are the same before
performing the update.

Owen

On Wed, Aug 6, 2008 at 8:21 PM, ryan webb <[EMAIL PROTECTED]> wrote:
>
> Hi!!
>
> I know this is not struts question but I don't know this term so I cannot
> search the internet fot it.
>
> Two users are seeing the same page (data from database), and both of them
> are editing the same
> piece of data however, the other user submits the changes (update/delete)
> first.
>
> I need to inform the second user that his/her data is not the latest one.
>
>
> --
> warmest regards,
> Ryan Webb - Philippines
>
> email: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



I don't know what to call this SQL Exception.

2008-08-06 Thread ryan webb
Hi!!

I know this is not struts question but I don't know this term so I cannot
search the internet fot it.

Two users are seeing the same page (data from database), and both of them
are editing the same
piece of data however, the other user submits the changes (update/delete)
first.

I need to inform the second user that his/her data is not the latest one.


-- 
warmest regards,
Ryan Webb - Philippines

email: [EMAIL PROTECTED]