Mailing-List: contact jmeter-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <jmeter-user@jakarta.apache.org>
Received-SPF: pass (nike.apache.org: domain of ragnor84@gmail.com designates
 209.85.218.219 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=eXSjeaVLFEHqR45OY55mwCQ2rAlJTWZ2xokFm7bao8gn0vFUPs4c3DFe9Zy7hgMOKr
         wNJmNrS2e9SJNYbNBqj434MXZQc4Kiqewwt48+6gvxaxn2+E8K/DENiMqc9O5fEGtlt8
         L6qse/dqoza3aA3l0QS2YN5hEgNAxSSaHBCO8=
MIME-Version: 1.0
In-Reply-To: <25342685.post@talk.nabble.com>
References: <25330799.post@talk.nabble.com>
	 <435638260909071032w5e186b01ic0dfa5b44c39b09c@mail.gmail.com>
	 <25340094.post@talk.nabble.com>
	 <435638260909072241t4a2eb20bj71a709f4378fdf28@mail.gmail.com>
	 <25342685.post@talk.nabble.com>
Date: Tue, 8 Sep 2009 13:14:17 +0200
Message-ID: <435638260909080414i765c056dx449a370a4cd04641@mail.gmail.com>
Subject: Re: How to add random values..
From: =?ISO-8859-2?Q?Jakub_Bia=B3ek?= <ragnor84@gmail.com>
To: JMeter Users List <jmeter-user@jakarta.apache.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 dri=
ver
> 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 =A0same varible name as JDBC cnnection config..Similarly in http
> request ('add person') =A0i use variable =A0${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 reque=
st
> 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 clic=
k
>>> the
>>> http request which im sending and add a Random variable. For example ju=
st
>>> 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 m=
e
>>> the
>>> static values which i have directly added to the http request..If you c=
an
>>> 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,
>>>>> =A0I'm bit new to jmeter so at the moment im facing some problems wit=
h
>>>>> 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 val=
ue
>>>>> 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 ki=
nd
>>>>> 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.ht=
ml
>>> 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-val=
ues..-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