Subject Deadlock when 2 session update the same 01 row
Author Nguyen Dang Quang
Dear all,

I am newbie to Firebird, I am working on Oracle and porting a small module
to Firebird. We face with very strang problem:

When session A and B update a row in a table at the same time. If A goes
first, and while A does not commit or rollback yet, B will update the same
row. In Oracle, B will be blocked until A commit or rollback without any
error. But In Firebird, B will get Deadlock immediately.

Can I config FB to do exactly like Oracle does? Or, It is a bug?

Please help!



Best Regards,



[Non-text portions of this message have been removed]