aspose file tools*
The moose likes JDBC and the fly likes ms sql server lock due to select while inserting Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ms sql server lock due to select while inserting" Watch "ms sql server lock due to select while inserting" New topic
Author

ms sql server lock due to select while inserting

soumya dash
Greenhorn

Joined: Jul 17, 2012
Posts: 14

I want to fetch some rows from a table while insertion is being done in that same table. while doing this operation,the table is being locked. How can i fix this?

kindly help me out. thnaks in advance.
sonu raj
Ranch Hand

Joined: Jul 31, 2012
Posts: 43

soumya dash wrote:I want to fetch some rows from a table while insertion is being done in that same table. while doing this operation,the table is being locked. How can i fix this?

kindly help me out. thnaks in advance.


Can you post the code here.
How you are doing it so that I can help
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ms sql server lock due to select while inserting