Unable to close SQLConnection while SQLQuery is active

Unable to close SQLConnection while SQLQuery is active

Postby amota » Mon 24 Aug 2009 11:03

In a multi-threaded environment I have a SQLQuery that sometimes takes too long to execute completely.
I cant find a way to close neither the SQLQuery nor the associated SQLConnection. The SQLConnection "close" method seems to wait until the SQLQuery is done completely.
Is there a way to do this? I mean, to kill the execution of the SQLQuery and close the associated SQLConnection?
amota
 
Posts: 1
Joined: Mon 24 Aug 2009 09:58

Postby Plash » Tue 25 Aug 2009 08:51

dbExpress components have no method to stop execution of a query.

You can try to kill the thread using the TerminateThread function.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for Oracle