TORAQuery.Executing doesn't become false if it's in a thread

salvatore · Post by **salvatore** » Thu 08 Oct 2009 11:10

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

Plash · Post by **Plash** » Fri 09 Oct 2009 08:12

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.

salvatore · Post by **salvatore** » Fri 09 Oct 2009 09:47

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

Plash · Post by **Plash** » Mon 12 Oct 2009 07:54

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.