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

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

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:

Correctly using sql query call

2008-07-16 Thread Jose Castro
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. Could someone please provide the correct format

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 ${col2)

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