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_Sampler > 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 the one to > use??? Now, it seem to me that the forloop is too loop only on , for > example, the results of a regular expression found in ONE line or ONE > row and NOT to loop through each line. > > > > On Thu, Jul 17, 2008 at 3:45 AM, Andrey Beznogov <[EMAIL PROTECTED]> wrote: > > 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 = refName > > Regular Expression = (.*),(.*) > > Template = My request is $1$ and $2$ > > Match No. = -1 > > Default Value = ERROR > > > > and it matches, what happens is some key/value pairs are added to the > > map. Among others, the variables "refName_X" (X is the match number) > > are set to the the strings as generated by the template. > > > > Read more about it in the manual > > > http://jakarta.apache.org/jmeter/usermanual/component_reference.html#Regular_Expression_Extractor > > > > Lets say that for some thread your RegExp matched two strings, "A,B" > > and "C,D". Then (among others) you get two key/value pairs added to > > the JMeter variables map: ("refName_1","My request is A and B") and > > ("refName_2","My request is C and D"). "refName_3" etc are null. Those > > generated strings depend on how you set the Template. > > > > Then you can use those new key/value pairs in the ForEach Controller. > > If you set its options like this > > > > Input variable prefix = refName > > Output variable = outputVar > > Use Separator = yes > > > > It will keep setting the value of "outputVar" to the value "refName_X" > > (X = 1,2 ... is the loop counter) and running whats inside the > > controller until it encounters a "refName_X" which is not initialized > > (is null). > > > > In our example with two matches such ForeEach Controller will: > > 1) check the value of "refName_1", see that its not null, set the > > "outputVar" value to the value of "refName_1" ("My request is A and > > B") and run whats inside the controller > > 2) check the value of "refName_2", see that its not null, set the > > "outputVar" value to the value of "refName_2" ("My request is C and > > D") and run whats inside the controller > > 3) check the value of "refName_3", see that it is indeed null and stop the > loop > > > > Then just use the value of outputVar (reference it like ${outputVar}) > > inside the ForEach controller to customize your elements. > > > > I am not 100% sure about all the details and implementation, but it > > seems to work as described above. > > > > I hope that helps. > > > > Regards, > > Andrey > > > > On Thu, Jul 17, 2008 at 7:40 AM, Jose Castro <[EMAIL PROTECTED]> wrote: > >> 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 Value = 0,0 > >> FOR EACH CONTROLLER > >> INPUT VAR = InputVar > >> OUTPUTVAR = OutputVar > >> > >> > >> And I am lost again. I dont see how to get the data once I am in the > foreach. > >> Do I use user parameters? How do I get those 2 columns?? > >> > >> Thank you > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> On Wed, Jul 16, 2008 at 5:20 PM, sebb <[EMAIL PROTECTED]> wrote: > >>> 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 ${col2) > >>>> > >>>> > >>>> But no luck. > >>>> > >>> > >>> The SQL Sampler does not save results in variables. > >>> > >>> You can extract the values from the response data using the Regex > >>> Post-Processor. > >>> > >>>> Could someone please provide the correct format to do this. > >>>> > >>>> Thank you > >>>> > >>>> --------------------------------------------------------------------- > >>>> To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>> For additional commands, e-mail: [EMAIL PROTECTED] > >>>> > >>>> > >>> > >>> --------------------------------------------------------------------- > >>> To unsubscribe, e-mail: [EMAIL PROTECTED] > >>> For additional commands, e-mail: [EMAIL PROTECTED] > >>> > >>> > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > > > > > > > > -- > > diem perdidi > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]