Wish jSQL - ability to set query timeout

tchart

Well-Known Member
Licensed User
Longtime User
As per title, could you consider adding the ability to set the timeout for SQL queries in jSQL

Background...

I have a jServer based data exploration tool that contains a lot of data, yesterday while testing I got this error which I hadnt seen before (this was after doing some load testing the other day which generated many new rows).

B4X:
java.sql.SQLException Query has executed more than 60000ms

While this case is somewhat unique, it would be great if we could adjust the timeout in code.

UPDATE: As per Erels comment below THREAD_LOCK_TIMEOUT <> QueryTimeout.

The GitHub project below has been updated to remove any changes to THREAD_LOCK_TIMEOUT but retains the addition of the setQueryTimeout function which is applied to any statement/preparestatment before query execution.
 
Last edited:

tchart

Well-Known Member
Licensed User
Longtime User
This message has nothing to do with THREAD_LOCK_TIMEOUT. Two different things.
Thanks Erel, yes I figured that out when the timeout wasnt respected.

I had already updated the post, the timeout needs to be set on the statement/preparedstatement.

It would still be useful to allow a user defined timeout for SQL statement execution.
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…