timer between calls
If I have a sequence of SOAP calls using only one thread. How can I put a timer between each call of 2 seconds(for example) - To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
Re: how can i loop through csv
Thanks , that works. Now Aparently the system we are using is such a piece of crap that it needs time between each request. Is there something in jmeter(a sampler or something else) that I can add so that it waits for X amount of second before continuing?? Thank you On Thu, Nov 6, 2008 at 2:01 PM, sebb [EMAIL PROTECTED] wrote: On 06/11/2008, Jose Castro [EMAIL PROTECTED] wrote: If I declare a csv data set, how can I loop through the whole file?? What I want is declare csv data set while file not empty { call soap service } or something something like that I just want one instance running through the file Thread Group (forever) + CSV DataSet (stop on eof) + Sampler. - 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]
Is there a hold functionality on jmeter
I am using jmeter to test a communication switch. In some test I have to make some changes, then go to another system, check, and then continue the test. It will be nice to have a hold button sampler, when the test get to that point a popup appears with a continue button. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
regular expression getting corrupted
The scenario SOAP REQUEST -regular expression (new variable VAR1) SOAP REQUEST USING VAR1 SOAP REQUEST USING VAR1 HTTP REQUEST - regular expression( new variable VAR2) SOAP REQUEST USING VAR1 + VAR2.(PROBLEM VAR1 is NOW -1, VAR2 is ok) What could be happening??? Thank you - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: regular expression getting corrupted
I changed the test. when I need I do the other reg ex, I created a simple controller so now -REQUEST1 ---reg ex VAR1 -REQUEST2 -SIMPLE CONTROLLER REQUEST3 --REG EX VAR 2 REQUEST4(NOW VAR1 + VAR 2 ARE OK) The regular expressions are inside each request. So I dont understand why the conflict. The should only affect that particular request. I now they are different because all the other variables are ok. But now I am even more confuse because I call 3 more reg_ex. Each one on a different request. I they are all OK. the only one missing is the first one. I could send the jmx file On Thu, Oct 9, 2008 at 1:29 PM, sebb [EMAIL PROTECTED] wrote: On 09/10/2008, Jose Castro [EMAIL PROTECTED] wrote: The scenario SOAP REQUEST -regular expression (new variable VAR1) SOAP REQUEST USING VAR1 SOAP REQUEST USING VAR1 HTTP REQUEST - regular expression( new variable VAR2) SOAP REQUEST USING VAR1 + VAR2.(PROBLEM VAR1 is NOW -1, VAR2 is ok) What could be happening??? Try adding some Debug Samplers to the test. Are you sure the RE Extractor is only being applied to the appropriate samplers? Remember that Post-Processors apply to all samplers in scope. Are you sure that you are using different names? Remember that the RE uses the name as a prefix. 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]
Re: regular expression getting corrupted
Sorry, my mistake. Even with the simple controller, the first var1 is -1 On Thu, Oct 9, 2008 at 1:29 PM, sebb [EMAIL PROTECTED] wrote: On 09/10/2008, Jose Castro [EMAIL PROTECTED] wrote: The scenario SOAP REQUEST -regular expression (new variable VAR1) SOAP REQUEST USING VAR1 SOAP REQUEST USING VAR1 HTTP REQUEST - regular expression( new variable VAR2) SOAP REQUEST USING VAR1 + VAR2.(PROBLEM VAR1 is NOW -1, VAR2 is ok) What could be happening??? Try adding some Debug Samplers to the test. Are you sure the RE Extractor is only being applied to the appropriate samplers? Remember that Post-Processors apply to all samplers in scope. Are you sure that you are using different names? Remember that the RE uses the name as a prefix. 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]
Re: regular expression getting corrupted
Hello, IT WAS MY MISTAKE. I was overriding the first regular expresion with another when I did a copy-paste. Sorry for your trouble and thanks for your time. On Thu, Oct 9, 2008 at 2:30 PM, sebb [EMAIL PROTECTED] wrote: On 09/10/2008, Jose Castro [EMAIL PROTECTED] wrote: I changed the test. when I need I do the other reg ex, I created a simple controller so now -REQUEST1 ---reg ex VAR1 -REQUEST2 -SIMPLE CONTROLLER REQUEST3 --REG EX VAR 2 REQUEST4(NOW VAR1 + VAR 2 ARE OK) The regular expressions are inside each request. So I dont understand why the conflict. The should only affect that particular request. Yes, if they are added as children then they will only apply to the parent sampler. I now they are different because all the other variables are ok. But now I am even more confuse because I call 3 more reg_ex. Each one on a different request. I they are all OK. the only one missing is the first one. Is it possible that something else is using the same variable name? For example a counter or User Parameter - all variables share the same namespace. You could try renaming the first variable to something completely different. I could send the jmx file If renaming the variable does not work, then feel free to email me the JMX privately (please don't send it to the list). On Thu, Oct 9, 2008 at 1:29 PM, sebb [EMAIL PROTECTED] wrote: On 09/10/2008, Jose Castro [EMAIL PROTECTED] wrote: The scenario SOAP REQUEST -regular expression (new variable VAR1) SOAP REQUEST USING VAR1 SOAP REQUEST USING VAR1 HTTP REQUEST - regular expression( new variable VAR2) SOAP REQUEST USING VAR1 + VAR2.(PROBLEM VAR1 is NOW -1, VAR2 is ok) What could be happening??? Try adding some Debug Samplers to the test. Are you sure the RE Extractor is only being applied to the appropriate samplers? Remember that Post-Processors apply to all samplers in scope. Are you sure that you are using different names? Remember that the RE uses the name as a prefix. 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] - 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]
Extract data from http request result page
Hello, In order to support my testing I want to create web pages that return data from different sources. What I am thinking is that I should have a generic csv extractor, so that all my pages return data in csv format So for exmaple, I could have http://localhost/getnameinfo.php and that page will return a SINGLE LINE john doe,35,777888 SO THE QUESTION: What will be that generic csv regular expression? Thank you - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Can a soap request port number(and IP) be dynamic?
During our testing we have different environments. In our case we are just changing the port number. Is there a way to create the port number as a variable so I dont have to change every since request? Thank you - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JDBC test
Did you install the ojdbc14.jar on the lib directory?? On Tue, Sep 16, 2008 at 12:11 PM, Sean Tiley [EMAIL PROTECTED] wrote: Hello, I am trying to create a test that will connect to an oracle DB via jdbc and run a number of update and delete statements. I have created everything according to the instructions (http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html). There are entries in the JMeter log stating my test is running with no errors but nothing seems to be happening when I execute the test (I run a check and my records have not been updated / deleted). Anyone have any ideas? Thanks Sean - 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]
Re: JDBC test
I use a regular expression to retrieve the values regex inputVar (.*),(.*) $1$$2$ -1 0,0 my sql select col1,col2 from table after that use a beanshell with logn to display results I have to say that selecting the right variable was a pain for me. For example to display my data I have to logn this ${__logn('SUBSCRIBER' ${__V(inputVar_${counter}_g1)},OUT)} On Tue, Sep 16, 2008 at 2:01 PM, Sean Tiley [EMAIL PROTECTED] wrote: Hello, and thanks for the responses Yes, the jar file is in the right spot because if i remove it I see error messages in the log. I changed my query to a simple select but I do not know how to tell if it worked. I have a 'View Results Tree' listener but nothing shows up at all. - 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]
Function to write to file
Is there a function like StringToFile or a logn parameter to write a string to file? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Function to write to file
Is nice that there are workarounds. BUT, Can a function like this be added?? On Fri, Sep 5, 2008 at 10:58 AM, sebb [EMAIL PROTECTED] wrote: On 05/09/2008, Jose Castro [EMAIL PROTECTED] wrote: Is there a function like StringToFile or a logn parameter to write a string to file? No, but you could potentially use a BSF or BeanShell element to do this. Or one can use a Java Sampler with Simple Datawriter as a child to generate a sample to be written to a file. Also, one can define a list of variable names whose contents will be written to JTL files: http://jakarta.apache.org/jmeter/usermanual/listeners.html#sample_variables - 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]
error in intsum
GETTING THIS ERROR WHILE EXECUTING THIS SAMPLE BEANSHELL ${__intSum(${voip_counter},1,voip_counter)} voip_counter defined in user_parameters as 7873429150 Thread Name: Create Data QA19 1-1 Sample Start: 2008-09-04 11:44:03 VET Load time: 0 Latency: 0 Size in bytes: 0 Sample Count: 1 Error Count: 1 Response code: 500 Response message: java.lang.NumberFormatException: For input string: 7873429150 Response headers: - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
conuters not working inside loop
Please help before I go mad. I am using jmeter to create data. I have my counters that start from X number and they are suppose to go up by one. I have a loop controller that is going to be executed 4 times. Each time my counter is supposed to increment by one so that the next call gets a new number. BUT surprise!!!, the first loop work the second does not. When I check the request is because is using the same number as the first one. What little jmeter magic am I missing - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
increment counter
I am trying to create a variable with a value and the increment that value manually I tried both 1. create a counter with a starting value 2. create the variable in the user parameters i created a beanshell sampler and use this code ${__intSum(${iptv_counter},1,${iptv_counter})} ${__logn(VAR2=${iptv_counter},OUT)} ${__intSum(${iptv_counter},1,${iptv_counter})} ${__logn(VAR2=${iptv_counter},OUT)} ${__intSum(${iptv_counter},1,${iptv_counter})} ${__logn(VAR2=${iptv_counter},OUT)} I also tried ${__counter(FALSE,${iptv_counter})} expecting it will take the original value and increment one. I also tried ${__javaScript(${iptv_counter} = ${iptv_counter} +1)} Nothing work How can I increment the value of a variable by one?? Thank you - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: increment counter
Thank you. That worked On Wed, Sep 3, 2008 at 5:41 PM, sebb [EMAIL PROTECTED] wrote: On 03/09/2008, Jose Castro [EMAIL PROTECTED] wrote: I am trying to create a variable with a value and the increment that value manually I tried both 1. create a counter with a starting value 2. create the variable in the user parameters i created a beanshell sampler and use this code ${__intSum(${iptv_counter},1,${iptv_counter})} Try: ${__intSum(${iptv_counter},1,iptv_counter)} the last parameter is the variable name - not the value. ${__logn(VAR2=${iptv_counter},OUT)} ${__intSum(${iptv_counter},1,${iptv_counter})} ${__logn(VAR2=${iptv_counter},OUT)} ${__intSum(${iptv_counter},1,${iptv_counter})} ${__logn(VAR2=${iptv_counter},OUT)} I also tried ${__counter(FALSE,${iptv_counter})} expecting it will take the original value and increment one. I also tried ${__javaScript(${iptv_counter} = ${iptv_counter} +1)} Nothing work How can I increment the value of a variable by one?? 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]
Re: Webservices in JMeter
You put the xml request. Download a program like soap UI. This program generates the soap request for you. Copy-paste the generated request from soap ui , and put your values 2008/8/28 [EMAIL PROTECTED]: Hi , I want to create a test plan in JMeter with Webservices. The WSDL is the Google WSDL. http://api.google.com/GoogleSearch.wsdl. What must I put in the field Soap XML RPC Data. In the Manual I don't find anything. Cherrs Richard __ Smals sluit elke aansprakelijkheid uit in verband met de juistheid, de volledigheid of het tijdig toekomen van de informatie in deze e-mail. Aan deze e-mail kunnen geen rechten worden ontleend en deze e-mail houdt in geen geval een erkenning van welkdanige aansprakelijkheid in. Dit bericht is alleen bestemd voor de geadresseerde. Indien dit bericht niet voor u bestemd is, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Smals décline toute responsabilité quant à l'exactitude, à l'exhaustivité et au délai de transmission des informations contenues dans cet e-mail. Aucun droit ne peut être revendiqué sur cet e-mail et cet e-mail n'implique en aucun cas une reconnaissance de responsabilité, quelle qu'elle soit. Ce message s'adresse uniquement au destinataire. Si ce message ne vous est pas destiné, nous vous prions de nous le signaler immédiatement et de détruire le message. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Infinite While Controller
Thanks a lot for this answer,I was wondering how to do this. Now I have another question. How do I save ${__V(inputVar_${counter}_g1)} in a convenient ${MYVAR} so I can use ${MYVAR} everywhere else instead of the long format? Thank you On Fri, Aug 1, 2008 at 2:37 AM, Andrey Beznogov [EMAIL PROTECTED] wrote: Hi, quoting http://jakarta.apache.org/jmeter/usermanual/functions.html#what_can_do Note that variables cannot currently be nested; i.e ${Var${N}} does not work. The __V (variable) function (versions after 2.2) can be used to do this: ${__V(Var${N})}. In earlier JMeter versions one can use ${__BeanShell(vars.get(Var${N})}. Here is that functions description again http://jakarta.apache.org/jmeter/usermanual/functions.html#__V Regards, Andrey On Thu, Jul 31, 2008 at 10:59 PM, Ryan Miling [EMAIL PROTECTED] wrote: I am attempting to use a while controller with the following condition: ${__javaScript(${x${numX}}!=-1,dummy)} The condition includes a reference to the variable numX, which is a positive integer (e.g. 1,2,3,etc.), as well as the variable x${numX} that is also a positive integer (e.g. x1,x2,x3,etc.). These variables do in fact exist and are defined well. The issue is that the loop is never-ending and never evaluates to false (dummy = true). I expect the error is involving a variable referenced within a variable, but I am not sure what is the proper syntax to do so. I also checked related questions and I do not have any trailing spaces at the end of the condition or any variable. Ryan -- 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]
NEW FEATURE REQUEST
It will be nice if i jmeter includes a flag to disable samplers. I have list of 10(or more) soap request. Some time I would like to run the test with just 5 of those and then run it again with all 10. INstead of dragging things in and out of my test, it will be easier just to disable that part(check off) and run the test - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
NEW FEATURE REQUEST(save the workbench)
Sometimes when you are working It will be nice to save the workbench. So that you can put partial test over there , but still being able to run the test that actually work - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: SQL call returns header as the first line
Thank you, I added and if processor, if {$data} != COUNT NEXT STEP That worked On Mon, Jul 21, 2008 at 5:10 AM, Ronald Van de Kuil [EMAIL PROTECTED] wrote: Hello Jose, You probably get the result back as something as: COUNT 236 You could process this result with a BeanShell Post processor. Met Vriendelijke Groet, Ronald van de Kuil Stuck in the past somewhere in the future? NO WAY!!! sebb [EMAIL PROTECTED] 17-07-2008 23:57 Please respond to JMeter Users List jmeter-user@jakarta.apache.org To JMeter Users List jmeter-user@jakarta.apache.org cc Subject Re: SQL call returns header as the first line On 17/07/2008, Jose Castro [EMAIL PROTECTED] wrote: I am using a sql call to drive my test plan. It works, except that the sql call returns the column name as part of the returned data(in the first row). So My first test will fail(because it contains the column name instead of the data). Is there any way to fix it? Skip the first row? You don't say how you are using the data, so it's difficult to offer a sensible suggestion. I dont see any benefits in having that columns name returned as part of the data. That is how many SQL selects work. 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] Tenzij hierboven anders aangegeven: / Unless stated otherwise above: IBM Nederland B.V. Gevestigd te Amsterdam Inschrijving Handelsregister Amsterdam Nr. 33054214 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: add postfix to save response file
I wanted to use the __CsvRead() function which requires a filename so first I execute the query, save the results to a file and the loop using csvread On Fri, Jul 18, 2008 at 10:44 PM, sebb [EMAIL PROTECTED] wrote: JMeter does not care what filename extension is used, so I assumed you wanted to rename the file for use with some other program. In which case, using the OS to rename the file seems a reasonable approach. On 19/07/2008, Jose Castro [EMAIL PROTECTED] wrote: I did not know you can call command line functions within jmeter. On Fri, Jul 18, 2008 at 7:31 PM, sebb [EMAIL PROTECTED] wrote: On 18/07/2008, Jose Castro [EMAIL PROTECTED] wrote: and the file can easily be renamed. Please post code. That depends on the OS, but in Windows one can use: RENAME prefix1.unknown prefix1.txt The way I see it. Little enhancements like this make jmeter more useful to more people. It will definitively will be useful to me. And I am sure to many others. Because there is another way to rename a file does not mean that the functionality will not be used or appreciated by us Users. It also make jmeter a more powerful tool. Thank you On Fri, Jul 18, 2008 at 3:14 PM, sebb [EMAIL PROTECTED] wrote: On 18/07/2008, Jose Castro [EMAIL PROTECTED] wrote: Is there anyway to add a postfix to the save responses to a file. I am saving the response of a sql query and always get a .unknown Because the Content-Type is unknown. Where can I ask the developers for this new feature? Here or as a Bugzilla enhancement request. If there is already a prefix, why not a postfix? Because it was not considered necessary. The file type does not prevent the file from being used; and the file can easily be renamed. 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] - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JMeter tests stop abruptly
Is there anyway to add a postfix to the save responses to a file. I am saving the response of a sql query and always get a .unknown Where can I ask the developers for this new feature? If there is already a prefix, why not a postfix? Thank you - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
add postfix to save response file
Is there anyway to add a postfix to the save responses to a file. I am saving the response of a sql query and always get a .unknown Where can I ask the developers for this new feature? If there is already a prefix, why not a postfix? Thank you - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: add postfix to save response file
I did not know you can call command line functions within jmeter. On Fri, Jul 18, 2008 at 7:31 PM, sebb [EMAIL PROTECTED] wrote: On 18/07/2008, Jose Castro [EMAIL PROTECTED] wrote: and the file can easily be renamed. Please post code. That depends on the OS, but in Windows one can use: RENAME prefix1.unknown prefix1.txt The way I see it. Little enhancements like this make jmeter more useful to more people. It will definitively will be useful to me. And I am sure to many others. Because there is another way to rename a file does not mean that the functionality will not be used or appreciated by us Users. It also make jmeter a more powerful tool. Thank you On Fri, Jul 18, 2008 at 3:14 PM, sebb [EMAIL PROTECTED] wrote: On 18/07/2008, Jose Castro [EMAIL PROTECTED] wrote: Is there anyway to add a postfix to the save responses to a file. I am saving the response of a sql query and always get a .unknown Because the Content-Type is unknown. Where can I ask the developers for this new feature? Here or as a Bugzilla enhancement request. If there is already a prefix, why not a postfix? Because it was not considered necessary. The file type does not prevent the file from being used; and the file can easily be renamed. 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] - 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]
Re: Correctly using sql query call
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 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]
SQL call returns header as the first line
I am using a sql call to drive my test plan. It works, except that the sql call returns the column name as part of the returned data(in the first row). So My first test will fail(because it contains the column name instead of the data). Is there any way to fix it? I dont see any benefits in having that columns name returned as part of the data. Thank you - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Correctly using sql query call
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 to do this. Thank you - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Correctly using sql query call
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]