wood burning stoves 2.0*
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


Win a copy of Java 8 in Action this week in the Java 8 forum!
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: 550
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Second thread is blocked until the first thread commit the transaction, I can not understand why...
 
Similar Threads
Error connecting to database
I can't connect to DB
Unable to register Derby driver
connecting java application to JAVADB database
how to create dynamic installation or exe/setup file?