Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

About WRITE_DELAY

 
Benson Fung
Ranch Hand
Posts: 214
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am going to move this to the JDBC forum.

Thanks

Mark
 
Campbell Ritchie
Sheriff
Posts: 48424
56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Found this on Google. Don't know how useful it will be, but try it.
 
Campbell Ritchie
Sheriff
Posts: 48424
56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 214
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic