Two Laptop Bag*
The moose likes JDBC and the fly likes About WRITE_DELAY Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "About WRITE_DELAY" Watch "About WRITE_DELAY" New topic
Author

About WRITE_DELAY

Benson Fung
Ranch Hand

Joined: Apr 10, 2003
Posts: 207
Hi,

I know there is WRITE_DELAY property for HSQLDB. Is there such or similar property for Oracle DB server?


Regards
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

I am going to move this to the JDBC forum.

Thanks

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38087
    
  22
Found this on Google. Don't know how useful it will be, but try it.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38087
    
  22
Originally posted by myself:
Found this on Google. Don't know how useful it will be, but try it.
I don't think it will be any good after all, even though it mentions WRITE_DELAY. Sorry.
Benson Fung
Ranch Hand

Joined: Apr 10, 2003
Posts: 207
Hi,

The problem why I am asking the question is that a thread does an update within hibernate session and then does a commit. However, another thread still reads the old data right after the 1st thread did a commit. And it eventually can read the correct after a while. I believe it is kind of dirty read. Given that the isolation level hibernate has been preset to read committed and the underlying database is oracle, app. server is jboss 4.0.5

Do you know what causes this issue?

regards
 
 
subject: About WRITE_DELAY
 
Similar Threads
sqlexception with hsqldb-please help
No error/exception in log on insert yet no row inserted to db
Table mapping problem
Same old problem?
jquery datepicker not working