• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

deadlock in oracle

 
Michal Harezlak
Ranch Hand
Posts: 185
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
According to the documentation Oracle RDBMS systems resolves deadlock itself. When one client is trying to access for write/update a row locked by another one, it should be given error message (deadlock while waiting for the resources or similar) from server. I updated (without commit - row is still locked) one row using SQL PLUS and tried to use my Java/JDBC application to update the same row (using stored proc.) I caused my application to hang and received no messages from server. Any ideas? Am I missing some settings?
 
Bhupinder Dhillon
Ranch Hand
Posts: 124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It will only resolve the situation if both updates were done in the same app (java or otherwise) but from different threads.
 
Michal Harezlak
Ranch Hand
Posts: 185
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, dose it mean that I will have to synchronize data access manually while using multiple single threaded servers?
 
Bhupinder Dhillon
Ranch Hand
Posts: 124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That's correct.
 
E
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this an Oracle issue or a JDBC one?
 
Michal Harezlak
Ranch Hand
Posts: 185
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The problem will occur no matter what kind of client will you use, so I think it has little to do with JDBC.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic