title: How to send dynamic parameter values in JDBC request of Jmeter
body: <p><strong>Requirement:</strong>
  1) I need to fetch values from an external dynamic file (Number of values may differ at each run)
  2) Use all those values in the JDBC Request to fetch data from DB using JMeter</p>
  
  <p><strong>Problem:</strong>
  1) I am able to fetch values from external file using bean shell
  2) But i am facing issues in sending those values to JDBC Request as it would need me to provide exact number of Parameter Types along with Parameter values and that too dynamically(as the number of values from external file differs)</p>
  
  <p><strong>DB Query:</strong>
   select a.acc_no,an.first_name,an.last_name,b.bi_no,b.due
    from accou a, bill_t b, NAME_T an
    where a.acc_no in(?) and a.poid=b.acc_obj and a.poid=an.obj;</p>
  
  <p><a href="https://i.stack.imgur.com/TGyQA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TGyQA.png" alt="JDBC Sampler used"></a></p>
  
  <p>If the number of parameter values is only one, we get the correct response.
  But if the number of parameter values are more than one(in this case, i have provided four values), we are getting error as 'number of arguments (4) and number of types (1) are not equal'.</p>
  
  <p>I will not be able to know how many parameter types i need to add to JDBC Request dynamically. If the number of Parameter Values and Parameter Types were constant, adding the same number of Parameter Types and corresponding values would have brought us the desired result.</p>
  
  <p><a href="https://i.stack.imgur.com/qInXf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qInXf.png" alt="JDBC Sampler with four parameter values"></a>
  <a href="https://i.stack.imgur.com/d2LS6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/d2LS6.png" alt="Response of JDBC Sampler with four values"></a></p>
  
  <p>So how can we send dynamically multiple parameter values to jdbc request in Jmeter?</p>