aspose file tools*
The moose likes JDBC and the fly likes oracle - blocking reads Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "oracle - blocking reads" Watch "oracle - blocking reads" New topic
Author

oracle - blocking reads

Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29287
    
140

In our Oracle 9 application, the read only (JDBC) queries block when we are updating the database. The updates occur within entity beans in a transaction with an isolation level of committed.

Is it possible to get the queries to retrieve the last committed data rather than block?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
By saying updating database, you mean updating some particular rows of a particular table, right??

if it is like that then the behaviour is wiered.

Because in oracle, while updating rows, the previous committed rows, that are being changed, is written to a rollback segment. And when some other user executes query on that table then he/she doesn't get the uncommitted changed rows, but committed old rows from rollback segment.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29287
    
140

Adeel,
Yes, I mean updating some rows in a database.

Thanks for confirming my understanding of this at least. I guess I'll experiment with transaction settings to see if I am somehow supressing this behavior.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: oracle - blocking reads
 
Similar Threads
Complex SQL Statements
Problem with inserting blob
Logging of SQL Queries with J2EE SDK
how to find out 3rd max salary from an emp table?
Question on locks and AutoCommit