Informix 7.2 ESQL/C Query Cancel Question
Posted in 1997
Hey, Readers, My DB is Informix-OnLine Version 7.20.TE1 for NT4.0. ( It's been up 1 day 6:53:09 :) ) My client is also on NT 4.0. Esql7.20.TD1 I have this situation: Application 1 puts an exclusive lock on table A Application 2 sets its lock mode to wait. In this case, no time-out period is specified. App 2 issues a select against table A, on which App 1 currently has an exclusive lock. App 2 has the capability to cancel SQL requests. After several seconds, it "asks" the user if he or she would like to cancel the request. The user indicates yes, but the app still waits. ( The desired behavior is for app 2 to stop waiting ) After several minutes, app 1 releases its exclusive lock on table A. App 2 now wakes up and displays the results of the select. The question is: Does it sound reasonable that, since its mode has been set to wait, app 2 would continue to wait ( block ), even after there was an attempted SQL query cancellation? TIA.