Print Thread
How to define a timeout to a TOracleQuery?
#65359 02/06/24 02:20 AM
Joined: Feb 2024
Posts: 1
J
jevelio Offline OP
Member
OP Offline
Member
J
Joined: Feb 2024
Posts: 1
It is required to define a timeout on database queries to continue in case the database does not respond.

I didn't find any property in the TOracleQuery object that could help me


Thanks for the help

Re: How to define a timeout to a TOracleQuery?
jevelio #65364 02/06/24 09:52 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
The TOracleQuery or TOracleSession do indeed not have any property or method for this. You would need to run the query in a background thread and call TOracleSession.BreakExecution from the main thread if the query needs to be cancelled.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.082s Queries: 14 (0.014s) Memory: 2.4964 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-27 21:34:04 UTC
Valid HTML 5 and Valid CSS