Is Possible... (Pessimistic Locks) 1

[Hattusas]

to obtain a read (dirty read) from a table while someone is
deleting row(s) from the same table?
We are using java applications to make transactions but when we are trying to delete some records the other connections fall into lock-wait state (but we are %100 sure that the others want to read the records only;even dirty read would be OK...)
Any suggestions?

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr

 

[stevexff]

You can use

SELECT blah FROM x
   WHERE conditions
WITH UR;

to your other queries. 'UR' means uncommited read, i.e. a dirty read.

Caveat: there is no guarantee that what you read will be either consistent with the rest of the database, or even that it will even be committed or rolled back. But it doesn't take any locks, so it might be what you need.

 

[Hattusas]

It seems extremely logical. I will try it as soon as possible.Thanks

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr