Disable JDBC query timeout

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

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
Reply | Threaded
Open this post in threaded view
|

Re: Disable JDBC query timeout

shettyd
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 <
[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: Disable JDBC query timeout

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


On Tue, 20 Nov 2018 at 17:54, Deepak Shetty <[hidden email]> wrote:

> 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 <
> [hidden email]> 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
>


--
Bruno Antunes
Java Software Engineer
Reply | Threaded
Open this post in threaded view
|

Re: Disable JDBC query timeout

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 <[hidden email]> 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 <[hidden email]> 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 < [hidden email]> 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
pmd
Reply | Threaded
Open this post in threaded view
|

Re: Disable JDBC query timeout

pmd
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 <
[hidden email]> wrote:

> 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 <
> [hidden email]> 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 <[hidden email]> 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 < [hidden email]> 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



--
Cordialement.
Philippe Mouawad.
pmd
Reply | Threaded
Open this post in threaded view
|

Re: Disable JDBC query timeout

pmd
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 <
[hidden email]> wrote:

> 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 <
> [hidden email]> wrote:
>
>> 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 <
>> [hidden email]> 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 <[hidden email]> 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 < [hidden email]> 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
>
>
>
> --
> Cordialement.
> Philippe Mouawad.
>
>
>

--
Cordialement.
Philippe Mouawad.