jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Deepak Shetty <shet...@gmail.com>
Subject Re: Jmeter Data Driven Load tests
Date Thu, 28 Dec 2017 19:02:49 GMT
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_Request
> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message