Wish jSQL - ability to set query timeout

[tchart]

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

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.

 

[tchart]

My modified library is here;

GitHub - ope-nz/jSQL_with_timeout: Fork of https://github.com/AnywhereSoftware/B4J/tree/master/Libs_SQL

Fork of https://github.com/AnywhereSoftware/B4J/tree/master/Libs_SQL - ope-nz/jSQL_with_timeout

github.com

 

[Erel]

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

This message has nothing to do with THREAD_LOCK_TIMEOUT. Two different things.

 

[tchart]

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.