Syntax error JMeter DB2

1
votes

Hy guys,

I'm trying to setup a DB2 (V11.1) stress test using Jmeter (3.1).

  1. I've downloaded JMeter and the jdbc driver.
  2. I've copied the jdbc driver into JMETER_DR/lib/db2jcc4.jar
  3. I've created a Thread Group with 10 users
  4. I've created the JDBC connection (disabling the Connection validation by Pool). Database URL: jdbc:db2://10.40.2.157:50000/TEST . JDBC Driver Class: com.ibm.db2.jcc.DB2Driver
  5. I've created the JDBC Request: Query Type: Select Statement. Query: select * from TEST.TESTTABLE;

When I run the test plan I got the error:

1489682525237,5,DB2 JDBC select,42601 -104,"com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;from TEST.TESTTABLE;END-OF-STATEMENT, DRIVER=4.16.53",DB2 Thread Group 1-1,text,false,,108,0,1,1,0,0,0

I've tested the same connection parameters and query using another Software (RazorSQL) and they are fine.

What it could be?

1
sqldatabasejdbcjmeterdb2

1 Answers

3
votes

You received the illegal symbol error.

Using semicolon after a single statement may produce this error.

Try to remove the semicolon ;