Devart Forums

Hi,

I'm building a server application and every query running in his own thread. I need to "stop" the execution of a specified query inside a specific "User session".

I have a problem with NonBlocking = true inside a thread.

MyORAQuery.executing doesn't not become false, althoug if the same code in a non multithreaded application work well.

There is some known problems with this aproach?


Thanks.

Salvatore

NonBlocking is not an appropriate mode for using from a thread. If you execute you queries from a thread, you should set NonBlocking to False.

Thanks for your reply.

So, my question become: "How can I stop a query if that query is running inside a thread if breackexec doesn't work?"

Salvatore

Some Oracle operations are not stopped by the BreakExec method. In this case the only way to stop your query is to kill the thread.