On 09/01/07, Alexander Wallace <[EMAIL PROTECTED]> wrote:
Thanks a lot for the quick response!
Please see below.
>
> Why not just use CSV Dataset to pass in the query details?
>
> The file can be as big as you like, and you can use the variables in
> the JDBC sampler.
>
> The JDBC Sampler allows the Query Type to be a variable, so you can
> even mix SELECTs and UPDATEs [for DELETE use UPDATE].
This would mean that I have 1 jdbc sampler and each iteration changes
the query for the sampler right? I gave this a bit of thought before
sending the email, but how can I simulate multiple threads this way?
And if each thread needs to vary a little bit of the query (say the
CustomerId) how would this work?
Just use multiple threads - each thread will get the next line from the file.
To vary the SQL, use a variable to hold the varying part, and
reference it in the JDBC sampler using the normal ${VARNAME} syntax.
Remember to quote the variable if it is a string - see:
http://jakarta.apache.org/jmeter/usermanual/functions.html#Where
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
