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. <[email protected]> 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:[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] >
