You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@jmeter.apache.org by bu...@apache.org on 2018/11/21 11:28:31 UTC

[Bug 62934] New: Add compatibility for JDBC drivers that do not support QueryTimeout

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

            Bug ID: 62934
           Summary: Add compatibility for JDBC drivers that do not support
                    QueryTimeout
           Product: JMeter
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: Main
          Assignee: issues@jmeter.apache.org
          Reporter: jose@heitorprojects.com
  Target Milestone: JMETER_5.1

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

<br...@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

====================================================

<sh...@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

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 62934] Add compatibility for JDBC drivers that do not support QueryTimeout

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62934

Philippe Mouawad <p....@ubik-ingenierie.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |p.mouawad@ubik-ingenierie.c
                   |                            |om
             Status|NEW                         |RESOLVED
           Keywords|                            |FixedInTrunk
            Version|unspecified                 |2.13
         Resolution|---                         |FIXED

--- Comment #1 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.