jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nayak, Soumya R." <sna...@firstam.com>
Subject RE: Jmeter Data Driven Load tests
Date Thu, 28 Dec 2017 19:09:50 GMT
Hi Deepak,

The solution that you have given , I have implemented the same now taking all the data into
a CSV file using sampler and then sharing the data of the CSV across threads.

Thanks,
Soumya

-----Original Message-----
From: Deepak Shetty [mailto:shettyd@gmail.com] 
Sent: Friday, December 29, 2017 12:33 AM
To: JMeter Users List <user@jmeter.apache.org>
Subject: Re: Jmeter Data Driven Load tests

The easiest way is a setup thread group that executes a JDBC sampler and saves this data to
a CSV file (or do this before your test starts) There are other ways to share data but usually
need more effort - is there some reason why the above wont work for you?


On Tue, Dec 26, 2017 at 6:07 AM, Nayak, Soumya R. <snayak@firstam.com>
wrote:

> Hi ,
>
> As I am using MYSQL the connection configuration is done and I have 
> uploaded the particular driver for the same also.
>
> The issue of mine is let's say in a thread group I have given no of 
> virtual users as 7.
> I have 10 records in my DB. I have to process these 10 records 
> uniquely be each thread sharing across all 7 threads.
> For eg -- Thread 1 processes row 1  in DB table
>           Thread 2 processes row 2  in DB table
>           Thread 3 processes row 3
>           Thread 4 processes row 4
>           Thread 5 processes row 5
>           Thread 6 processes row 6
>           Thread 7 processes row 7
>           Thread 1 processes row 8
>           Thread 2 processes row 9
>           Thread 3 processes row 10.
>
> SO, all the threads have to uniquely process all the rows of the DB 
> till the end of DB table.
>
> SO how to accomplish the above in Jmeter? (As of now the sharing of 
> data among threads is possible only in CSV using CSV config Element)
>
> Regards,
> Soumya
>
>
> -----Original Message-----
> From: Konstantin Kalinin [mailto:konstantin@kkalinin.pro]
> Sent: Tuesday, December 26, 2017 7:17 PM
> To: JMeter Users List <user@jmeter.apache.org>
> Subject: Re: Jmeter Data Driven Load tests
>
> Hi!
> Isn't a pack of JDBC* components - your case?
> http://jmeter.apache.org/usermanual/component_reference.html#JDBC_
> Connection_Configuration
> http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Requ
> est http://jmeter.apache.org/usermanual/component_reference.html#JDBC_
> PreProcessor
> http://jmeter.apache.org/usermanual/component_reference.html#JDBC_
> PostProcessor
>
> You'll only have to download an appropriate driver for your particular 
> DBMS.
>
> 26.12.2017, 17:41, "Nayak, Soumya R." <snayak@firstam.com>:
> > Hi,
> >
> > As of now we have "CSV config element" for using the CSV as data 
> > file in
> which we can even share the resources across threads or threadgroups.
> > Similarly do we have any element or plugin where we can give 
> > datasource
> as Database or Directory rather than CSV.
> > Please help me as I have Database as the data source as of now where 
> > I
> have to pick up files and process them by sharing all the data 
> uniquely across the threads or virtual users.
> >
> > Regards,
> > Soumya
> >
> > ********************************************************************
> > **
> > ******************** This message may contain confidential or 
> > proprietary information intended only for the use of the
> > addressee(s) named above or may contain information that is legally 
> > privileged. If you are not the intended addressee, or the person 
> > responsible for delivering it to the intended addressee, you are 
> > hereby notified that reading, disseminating, distributing or copying 
> > this message is strictly prohibited. If you have received this 
> > message
> by mistake, please immediately notify us by replying to the message 
> and delete the original message and any copies immediately thereafter.
> >
> > If you received this email as a commercial message and would like to 
> > opt out of future commercial messages, please let us know and we 
> > will
> remove you from our distribution list.
> >
> > Thank you.~
> > ********************************************************************
> > **
> > ********************
> > FAFLD
>
> --
> Konstantin Kalinin
> +7 912 468 00 00
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
Mime
View raw message