jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jakub Białek <ragno...@gmail.com>
Subject Re: How to add random values..
Date Tue, 08 Sep 2009 11:14:17 GMT
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. 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.tyrant@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.tyrant@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.tyrant@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-unsubscribe@jakarta.apache.org
>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>
>>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: jmeter-user-help@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-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@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-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


Mime
View raw message