I have a situation where one of the app server thread is executing an
update statement on A record and at the same time another thread is
trying to read it by executing a select query. Now we are seeing
timeouts - Update query is holding the lock and the select statement
is timing off.
Now my question , how can I design this select statement so that it
doesn't wait for this update to be commiitted - I do not want to run
it with UR since it will allow dirty reads -
The lock is acquired via the following statement: UPDATE SIALRFCDATA
SET BLOBDATA=?, CREATED_DATE=?, FIELD1=? WHERE ORDERS_ID=? AND
TRANSACTION_TYPE=? AND RECORD_TYPE=?
The select query
SELECT ORDERS_ID, TRANSACTION_TYPE, RECORD_TYPE, CREATED_DATE,
MARKFORDELETE, CDATA, BLOBDATA, FIELD1, FIELD2, FIELD3, FIELD4 FROM
SIALRFCDATA WHERE ORDERS_ID = ? AND TRANSACTION_TYPE = ? AND
RECORD_TYPE =
Thanks
Rajib