terminate long query

Posts   
 
    
Peja
User
Posts: 2
Joined: 01-May-2008
# Posted on: 02-May-2008 00:06:55   

Is it possible to terminate query execution in case it is taking too long to retrieve the data?

I am using Oracle 10g as a backend and LLBL Gen v2.5.

Thanks.

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 02-May-2008 11:06:44   

I deleted your post in thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=3711

As it was irrelevant to the thread and was a duplicate of what is posted here. Please check the posting guidelines: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7722 Thanks

We will get back to you on your question soon.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39903
Joined: 17-Aug-2003
# Posted on: 02-May-2008 12:46:28   

No, that's not possible, other than terminating the connection by force (but that would require a different thread and it then has to access objects from another thread, not really best practises).

If you want to terminate a long operation, make sure the timeout is set properly, e.g. to 30 seconds (which is the default).

Frans Bouma | Lead developer LLBLGen Pro