Subject | Deadlock when 2 session update the same 01 row |
---|---|
Author | Nguyen Dang Quang |
Post date | 2012-11-27T07:09:49Z |
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]
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]