aspose file tools*
The moose likes JDBC and the fly likes Second thread is blocked until the first thread commit the transaction, I can not understand why... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Second thread is blocked until the first thread commit the transaction, I can not understand why..." Watch "Second thread is blocked until the first thread commit the transaction, I can not understand why..." New topic
Author

Second thread is blocked until the first thread commit the transaction, I can not understand why...

raminaa niilian
Ranch Hand

Joined: Jul 14, 2005
Posts: 551
Hi
I am learning transaction and isolation levels. I tried to use read_committed in one thread and then in another thread insert some data into a table. the reader thread is blocked and waits until the first thread commit the transaction to complete the select statement. What I can not understand is: shouldn't the second thread only read what is already committed instead of waiting until the inserting thread finishes its job?

Inserted thread code:



reader thread code:


also I tried and execute these code in two different application and the result is the same. The reader application waits for almost 20 seconds before it read the data.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Second thread is blocked until the first thread commit the transaction, I can not understand why...