Jmeter Data Driven Load tests

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Jmeter Data Driven Load tests

Nayak, Soumya R.
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
Reply | Threaded
Open this post in threaded view
|

Re: Jmeter Data Driven Load tests

Konstantin Kalinin
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." <[hidden email]>:

> 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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Jmeter Data Driven Load tests

Nayak, Soumya R.
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:[hidden email]]
Sent: Tuesday, December 26, 2017 7:17 PM
To: JMeter Users List <[hidden email]>
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." <[hidden email]>:

> 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: [hidden email]
For additional commands, e-mail: [hidden email]


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]
Reply | Threaded
Open this post in threaded view
|

Jmeter Data Driven Load tests

Nayak, Soumya R.
In reply to this post by Nayak, Soumya R.
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


From: Nayak, Soumya R.
Sent: Tuesday, December 26, 2017 7:11 PM
To: '[hidden email]' <[hidden email]>
Subject: 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
Reply | Threaded
Open this post in threaded view
|

Re: Jmeter Data Driven Load tests

shettyd
In reply to this post by Nayak, Soumya R.
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. <[hidden email]>
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:[hidden email]]
> Sent: Tuesday, December 26, 2017 7:17 PM
> To: JMeter Users List <[hidden email]>
> 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." <[hidden email]>:
> > 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: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
Reply | Threaded
Open this post in threaded view
|

RE: Jmeter Data Driven Load tests

Nayak, Soumya R.
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:[hidden email]]
Sent: Friday, December 29, 2017 12:33 AM
To: JMeter Users List <[hidden email]>
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. <[hidden email]>
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:[hidden email]]
> Sent: Tuesday, December 26, 2017 7:17 PM
> To: JMeter Users List <[hidden email]>
> 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." <[hidden email]>:
> > 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: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]