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).
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.
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: