Disable JDBC query timeout
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
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
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
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
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.