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.