TOraSQL no response when delete object after update blob

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Tony49
Posts: 21
Joined: Mon 26 Jan 2009 17:10

TOraSQL no response when delete object after update blob

Post by Tony49 » Tue 23 Aug 2011 14:47

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)

Tony49
Posts: 21
Joined: Mon 26 Jan 2009 17:10

Post by Tony49 » Fri 26 Aug 2011 12:08

Support team said me :

Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.

Post Reply