Wish jSQL - ability to set query timeout

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.

My modified library is here;

tchart said:

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

Click to expand...

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

Erel said:

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

Click to expand...

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.