aspose file tools*
The moose likes JDBC and the fly likes is there any condition that a connection stop until another connection commit? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "is there any condition that a connection stop until another connection commit?" Watch "is there any condition that a connection stop until another connection commit?" New topic
Author

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

raminaa niilian
Ranch Hand

Joined: Jul 14, 2005
Posts: 551
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

Joined: Dec 20, 2006
Posts: 2503
    
    8

Yes, you might encounter a database lock. This can block you.
Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
raminaa niilian
Ranch Hand

Joined: Jul 14, 2005
Posts: 551
can you please explain when we may face a lock which can block a connection?

thanks
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2503
    
    8

One possible scenario is described here.
Regards, Jan
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2503
    
    8

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
 
Consider Paul's rocket mass heater.
 
subject: is there any condition that a connection stop until another connection commit?