I have webservice which updates the customer details I 'am using sybase 8 as as backend and .net as platform for developing webservice. while testing in a multiuser environment I got some locked table error.
I tried setting the isolation level for database option.
For this, I have tried doing...
when there are update/Insert/Delete actions necessary,
immediately after starting the transaction,I locked the tables involved (in sequence to avoid deadlock).
if a lock fails, I'am retrying it after x milliseconds
I a'm getting some serialization failure:deadlock detected error.
It would be a great help if somebody comes with solution to handle this concurrency.