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

is there any condition that a connection stop until another connection commit?

 
raminaa niilian
Ranch Hand
Posts: 551
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Thank you for reading my post
is there any scenario that a JDBC connection block (suspend) in its operation (for example a select) until another connection finishes its transaction?

Thanks.
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, you might encounter a database lock. This can block you.
Regards, Jan
 
raminaa niilian
Ranch Hand
Posts: 551
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can you please explain when we may face a lock which can block a connection?

thanks
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
One possible scenario is described here.
Regards, Jan
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle has published a document comparing their Oracle 10g database with IBM's DB2 database. Locking and blocking is one of the main topics there.
See section Transaction Processing.

Regards, Jan
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic