This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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.