You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by "Nayak, Soumya R." <sn...@firstam.com> on 2017/12/26 13:40:51 UTC
Jmeter Data Driven Load tests
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
RE: Jmeter Data Driven Load tests
Posted by "Nayak, Soumya R." <sn...@firstam.com>.
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 <us...@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. <sn...@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 <us...@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." <sn...@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
>
Re: Jmeter Data Driven Load tests
Posted by Deepak Shetty <sh...@gmail.com>.
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. <sn...@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 <us...@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." <sn...@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
>
Jmeter Data Driven Load tests
Posted by "Nayak, Soumya R." <sn...@firstam.com>.
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 <us...@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." <sn...@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
Re: Jmeter Data Driven Load tests
Posted by Konstantin Kalinin <ko...@kkalinin.pro>.
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." <sn...@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