Mailing-List: contact user-help@jmeter.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <user@jmeter.apache.org>
Received-SPF: pass (nike.apache.org: domain of jamalraihan@gmail.com
 designates 209.85.219.49 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAH0jRU9GM8OdMYv0P4Gci=BUsPW1pRFV1j-YdB1vJQxHgJasQg@mail.gmail.com>
References: 
 <CAH0jRU9GM8OdMYv0P4Gci=BUsPW1pRFV1j-YdB1vJQxHgJasQg@mail.gmail.com>
From: Raihan Jamal <jamalraihan@gmail.com>
Date: Wed, 13 Feb 2013 12:01:14 -0800
Message-ID: 
 <CAH0jRU_+3qgk8Wv=85wudL21wgUEWAEgghYytDXkd9h=eaJo0Q@mail.gmail.com>
Subject: Re: Generate Random Unique numbers using JMeter
To: user@jmeter.apache.org
Content-Type: multipart/alternative; boundary=e89a8fb2007aea05d904d5a09ba5

--e89a8fb2007aea05d904d5a09ba5
Content-Type: text/plain; charset=ISO-8859-1

I made some progress on this. I have initialize counter variable like this-


init variable (eg in "User Defined Variables"):

Name:       | Value
------------+---------
LoopCounter | 0


And in my Parameter values I am using something like this now-

*${__intSum(${LoopCounter},1,LoopCounter)}
,"{""lv"":[{""v"":{""regId"":null,""
user"":null,""Id"":996},""cn"":1}],""lmd"":1360185}"*
*
*

And my *LoopCounter* is something like this-

Name:- LoopCounter
Start:-  1
Increment:- 1
Maximum:- 1000
Number format:- 000


I have unchecked *Track counter independently for each user*
*
*
But still I am getting exception thrown as Primary Key violation. Is there
anything wrong I am doing here?


*Raihan Jamal*


On Wed, Feb 13, 2013 at 11:41 AM, Raihan Jamal <jamalraihan@gmail.com>wrote:

> I am trying to insert into the below table currently using JMeter-
>
> INSERT INTO XMP_TEST2 (id, a_sellers) values (?, ?)
>
> Data Types for the above columns are-
>
> *id                String*
> *a_sellers     String*
>
> In the above table *id is the Primary Key. *So I need some way to
> generate unique id always either starting from 1 or any random unique
> numbers. Is there any way I can do that in JMeter?
>
> Currently in my Parameter Values, I am passing something like this to
> insert in the above two columns-
>
>
> ${__BeanShell(UUID.randomUUID().toString())}
> ,"{""lv"":[{""v"":{""regId"":null,""
> user"":null,""Id"":996},""cn"":1}],""lmd"":1360185}"
>
>
> And Parameter types is-
>
> VARCHAR,VARCHAR
>
>
> One approach I am thinking of is keep on increment by one every time. But
> how should I do in this JMeter?
>
> Does anyone has any experience on this particular problem?
>
>
> Looking forward for your replies.
>
>
>
>
> *Raihan Jamal*
>

--e89a8fb2007aea05d904d5a09ba5--