Yes it works. I tried this "Variable Names" parameter but when I checked value I forgot to append '_1' (or '_n' when n is the row number) at the end of the variable name.
2009/9/8 sebb <seb...@gmail.com>: > On 08/09/2009, Jakub Białek <ragno...@gmail.com> wrote: >> First: 'Variable Name' in JDBC Connection Configuration is not name of >> the variable where result will be bind but it is the name of pool, >> similar is in the JDBC Request, so both name should be the same for >> example mypool. >> Second: JDBC Request must not be child of the JDBC Configuration >> Configuration. It is possible to do so but I don't know why it is >> avaible. JDBC Request should below JDBC Connection Configuration but >> be on the same level. >> Third: I have no idea how to extract variable from result returned by >> the JDBC Request. > > JMeter 2.3.4 allows one to save values as variables: > > http://jakarta.apache.org/jmeter/usermanual/component_reference.html#JDBC_Request > > See parameter "Variable Names". > >> I tried Regular Expression Extractor and this field >> Variable names on the bottom of the JDBC Request view but their dont't >> work. Do you consider to use data from CSV file instead of db >> directly? It will be faster and easer :). >> >> Remeber to put mysql driver library to jmeter lib directory. >> >> >> Best regards, >> Jakub >> >> >> 2009/9/8 dilantha <dilantha.tyr...@gmail.com>: >> > >> > Hi, >> > >> > Thanks a lot..Thak works..I didn't add ${test_id}. That's why it didn't >> > work..Thank again..If you can please do me a one more favor.Please tel me >> > about adding values from db..Under the http request i created a JDBC >> > connection config.My configarations are >> > >> > varible name : test_id >> > Database url: jdbc:mysql://localhost:3306/openevsys >> > JDBC driver class: com.mysql.jdbc.Driver >> > username: root >> > password : root >> > >> > Others i left as default.Im not sure about what to put under the JDBC >> driver >> > class i just added the same thing which can be seen in the tutorial. >> > >> > After that i created a JDBC request under that JDBC connection config.I >> > gave the same varible name as JDBC cnnection config..Similarly in http >> > request ('add person') i use variable ${test_id}. >> > >> > When i run this thing http request didn't send.I just tried by giving >> > separate names for JDBC config and conection then it sends the http >> request >> > but the value of add person is going as ${test_id}.:-(..If you can please >> > help me..Sorry for bothering.Thanks again. >> > >> > >> > >> > >> > RaGnoR wrote: >> >> >> >> It works fine for me :). >> >> Try this, step by step: >> >> 1. add Random Variable element under your http request ('add person') >> >> 2. set the name of the Random Variable to test_id (check that this >> >> name is unique in your test plan) and the minimum and maximum value as >> >> you need >> >> 3. in http request ('add person') use variable in this form: ${test_id} >> >> >> >> Best regards, >> >> Jakub >> >> >> >> >> >> 2009/9/8 dilantha <dilantha.tyr...@gmail.com>: >> >>> >> >>> Hi, >> >>> >> >>> Thanks for the help.But still im facing that problem. I just right click >> >>> the >> >>> http request which im sending and add a Random variable. For example >> just >> >>> assume there is a http request called "add person". i just need to send >> a >> >>> random value for person's id with that request. previously i added that >> >>> "id" >> >>> parameter under http request. but now i removed it from there and add >> >>> that >> >>> parameter to the random value which i have added to that "add person" >> >>> http >> >>> request. But still i can't see the random value is going with the http >> >>> request. because when i go the result tree's request it didn't show me >> >>> the >> >>> "id" field which ia have added under the random value. It only showed me >> >>> the >> >>> static values which i have directly added to the http request..If you >> can >> >>> please help..I'm n big trouble:-(:-(..Thanks again.. >> >>> >> >>> >> >>> >> >>> >> >>> RaGnoR wrote: >> >>>> >> >>>> Hi! >> >>>> >> >>>> Instead of using Random function try use 'Random Variable' >> >>>> configuration element. >> >>>> >> >>>> Before you use data from db you have to fetch those data. To fetch >> >>>> data use 'JDBC Connection Configuration' and 'JDBC Request' elements. >> >>>> Read this: >> >>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html. >> >>>> >> >>>> >> >>>> Best regards, >> >>>> Jakub >> >>>> >> >>>> >> >>>> 2009/9/7 dilantha <dilantha.tyr...@gmail.com>: >> >>>>> >> >>>>> Hi All, >> >>>>> I'm bit new to jmeter so at the moment im facing some problems with >> >>>>> load >> >>>>> testing. Currently im using jmeter for load testing in a web >> >>>>> application. >> >>>>> I >> >>>>> just want to know how can i generate a random value with the http >> >>>>> request >> >>>>> and send . For example just assume that i have a parameter called "id" >> >>>>> how >> >>>>> can i generate a random id to send with the http request..What should >> i >> >>>>> type >> >>>>> under the value field?..i just type ${_Random(1,10)} under the value >> >>>>> field >> >>>>> but it did not work..and the other thing is if i want to assign a >> value >> >>>>> to a >> >>>>> field from a set of values which are stored in the data base how can i >> >>>>> do >> >>>>> that?..is it possible?:-(..If some one know the solution please be >> kind >> >>>>> enough to send it..Thanks a lot.. >> >>>>> -- >> >>>>> View this message in context: >> >>>>> >> http://www.nabble.com/How-to-add-random-values..-tp25330799p25330799.html >> >>>>> Sent from the JMeter - User mailing list archive at Nabble.com. >> >>>>> >> >>>>> >> >>>>> --------------------------------------------------------------------- >> >>>>> To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org >> >>>>> For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >> >>>>> >> >>>>> >> >>>> >> >>>> --------------------------------------------------------------------- >> >>>> To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org >> >>>> For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >> >>>> >> >>>> >> >>>> >> >>> >> >>> -- >> >>> View this message in context: >> >>> >> http://www.nabble.com/How-to-add-random-values..-tp25330799p25340094.html >> >>> Sent from the JMeter - User mailing list archive at Nabble.com. >> >>> >> >>> >> >>> --------------------------------------------------------------------- >> >>> To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org >> >>> For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >> >>> >> >>> >> >> >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org >> >> For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >> >> >> >> >> >> >> > >> > -- >> > View this message in context: >> http://www.nabble.com/How-to-add-random-values..-tp25330799p25342685.html >> > Sent from the JMeter - User mailing list archive at Nabble.com. >> > >> > >> > --------------------------------------------------------------------- >> > To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org >> > For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >> > >> > >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org >> For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org > For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
