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:[email protected]]
Sent: Tuesday, December 26, 2017 7:17 PM
To: JMeter Users List <[email protected]>
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." <[email protected]>:
> 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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
