Thanks, I was able to achieve the same thing with 'userparameters'.
________________________________
From: sebb <seb...@gmail.com>
To: JMeter Users List <jmeter-user@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 <mhague94...@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-unsubscr...@jakarta.apache.org
For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
