Re: CSV Data Set Config doesn't work with jdbc request

[Maya Hague <mh...@yahoo.com>]

Thanks, I was able to achieve the same thing with 'userparameters'.




________________________________
From: sebb <se...@gmail.com>
To: JMeter Users List <jm...@jakarta.apache.org>
Sent: Sat, February 27, 2010 5:17:19 AM
Subject: Re: CSV Data Set Config doesn't work with jdbc request

On 27/02/2010, Maya Hague <mh...@yahoo.com> wrote:
> Hi,
>  My test plan is as follows
>
>  Test Plan
>    thread
>      Jdbc Connection Config
>      jdbc request
>      view results tree
>      CSV Data Set Config
>
>  My query is an update prepared statement calling a stored procedure which works fine with hard coded value,but when I pass the csv file it does not pass values from the file to the parameter. I'm using the jtds sql driver.
>
>  My file is in c:\words.csv
>  contents of the file
>
>  document
>  system
>  test
>
>  my jdbc request has
>
>  SET @SEARCH_TERM ="${words}"
>
>  call the stored procedure with
>  execute storedprocedure1 @SEARCH_TERM
>
>  parameter values: ${words}
>  parameter type: VARCHAR
>
>  I see that the request is being sent as ${words} not what is in the files c:\words.csv. NO errors in the jmeter.log. What could I be doing wrong????

http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV_Data_Set_Config

Read the box highlighted in colour.

>  Thanks
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org