Hi guys,
First I had the 243 problem (Couldn't not position within a table(table name)) first. then I changed my isolation level to "READ_UNCOMMITTED", but now I got stuck on the error 245. when i looked at the lock logs, the other process was getting IX,X table/page/row locks on the table my process was trying to access, plus the X locks on the primary key and foreign keys.
Any suggestion?
Thanks very much!
Zz

Hi,

Please run before SET LOCK MODE TO [WAIT|| n seconds], next run sql.

Gustavo.

Thanks Gustavo.
Actually I did set the lock mode to -1(which is wait until the lock releases). Everything worked on my test(i did a lock table in exclusive mode) and my own application/proc waited until I issued the unlock command. However, as soon as the other app runs(the test team and I had the test case of running two apps at the same time), I watched the locks and the locks showed indexes being locked as well(along with some system locks that I am not familar with), then my app will get this 245 error Could not position within a file via index). of course, after 3 mins when the other app is done, my app worked as usual.
Any insight is highly appreciated! I have been stuck with this issue for a week.
Zhongyu