Hi RaGnoR and all users,
Thanks a lot for user reply.I gave up on trying to retrieve values from db.
It doesn't seems to be working. Instead now i'm trying to use that CSV Data
Set. But still didn't found a good article which explains how to use a CSV
Data Set to set a random vsalue with the http request. If you can please
tell me how to use t from the beginning spet by step. A link to a proper
artical also would be enough. Again thanks a lot for your help...waiting for
your reply..Thanks..
RaGnoR 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. 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
>
>
>
--
View this message in context:
http://www.nabble.com/How-to-add-random-values..-tp25330799p25358966.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
