Re: Correctly using sql query call

2008-07-17 Thread sebb
On 17/07/2008, Jose Castro <[EMAIL PROTECTED]> wrote: > It will be nice if jmeter has an output that shows the whole key/value > pairs. That way I could see what variables I have to work. > The Debug Sampler shows these: http://jakarta.apache.org/jmeter/usermanual/component_reference.html#Debug_

Re: Correctly using sql query call

2008-07-17 Thread Andrey Beznogov
Hi, RegExp Controller is only generating those key/value pairs. How you use them is totally up to you. If you want to RegExp extract the data from your SQL query, and then use the extracted values together - all at once - to format a big SOAP query string... Well, its a bit more complicated then

Re: Correctly using sql query call

2008-07-17 Thread Jose Castro
It will be nice if jmeter has an output that shows the whole key/value pairs. That way I could see what variables I have to work. Now you got me confuse in something else. If I want to loop through each line of a text file OR loop through each row of data of a database. Is the for loop controller

Re: Correctly using sql query call

2008-07-17 Thread Andrey Beznogov
Hi, this is how it works. JMeter has a map (i.e. a list of key/value pairs) of variables, a separate one for every thread/loop. When you run the RegExp Extractor, you are basically adding more key/value pairs to that map. If, for example, you set the RegExp Extractor options like Reference Name

Re: Correctly using sql query call

2008-07-16 Thread Jose Castro
So what you are saying I should do something like Thread Group JDBC Reuqest select col1 || ',' || col2 from table -Reg Exp Ref Name= inputVar Refular Expresssion = (.*),(.*) Template = $1$$2$ Match No. = -1 Default V

Re: Correctly using sql query call

2008-07-16 Thread sebb
On 16/07/2008, Jose Castro <[EMAIL PROTECTED]> wrote: > I want to call a sql query and then have the data populate a soap request > > I would expect I could do something like > > THREAD GROUP > JDBC_REQUEST (select col1, col2 from table) > FOREACH CONTROLLER > ---SOAP REQUEST USING ${col1} and