jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nayak, Soumya R." <sna...@firstam.com>
Subject Jmeter Data Driven Load tests
Date Tue, 26 Dec 2017 14:07:31 GMT
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
View raw message