Subject Deadlock in a select statement
Author jensdein

I have a problem that has been bugging me for a while now. In my main
transaction I use a Cuncurrency locking isolation. I try to make sure
that changes are committed on a regular basis.

Somehow my users a sometimes getting a deadlock situation on a pure
select statement (no updates, just read only) using Committed

How is that possible? I thought I shoulden't be getting a deadlock on
a select statement - only on changes!!

Hov do I eventaully resolve what caused the lock?

Jens Dein

Using FB 1.5 and IBObjects for connectivity - if that is of any