Data source does not respect timeout
-
- Posts: 53
- Joined: Mon May 30, 2022 7:35 pm
Data source does not respect timeout
Hello
We are carrying out some tests and notices that the query timeout field is not being respected, setting a value and even so the system does not respect the passed value.
Print and video follow.
expected action
https://www.stimulsoft.com/en/documenta ... ueries.htm
7 - The Query Timeout parameter is used to specify the execution time of a query, which means time during which the request will be executed. If the request timed out and the request failed, the user will see a message about this. The parameter value is indicated in seconds.
We are carrying out some tests and notices that the query timeout field is not being respected, setting a value and even so the system does not respect the passed value.
Print and video follow.
expected action
https://www.stimulsoft.com/en/documenta ... ueries.htm
7 - The Query Timeout parameter is used to specify the execution time of a query, which means time during which the request will be executed. If the request timed out and the request failed, the user will see a message about this. The parameter value is indicated in seconds.
- Attachments
-
- Print 0001.png (42.67 KiB) Viewed 9072 times
-
- 2023-06-30 16-29-45.mov
- (2.98 MiB) Downloaded 163 times
-
- Posts: 6337
- Joined: Tue Mar 20, 2018 5:34 am
Re: Data source does not respect timeout
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
-
- Posts: 53
- Joined: Mon May 30, 2022 7:35 pm
Re: Data source does not respect timeout
Awaiting.
Re: Data source does not respect timeout
Hello.
We pass this value (or if defined StiOptions.Dictionary.getQueryTimeout()) to java.sql.Statement & it processed with corresponding DB driver. We can't influence it
We pass this value (or if defined StiOptions.Dictionary.getQueryTimeout()) to java.sql.Statement & it processed with corresponding DB driver. We can't influence it
-
- Posts: 53
- Joined: Mon May 30, 2022 7:35 pm
Re: Data source does not respect timeout
Vadim.
I didn't understand.
The "StiOptions.Dictionary.getQueryTimeout" setting should not influence the query timeout in the report execution process in Stimulsoft.
Does this configuration not allow you to set a maximum value for the time a query can take to complete?
I didn't understand.
The "StiOptions.Dictionary.getQueryTimeout" setting should not influence the query timeout in the report execution process in Stimulsoft.
Does this configuration not allow you to set a maximum value for the time a query can take to complete?
Re: Data source does not respect timeout
Hello.
By defaults StiOptions.Dictionary.getQueryTimeout is 0, so QueryTimeout for every java.sql.Statement takes from SqlSource, default value is 3000 sec = 5 min,
if StiOptions.Dictionary.getQueryTimeout not equals 0 -> QueryTimeout for every java.sql.Statement takes from StiOptions.Dictionary.getQueryTimeout
By defaults StiOptions.Dictionary.getQueryTimeout is 0, so QueryTimeout for every java.sql.Statement takes from SqlSource, default value is 3000 sec = 5 min,
if StiOptions.Dictionary.getQueryTimeout not equals 0 -> QueryTimeout for every java.sql.Statement takes from StiOptions.Dictionary.getQueryTimeout
-
- Posts: 53
- Joined: Mon May 30, 2022 7:35 pm
Re: Data source does not respect timeout
Vadim.
So if you set StiOptions.Dictionary.getQueryTimeout to 5 min for example, all java.sql.Statement statements will have a time limit of 5 min to complete execution. If a statement exceeds this limit, it should be stopped.
However this is not happening.
So if you set StiOptions.Dictionary.getQueryTimeout to 5 min for example, all java.sql.Statement statements will have a time limit of 5 min to complete execution. If a statement exceeds this limit, it should be stopped.
However this is not happening.
Re: Data source does not respect timeout
Hello.
RightTecnologiaMV wrote: ↑Thu Jul 06, 2023 11:45 am So if you set StiOptions.Dictionary.getQueryTimeout to 5 min for example, all java.sql.Statement statements will have a time limit of 5 min to complete execution.
We pass timeout value to java.sql.Statement (requests to DB) & it processed with corresponding DB driver. We can't influence itTecnologiaMV wrote: ↑Thu Jul 06, 2023 11:45 am If a statement exceeds this limit, it should be stopped.
However this is not happening.