| Author |
is there any condition that a connection stop until another connection commit?
|
raminaa niilian
Ranch Hand
Joined: Jul 14, 2005
Posts: 550
|
|
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: 2350
|
|
Yes, you might encounter a database lock. This can block you.
Regards, Jan
|
OCUP UML fundamental
ITIL foundation
|
|
raminaa niilian
Ranch Hand
Joined: Jul 14, 2005
Posts: 550
|
|
can you please explain when we may face a lock which can block a connection?
thanks
|
|
Jan Cumps
Bartender
Joined: Dec 20, 2006
Posts: 2350
|
|
One possible scenario is described here.
Regards, Jan
|
|
Jan Cumps
Bartender
Joined: Dec 20, 2006
Posts: 2350
|
|
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
|
|
 |
|
|
subject: is there any condition that a connection stop until another connection commit?
|
|
|
0
