[Bug 60635] New: JDBC DB2 Connectivity : Query gives an error

[bu...@apache.org]

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

            Bug ID: 60635
           Summary: JDBC DB2 Connectivity : Query gives an error
           Product: JMeter
           Version: 3.0
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Main
          Assignee: issues@jmeter.apache.org
          Reporter: rene59.uthrn@gmail.com
  Target Milestone: ---

Created attachment 34669
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34669&action=edit
DB2 not working for jmeter version 3

Having created attached jmx file in version 2.13 and working as expected, this
file loading in version 3.0 and 3.1 gives an error.
The jmeter.log shows no error, so JDBC DB2 driver seems to be accepted.
Executing the query as in attached jmx file gives following error :

Thread Name: JDBCTest 1-1
Sample Start: 2017-01-24 16:31:57 CET
Load time: 235
Connect Time: 0
Latency: 235
Size in bytes: 151
Headers size in bytes: 0
Body size in bytes: 151
Sample Count: 1
Error Count: 1
Data type ("text"|"bin"|""): text
Response code: null 0
Response message: java.sql.SQLException: Cannot create
PoolableConnectionFactory (DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,
SQLERRMC=END-OF-STATEMENT;Select 1;<table_expr>, DRIVER=3.65.131)

Response headers:


SampleResult fields:
ContentType: text/plain
DataEncoding: UTF-8

The SAMPLE database is the database as included in the DB2 install

version DB2 : 10.1 FP5
on Windows 7 and Windows Server 2008

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

[Bug 60635] JDBC DB2 Connectivity : Query gives an error

[bu...@apache.org]

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

Felix Schumacher <fe...@internetallee.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All
             Status|NEW                         |RESOLVED
         Resolution|---                         |INVALID

--- Comment #1 from Felix Schumacher <fe...@internetallee.de> ---
Bugzilla is not a support forum.

You have to adapt the validation query to your db. For db2 it might be "select
1 from sysibm.sysdummy1" (found on
http://stackoverflow.com/questions/10684244/dbcp-validationquery-for-different-databases)

With JMeter 3.1 you can leave the field for the validation query empty. The
jdbc method "isValid()" will be used for the validation.

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