Hi Divyang, For same thread group I am able to achieve. But my requirement is like I have the JDBC request in one thread group and want to pass the values from the JDBC request to another thread group. Why am asking so is there are 16 thread groups which will use the data from the JDBC request , so rather than calling it 16 times I wanted to call once.
Regards, Soumya From: Divyang Raval <[email protected]> Sent: Monday, January 6, 2020 2:28 PM To: Soumya Nayak <[email protected]> Cc: JMeter Users List <[email protected]> Subject: Re: Passing the JDBC query values list from one thread group to another I would prefer in same thread group. On Mon, Jan 6, 2020 at 1:32 PM Soumya Nayak <[email protected]<mailto:[email protected]>> wrote: Hi Divyang, So the Step – 1 will be in one thread group. And the Step-2 will be in the other thread group right? Regards, Soumya From: Divyang Raval <[email protected]<mailto:[email protected]>> Sent: Monday, January 6, 2020 12:53 PM To: Soumya Nayak <[email protected]<mailto:[email protected]>> Cc: JMeter Users List <[email protected]<mailto:[email protected]>> Subject: Re: Passing the JDBC query values list from one thread group to another Hi Soumya, It can be achieved in 2 steps. Step-1: Add Regx extractor on JDBC query response to extract target field. While extracting list of values you can set Match No.= -1. Let's say variable name in Regx extractor is "listdata". Step-2 : Add For each controller in test plan and give input variable= listdata. And output variable let's say "data". Check the check box of add _. Under this controller add your next request where you want to iterate based on JDBC output you recieved and use ${data} to achieve the target. Feel free to let me know if you find any difficulty while execution. Regards, Divyang On Mon, Jan 6, 2020, 12:33 PM Soumya Nayak <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>> wrote: Hi Team, I have a set up thread group where I am running a JDBC request to get some "n" no of row data into 4 variables. Now I want to access all the above variable values in a loop(for n DB records) in another thread group. How can I achieve this? For a single variable value access I was able to achieve by defining a bean shell assertion and setting the variable as a property (${__setProperty()) and accessing the property({__property()} in another thread group. But , how to achieve the same when we have a list of values fetched from JDBC request in one thread group and access all the list another thread group ? 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
