Hi,
I use NonBlocking option (true) to prevent blocking update by another user.
After my timeout (WaitExecuting) i call BreakExec. The problem is when i want to free my objet. The instruction wait for until the other who lock the record commit. Can you tell me what can i do?
My example :
pOraSQL->NonBlocking = true;
pOraSQL->Execute();
pOraSQL->WaitExecuting(5);
if(pOraSQL->Executing())
{
pOraSQL->BreakExec();
delete pOraSQL; //lock until transaction no committed by the other user.
throw Exception("LOCK");
}
The problem appear only when i update a record witch include a blob field (with a not null value)