I want to update 100 records in a table ,I am using batchUpdate but it is giving following error
Lock wait timeout exceeded; try restarting transaction
I solved the problem.
As I was trying to update 100 records at a time...it is updating successfully
close connection wherver required,make sure that while updating records there shd be only one active connection .
If if more than active conjection ,then this type of error will occur.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com