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