Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database issue while updating

 
Jagdeep Sharma
Ranch Hand
Posts: 121
IBM DB2 Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I'm having a table, frequently used. Sometimes i face this issue. when somebody tries to update some rows. It doesnt get updated in fact i handled such situation in java by throwing exception. But no exception is shown. Can somebody give some useful advice. is there any locking happening preventing query to be executed.


Thanks
 
Henry Wong
author
Marshal
Pie
Posts: 22108
88
C++ Chrome Eclipse IDE Firefox Browser Java jQuery Linux VI Editor Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not really threads related -- moving to the JDBC (closer in relation to databases) forum.

Henry
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Locking only occurs if you are in a transaction. As far as an exception not being thrown, you would need to show some code.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
(...unless you are using SQL Server with its ever annoying shared read locks.)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic