wood burning stoves*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "oracle - blocking reads" Watch "oracle - blocking reads" New topic

oracle - blocking reads

Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30123

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

Joined: May 26, 2003
Posts: 30123

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.
It is sorta covered in the JavaRanch Style Guide.
subject: oracle - blocking reads
Similar Threads
Question on locks and AutoCommit
Problem with inserting blob
Complex SQL Statements
Logging of SQL Queries with J2EE SDK
how to find out 3rd max salary from an emp table?