Thanks Sebb.
The session-id is a unique string (max length of 64 bytes)
It's a mix of alpha numberic characters and can have - in it.
To give an example, this is one of the insert statements that is sent.
insert
into
wevscust.jcp001_host_activity_data
(
call_id,called_ph_num,service_id,end_time,host_latency,host_response,hos
t_access_error_code,error_result,host_sequence
)
values
(
${call_id},c,${__Random(0,60,rnd_1)},(sysdate+(${__Random(0,60,rnd_sec)}
/10000)),2,1,0,,16
)
And ${call_id} I used was
${__threadNum()}-${__Random(100000,99999,myR)}.
This was throwing the unique constraint errors.
Any help to create a unique session-id would be greatly appreciated.
Is there a way, we can generate a random value out of a given strings of
characters??
Thanks,
With Best Regards,
Poongs.
AT&T Labs Voice Applications,
214-452-1883 (Home)
"Get a good idea, and stay with it. Dog it, and work at it until it's
done, and done right." - Walt Disney (1901-1966), American entrepreneur,
movie producer and showman
This electronic message transmission, including any attachments, may
contain information from AT&T that is proprietary and/or confidential.
All Intellectual Property in this transmission, including any
attachments is the sole property of AT&T. The information is intended to
be for the use of the individual or entity named above. If you are not
the intended recipient, be aware that any disclosure, copying,
distribution or use of the contents of this information is strictly
prohibited. If you have received this electronic transmission in error,
please immediately notify the sender and destroy all material in its
entirety, whether in electronic or hard copy format.
-----Original Message-----
From: sebb [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 26, 2006 5:03 PM
To: JMeter Users List
Subject: Re: Require a mechanism to create random values across threads
The threadNum() function is not unique across thread groups.
So try adding a different number to the session id in each thread group.
If this does not solve the problem, then you'll need to provide some
more information as to what session ids *are* being generated.
S.
On 25/02/06, Kalamegam, Poongundran (Poongs), ALABS <[EMAIL PROTECTED]>
wrote:
> Hi,
> I am new to JMETER. I have been assigned the job of simulating JDBC
> requests to Oracle 10g.
> I have different kinds of JDBC requests based on a app group. We
have
> 4 apps.
> I created 4 different thread groups. I have created JDBC requests
> under each of these
> thread groups. These write into a specific table which has unique
> constraints enabled.
> Now, i need to send a unique sessionid as part of the insert
requests
> in JDBC Request Sampler.
> I tried to use session_id =
${__threadNum()}-${__Random(100000,99999,
> myR)}.
>
> I run around 30 threads for each of these thread groups.
>
> I am getting unique contraint errors for most of the requests as
this
> session_id is same across the threads.
> Need your help in creating a session_id that would be unique across
> the threads and can be used forever.
>
> Thanks,
> With Best Regards,
> Poongs.
> AT&T Labs Voice Applications,
> 214-452-1883 (Home)
>
> "Get a good idea, and stay with it. Dog it, and work at it until it's
> done, and done right." - Walt Disney (1901-1966), American
entrepreneur,
> movie producer and showman
>
> This electronic message transmission, including any attachments, may
> contain information from AT&T that is proprietary and/or confidential.
> All Intellectual Property in this transmission, including any
> attachments is the sole property of AT&T. The information is intended
to
> be for the use of the individual or entity named above. If you are not
> the intended recipient, be aware that any disclosure, copying,
> distribution or use of the contents of this information is strictly
> prohibited. If you have received this electronic transmission in
error,
> please immediately notify the sender and destroy all material in its
> entirety, whether in electronic or hard copy format.
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
