| Summary: | Add compatibility for JDBC drivers that do not support QueryTimeout | ||
|---|---|---|---|
| Product: | JMeter - Now in Github | Reporter: | Jose Heitor <jose> |
| Component: | Main | Assignee: | JMeter issues mailing list <issues> |
| Status: | RESOLVED FIXED | ||
| Severity: | enhancement | CC: | p.mouawad |
| Priority: | P2 | Keywords: | FixedInTrunk |
| Version: | 2.13 | ||
| Target Milestone: | JMETER_5.1 | ||
| Hardware: | All | ||
| OS: | All | ||
Author: pmouawad Date: Wed Nov 21 12:37:01 2018 New Revision: 1847095 URL: http://svn.apache.org/viewvc?rev=1847095&view=rev Log: Bug 62934 Add compatibility for JDBC drivers that do not support QueryTimeout Bugzilla Id: 62934 Modified: jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/AbstractJDBCTestElement.java jmeter/trunk/xdocs/changes.xml jmeter/trunk/xdocs/usermanual/component_reference.xml This issue has been migrated to GitHub: https://github.com/apache/jmeter/issues/4926 |
[QUESTION] 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. [ANSWERS] <bruno.fs.antunes@gmail.com> 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 ==================================================== <shettyd@gmail.com> 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