Subject Re: [firebird-support] Re: Firebird on Redhat Linux
Author Ann W. Harrison
sivahari33 wrote:
> Symptoms which we are getting are
> 1) Unable to select a particular record from our application. Since 'lockwait' property is true the query shows a waiting cursor.

The easy answer is not to set "lockwait" so your application sees the
version of the record that was current when the transaction began.
That has two advantages. It eliminates the wait and gives your
transaction a consistent view of the database.

> 2) If we try to update this record from Ibexpert then It shows 'Deadlock' message

Some other transaction has modified the record and not committed.
Eventually the connection for that transaction times out. Find the
place in your application with the uncommitted update.

Best regards,