Subject Re: [ib-support] lock table/record with JDBC to prevent deadlock
Author Phil Shrimpton
On Wednesday 20 November 2002 09:28, you wrote:

Hi,

> B: an exception is generated on the update:
> interbase.interclient.DeadlockException: [interclient][interbase]
> deadlock.
>
> My question is: how can I update the same table from different Java
> programs without getting an deadlock exception?

Deadlocks are normal, they are basically there to tell your application that
you are trying to update/change a record that somebody else has changed since
you started your transactions. It is then upto your application on you how
you want to handel the situation (keep trying till you can overwrite the
changes, display the changed fields to the user, give up etc.]

Phil

--
Linux 2.4.4-4GB
8:56am up 2 days, 20:20, 1 user, load average: 0.44, 0.14, 0.05