Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Dead lock issue

 
Arun Kumar
Ranch Hand
Posts: 133
Chrome Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

We have a scenario in which on process inserts a new record to the table.After 5-10 seconds another process selects this record and updates the value of one of the field

This is a continuous process and after some time we are getting a dead lock

Will an insert and after some time a select and Update create a deal lock
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Will an insert and after some time a select and Update create a deal lock

It shouldn't. How have you verified it is a deadlock you are seeing?
 
Sree Chinna
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It is not a deadlock but what you might be facing is database locks.

Which database are you using ?
At what point do you commit ?
Whether the updations are done in same session or different ?
What is the transaction level ?
[ July 16, 2008: Message edited by: Sree Chinna ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic