Re: Disable JDBC query timeout
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 <
philippe.moua...@gmail.com> 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 <
> j...@heitorprojects.com> 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 <
>> bruno.fs.antu...@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 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 < j...@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
>
>
>
> --
> Cordialement.
> Philippe Mouawad.
>
>
>
--
Cordialement.
Philippe Mouawad.
Re: Disable JDBC query timeout
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 <
j...@heitorprojects.com> 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 <
> bruno.fs.antu...@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 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 < j...@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
--
Cordialement.
Philippe Mouawad.
Re: Disable JDBC query timeout
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 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 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 < j...@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
Re: Disable JDBC query timeout
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 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 <
> j...@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
>
--
Bruno Antunes
Java Software Engineer
