Devart Forums

Hello,

I'm using Borland Delphi 2006 and ODAC 6.20 (I tried ODAC 5.80).

I created Threads to run SQL commands, because the application needs to dialog with the second database even if the first wait the answer from the database.

I use ExecSQL procedure from TCustomOraQuery to execute the queries.

It's works, but when the database is in Lock/deadlock mode, the ExecSQL wait.
If there are a unlock, the command is executed and the thread normaly terminated.
If there are a network problem, the thread still run infinitly.

If I kill the Thread like "TerminateThread(ThreadOracle.Handle, 0);", The thread is terminated but when I recreate the Thread (after the unlock of the database) the ExecSQL still waiting...
Perhaps there are a link not terminated with the ODAC.

What's the solution to terminate the Thread properly or detect and stop ExecSQL ?

Thank you in advance,
Gaby

Try to call the BreakExec method of TOraQuery to stop the query execution.

Thank you for the answer.

I tried a BreakExec but it seems did nothing.
I tried a BreakExec and kill the thread but it's the same, the ExecSQL still waiting (database is unlocked)...

Gaby.

There is no other way to stop execution except the BreakExec method.

Hello,

There are NonBlocking mode, but if NonBlocking := true ExecSQL don't block.
Is it possible to read ExecSQL state, and perhaps kill ExecSQL using BreakExec if ExecSQL still executing? (.Executing return allways True)

Thank you in advance,
Gaby

In NonBlocking mode a query execution can be stopped by calling the BreakExec method. But if the BreakExec method cannot stop the execution when you have started it from a separate thread, this method also will not help in NonBlocking mode.