Our application is using jtds driver and the database is MS Sql Server 2000. We are having 2 processes say ProcessA and ProcessB accessing a table Action1.
The problem we are facing is it either deadlocks or time-outs the resources waiting. How do we programatically code the isolation level to query with an "Uncommitted Read"? What I am trying to find is an sql query or code wise alteration of the following query:
select a.docControlID from action1 a WHERE a.ID = 49270
Although it is a simple query there is another ProcessB which is trying to update the Action1 table parallely. The dba says we have a row level locking on the db. So please let me know of any suggestions to be made on the code as well on the database also.