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

Question

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)

Answer 1

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

Answer 2

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

• https://docs.oracle.com/javase/8/docs/api/java/sql/Types.html

So it would be :

DATE