How can I declare a date type parameter in JDBC request in Jmeter

1
votes

On executing my SP in Jmeter as below

  • QueryType:Callable Statement

    • Query:execute [QC].[usp_GetCallCounts] ?,?,?,?,?,?
    • Parameter Values: 33,'12-01-2016','12-15-2016',74861,0,Evaluator

    • Parameter Types: INTEGER,DATE,DATE,INTEGER,BIT,VARCHAR

      Request

      • I get this Response message: java.lang.IllegalArgumentException

    • Log file details are as follow:

    2018-01-12 18:50:04,887 INFO o.a.j.e.StandardJMeterEngine: Running the test! 2018-01-12 18:50:04,888 INFO o.a.j.s.SampleEvent: List of sample_variables: [] 2018-01-12 18:50:04,890 INFO o.a.j.g.u.JMeterMenuBar: setRunning(true, local) 2018-01-12 18:50:05,395 INFO o.a.j.e.StandardJMeterEngine: Starting ThreadGroup: 1 : Thread Group 2018-01-12 18:50:05,395 INFO o.a.j.e.StandardJMeterEngine: Starting 1 threads for group Thread Group. 2018-01-12 18:50:05,395 INFO o.a.j.e.StandardJMeterEngine: Thread will continue on error 2018-01-12 18:50:05,395 INFO o.a.j.t.ThreadGroup: Starting thread group... number=1 threads=1 ramp-up=1 perThread=1000.0 delayedStart=false 2018-01-12 18:50:05,396 INFO o.a.j.t.ThreadGroup: Started thread group number 1 2018-01-12 18:50:05,396 INFO o.a.j.e.StandardJMeterEngine: All thread groups have been started 2018-01-12 18:50:05,396 INFO o.a.j.t.JMeterThread: Thread started: Thread Group 1-1 2018-01-12 18:50:20,055 INFO o.a.j.t.JMeterThread: Thread is done: Thread Group 1-1 2018-01-12 18:50:20,055 INFO o.a.j.t.JMeterThread: Thread finished: Thread Group 1-1 2018-01-12 18:50:20,055 INFO o.a.j.e.StandardJMeterEngine: Notifying test listeners of end of test 2018-01-12 18:50:20,056 INFO o.a.j.g.u.JMeterMenuBar: setRunning(false, local)

2
sql-serverjdbcjmeter
can you show full error? can you show how you call it outside JMeter? - user7294900
Statementtype:Callable statement execute [QC].[usp_GetCallCounts] ?,?,?,?,?,? PArameter values: 33,'12/01/2016','12/15/2016',74861,0,'Evaluator' PArameter types: Integer,date,date,Integer,bit,varchar - Sarwat Hussain
SAmpler Result: Thread Name: Thread Group 1-1 Sample Start: 2018-01-10 18:24:24 PKT Load time: 17945 Connect Time: 17692 Latency: 0 Size in bytes: 10 Sent bytes:0 Headers size in bytes: 0 Body size in bytes: 10 Sample Count: 1 Error Count: 1 Data type ("text"|"bin"|""): text Response code: 000 Response message: java.lang.IllegalArgumentException Response: No MEssage - Sarwat Hussain
I meant in jmeter.log, and add your text to question by clicking edit below you question - user7294900
@user7294900 Can u plz guide how can I attach the jmeter.log file here? - Sarwat Hussain

2 Answers

2
votes

Encountered the same problem today, and after debugging and removing each parameter and value one by one we found out the problem is with the DATE parameter type.

So my advice would be to replace the DATE object with an TIMESTAMP object, since that's how we have done that, and it seems to work.

  • Parameter Types: INTEGER,TIMESTAMP,TIMESTAMP,INTEGER,BIT,VARCHAR
0
votes

As per reference doc you need to use UPPER Case names as per:

So it would be :

DATE