This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Read Uncommitted in Sql Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Read Uncommitted in Sql Server" Watch "Read Uncommitted in Sql Server" New topic
Author

Read Uncommitted in Sql Server

Luke Zechariah
Ranch Hand

Joined: Sep 27, 2005
Posts: 117
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.

Thank you for your time.
Luke.
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
http://www.databasejournal.com/features/mssql/article.php/3289661
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Read Uncommitted in Sql Server
 
Similar Threads
Informix
phantom and dirty read?
how database handle request?
Select query not working with Jdbc for transactional calls.
best programming practises of JDBC