Hello.
Is there any way of having a record or a table locked by a select statement?
I have to concurrents applications, a UI one and a Windows service.
Mostly th Windows service writes data to the database, but it seems that the UI application was locking an update statement on the Windows service. I have changed the selected record on the UI application but the srevice was kept locked until the UI application connection was closed.
Is there any reason for that ? There was no any open transaction.
Thank you very much.
Kind regards.
Jayme Jeffman Filho.
Lock by read only SQL
Re: Lock by read only SQL
Hello,
If the SELECT FOR UPDATE construct is used in Pessimistic Mode, then a record is locked at the database level - and other applications can't modify this record. If you use a similar construct in your application, then on record update attempt you will get a corresponding error message that the record is locked. And you will be able to inform users about it.
If the SELECT FOR UPDATE construct is used in Pessimistic Mode, then a record is locked at the database level - and other applications can't modify this record. If you use a similar construct in your application, then on record update attempt you will get a corresponding error message that the record is locked. And you will be able to inform users about it.