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?
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.
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.