Disable JDBC query timeout

[Heitor Projects - Jose]

How to disable JDBC request query timeout (for database drivers that do not support this feature...eg. Apache Ignite)? [Sampler result] Thread Name: Thread Group 1-1 Sample Start: 2018-11-20 14:41:38 SAST Load time: 761 Connect Time: 761 Latency: 0 Size in bytes: 31 Sent bytes:0 Headers size in bytes: 0 Body size in bytes: 31 Sample Count: 1 Error Count: 1 Data type ("text"|"bin"|""): text Response code: null 0 Response message: java.sql.SQLFeatureNotSupportedException: Query timeout is not supported. Thanks, Jose

[Deepak Shetty]

Hi
as far as I can tell there isn't a way to do this (Short of downloading and
modifying the source code)- You will have to raise an enhancmeent for
JMeter (https://jmeter.apache.org/issues.html )

AbstractJDBCTestElement.java in source code can be modified if you want to
use -1 or equivalent to represent no timeout and not call the timeout method

Can you also post your complete stack trace top verify ?

regards
deepak

On Tue, Nov 20, 2018 at 4:57 AM Heitor Projects - Jose <

Post by Heitor Projects - Jose
How to disable JDBC request query timeout (for database drivers that do
not support this feature...eg. Apache Ignite)? [Sampler result] Thread
761 Connect Time: 761 Latency: 0 Size in bytes: 31 Sent bytes:0 Headers
size in bytes: 0 Body size in bytes: 31 Sample Count: 1 Error Count: 1 Data
java.sql.SQLFeatureNotSupportedException: Query timeout is not supported.
Thanks, Jose

[Bruno Antunes]

Analysing source code on JMeter, (
http://svn.apache.org/viewvc/jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/AbstractJDBCTestElement.java?view=markup)
, the timeout is always passed to the Driver.

As commented we should fill an issue in order to request that feature. I
don't see we should not not have that kind of configuration; not setting
and using defaults from drivers should be valid. In arguments for timeout
value should be >= 0; the 0 means there is no limit:
https://docs.oracle.com/javase/10/docs/api/java/sql/Statement.html#setQueryTimeout(int)

In source code on Apache Ignite JDBC Driver (
https://apacheignite-sql.readme.io/docs/jdbc-driver) we can see that
setting a query timeout not supported:
https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/internal/jdbc2/JdbcStatement.java

Post by Deepak Shetty
Hi
as far as I can tell there isn't a way to do this (Short of downloading and
modifying the source code)- You will have to raise an enhancmeent for
JMeter (https://jmeter.apache.org/issues.html )
AbstractJDBCTestElement.java in source code can be modified if you want to
use -1 or equivalent to represent no timeout and not call the timeout method
Can you also post your complete stack trace top verify ?
regards
deepak
On Tue, Nov 20, 2018 at 4:57 AM Heitor Projects - Jose <

Post by Heitor Projects - Jose
How to disable JDBC request query timeout (for database drivers that do
not support this feature...eg. Apache Ignite)? [Sampler result] Thread
761 Connect Time: 761 Latency: 0 Size in bytes: 31 Sent bytes:0 Headers
size in bytes: 0 Body size in bytes: 31 Sample Count: 1 Error Count: 1

Data

Post by Heitor Projects - Jose
java.sql.SQLFeatureNotSupportedException: Query timeout is not supported.
Thanks, Jose

[Heitor Projects - Jose]

Thanks for all the help and advice, everyone. I don't know how to file a feature-request for jMeter, so will ask if a contributing developer would kindly do so. The change seems very simple to implement, so I will download the jMeter source, make the change and (hopefully) be able to create a custom build for my own use in the interim. Many thanks, Jose Heitor ---- On Wed, 21 Nov 2018 12:42:25 +0200 Bruno Antunes <***@gmail.com> wrote ---- Analysing source code on JMeter, (http://svn.apache.org/viewvc/jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/AbstractJDBCTestElement.java?view=markup) , the timeout is always passed to the Driver. As commented we should fill an issue in order to request that feature. I don't see we should not not have that kind of configuration; not setting and using defaults from drivers should be valid. In arguments for  timeout value should be >= 0; the 0 means there is no limit: https://docs.oracle.com/javase/10/docs/api/java/sql/Statement.html#setQueryTimeout(int) In source code on Apache Ignite JDBC Driver (https://apacheignite-sql.readme.io/docs/jdbc-driver) we can see that setting a query timeout not supported: https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/internal/jdbc2/JdbcStatement.java On Tue, 20 Nov 2018 at 17:54, Deepak Shetty <***@gmail.com> wrote: -- Bruno Antunes Java Software Engineer Hi as far as I can tell there isn't a way to do this (Short of downloading and modifying the source code)- You will have to raise an enhancmeent  for JMeter (https://jmeter.apache.org/issues.html ) AbstractJDBCTestElement.java in source code can be modified if you want to use -1 or equivalent to represent no timeout and not call the timeout method Can you also post your complete stack trace top verify ? regards deepak On Tue, Nov 20, 2018 at 4:57 AM Heitor Projects - Jose < ***@heitorprojects.com> wrote: > How to disable JDBC request query timeout (for database drivers that do > not support this feature...eg. Apache Ignite)? [Sampler result] Thread > Name: Thread Group 1-1 Sample Start: 2018-11-20 14:41:38 SAST Load time: > 761 Connect Time: 761 Latency: 0 Size in bytes: 31 Sent bytes:0 Headers > size in bytes: 0 Body size in bytes: 31 Sample Count: 1 Error Count: 1 Data > type ("text"|"bin"|""): text Response code: null 0 Response message: > java.sql.SQLFeatureNotSupportedException: Query timeout is not supported. > Thanks, Jose

[Philippe Mouawad]

Hello,
You can follow this:

- https://jmeter.apache.org/issues.html

If not clear, let us know what needs to be improved.
Thanks
Regards

On Wed, Nov 21, 2018 at 12:06 PM Heitor Projects - Jose <

Post by Heitor Projects - Jose
Thanks for all the help and advice, everyone. I don't know how to file a
feature-request for jMeter, so will ask if a contributing developer would
kindly do so. The change seems very simple to implement, so I will download
the jMeter source, make the change and (hopefully) be able to create a
custom build for my own use in the interim. Many thanks, Jose Heitor ----
On Wed, 21 Nov 2018 12:42:25 +0200 Bruno Antunes <
http://svn.apache.org/viewvc/jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/AbstractJDBCTestElement.java?view=markup)
, the timeout is always passed to the Driver. As commented we should fill
an issue in order to request that feature. I don't see we should not not
have that kind of configuration; not setting and using defaults from
drivers should be valid. In arguments for timeout value should be >= 0;
https://docs.oracle.com/javase/10/docs/api/java/sql/Statement.html#setQueryTimeout(int)
In source code on Apache Ignite JDBC Driver (
https://apacheignite-sql.readme.io/docs/jdbc-driver) we can see that
https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/internal/jdbc2/JdbcStatement.java
Bruno Antunes Java Software Engineer Hi as far as I can tell there isn't a
way to do this (Short of downloading and modifying the source code)- You
will have to raise an enhancmeent for JMeter (
https://jmeter.apache.org/issues.html ) AbstractJDBCTestElement.java in
source code can be modified if you want to use -1 or equivalent to
represent no timeout and not call the timeout method Can you also post your
complete stack trace top verify ? regards deepak On Tue, Nov 20, 2018 at
disable JDBC request query timeout (for database drivers that do > not
Thread Group 1-1 Sample Start: 2018-11-20 14:41:38 SAST Load time: > 761
Connect Time: 761 Latency: 0 Size in bytes: 31 Sent bytes:0 Headers > size
in bytes: 0 Body size in bytes: 31 Sample Count: 1 Error Count: 1 Data >
type ("text"|"bin"|""): text Response code: null 0 Response message: >
java.sql.SQLFeatureNotSupportedException: Query timeout is not supported. >
Thanks, Jose

[Philippe Mouawad]

Hello,
Issue was created by you:

- https://bz.apache.org/bugzilla/show_bug.cgi?id=62934

It is fixed in nightly build that you can try tomorrow.
Alternatively, you can also try jenkins build once generation is finished:

- https://builds.apache.org/job/JMeter-trunk/

To avoid setQueryTimeout being called, set value to -1.


Regards
Philippe M.
Co-Author of Master JMeter
https://leanpub.com/master-jmeter-from-load-test-to-devops/



On Wed, Nov 21, 2018 at 12:08 PM Philippe Mouawad <

Post by Philippe Mouawad
Hello,
- https://jmeter.apache.org/issues.html
If not clear, let us know what needs to be improved.
Thanks
Regards
On Wed, Nov 21, 2018 at 12:06 PM Heitor Projects - Jose <

Post by Heitor Projects - Jose
Thanks for all the help and advice, everyone. I don't know how to file a
feature-request for jMeter, so will ask if a contributing developer would
kindly do so. The change seems very simple to implement, so I will download
the jMeter source, make the change and (hopefully) be able to create a
custom build for my own use in the interim. Many thanks, Jose Heitor ----
On Wed, 21 Nov 2018 12:42:25 +0200 Bruno Antunes <
http://svn.apache.org/viewvc/jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/AbstractJDBCTestElement.java?view=markup)
, the timeout is always passed to the Driver. As commented we should fill
an issue in order to request that feature. I don't see we should not not
have that kind of configuration; not setting and using defaults from
drivers should be valid. In arguments for timeout value should be >= 0;
https://docs.oracle.com/javase/10/docs/api/java/sql/Statement.html#setQueryTimeout(int)
In source code on Apache Ignite JDBC Driver (
https://apacheignite-sql.readme.io/docs/jdbc-driver) we can see that
https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/internal/jdbc2/JdbcStatement.java
-- Bruno Antunes Java Software Engineer Hi as far as I can tell there isn't
a way to do this (Short of downloading and modifying the source code)- You
will have to raise an enhancmeent for JMeter (
https://jmeter.apache.org/issues.html ) AbstractJDBCTestElement.java in
source code can be modified if you want to use -1 or equivalent to
represent no timeout and not call the timeout method Can you also post your
complete stack trace top verify ? regards deepak On Tue, Nov 20, 2018 at
to disable JDBC request query timeout (for database drivers that do > not
Thread Group 1-1 Sample Start: 2018-11-20 14:41:38 SAST Load time: > 761
Connect Time: 761 Latency: 0 Size in bytes: 31 Sent bytes:0 Headers > size
in bytes: 0 Body size in bytes: 31 Sample Count: 1 Error Count: 1 Data >
type ("text"|"bin"|""): text Response code: null 0 Response message: >
java.sql.SQLFeatureNotSupportedException: Query timeout is not supported. >
Thanks, Jose

--
Cordialement.
Philippe Mouawad.