You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Soumya Nayak <sn...@firstam.com> on 2020/01/06 07:03:25 UTC
Passing the JDBC query values list from one thread group to another
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
Re: Passing the JDBC query values list from one thread group to another
Posted by Divyang Raval <di...@gmail.com>.
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 <sn...@firstam.com> 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
>
Passing the JDBC query values list from one thread group to another
Posted by Soumya Nayak <sn...@firstam.com>.
Hi Deepak ,
Thanks for the reply. I tried with points a and c , was able to achieve that.
Will try with b and d option also and let you know if any issues.
Regards,
Soumya
-----Original Message-----
From: Deepak Shetty <sh...@gmail.com>
Sent: Tuesday, January 7, 2020 4:13 AM
To: JMeter Users List <us...@jmeter.apache.org>
Cc: Divyang Raval <di...@gmail.com>
Subject: Re: Passing the JDBC query values list from one thread group to another
Hi
if you want to pass complex data between thread groups /threads , you can a. Use properties like you mentioned. Complex data needs complex schemes (e.g. Store a JSON string which can have an array of objects and parse it)
- Messy for most,non simple, use cases
b. Use a plugin like
https://jmeter-plugins.org/wiki/InterThreadCommunication/ . Useful when data is to be generated and consumed at the same time.
c. Use something that can be shared across thread groups - e.g. Files / RDBMS / Redis etc. So in your example use a setup thread group and write the data you want to a CSV file and then read it from the following threadgroups that need it. In your case you seem to be implying that you want to generate the data once and then read it from multiple thread groups.
d. Write your own java code that can deal with data as it wishes.
Bear in mind , what you want to happen if you distribute this script across multiple JMeter servers - some sharing methods are scoped to the JVM(in
memory) , others to the host (files) and others to the script (DB)
regards
dee[al
On Mon, Jan 6, 2020 at 1:01 AM Soumya Nayak <sn...@firstam.com> wrote:
> 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 <di...@gmail.com>
> Sent: Monday, January 6, 2020 2:28 PM
> To: Soumya Nayak <sn...@firstam.com>
> Cc: JMeter Users List <us...@jmeter.apache.org>
> 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 <snayak@firstam.com<mailto:
> snayak@firstam.com>> 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
> <di...@gmail.com>>
> Sent: Monday, January 6, 2020 12:53 PM
> To: Soumya Nayak <sn...@firstam.com>>
> Cc: JMeter Users List <user@jmeter.apache.org<mailto:
> user@jmeter.apache.org>>
> 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 <snayak@firstam.com<mailto:
> snayak@firstam.com><mailto:snayak@firstam.com<mailto:snayak@firstam.co
> m>>>
> 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
>
Re: Passing the JDBC query values list from one thread group to another
Posted by Deepak Shetty <sh...@gmail.com>.
Hi
if you want to pass complex data between thread groups /threads , you can
a. Use properties like you mentioned. Complex data needs complex schemes
(e.g. Store a JSON string which can have an array of objects and parse it)
- Messy for most,non simple, use cases
b. Use a plugin like
https://jmeter-plugins.org/wiki/InterThreadCommunication/ . Useful when
data is to be generated and consumed at the same time.
c. Use something that can be shared across thread groups - e.g. Files /
RDBMS / Redis etc. So in your example use a setup thread group and write
the data you want to a CSV file and then read it from the following
threadgroups that need it. In your case you seem to be implying that you
want to generate the data once and then read it from multiple thread groups.
d. Write your own java code that can deal with data as it wishes.
Bear in mind , what you want to happen if you distribute this script across
multiple JMeter servers - some sharing methods are scoped to the JVM(in
memory) , others to the host (files) and others to the script (DB)
regards
dee[al
On Mon, Jan 6, 2020 at 1:01 AM Soumya Nayak <sn...@firstam.com> wrote:
> 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 <di...@gmail.com>
> Sent: Monday, January 6, 2020 2:28 PM
> To: Soumya Nayak <sn...@firstam.com>
> Cc: JMeter Users List <us...@jmeter.apache.org>
> 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 <snayak@firstam.com<mailto:
> snayak@firstam.com>> 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 <di...@gmail.com>>
> Sent: Monday, January 6, 2020 12:53 PM
> To: Soumya Nayak <sn...@firstam.com>>
> Cc: JMeter Users List <user@jmeter.apache.org<mailto:
> user@jmeter.apache.org>>
> 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 <snayak@firstam.com<mailto:
> snayak@firstam.com><ma...@firstam.com>>>
> 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
>
Passing the JDBC query values list from one thread group to another
Posted by Soumya Nayak <sn...@firstam.com>.
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 <di...@gmail.com>
Sent: Monday, January 6, 2020 2:28 PM
To: Soumya Nayak <sn...@firstam.com>
Cc: JMeter Users List <us...@jmeter.apache.org>
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 <sn...@firstam.com>> 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 <di...@gmail.com>>
Sent: Monday, January 6, 2020 12:53 PM
To: Soumya Nayak <sn...@firstam.com>>
Cc: JMeter Users List <us...@jmeter.apache.org>>
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 <sn...@firstam.com>>> 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
Re: Passing the JDBC query values list from one thread group to another
Posted by Divyang Raval <di...@gmail.com>.
I would prefer in same thread group.
On Mon, Jan 6, 2020 at 1:32 PM Soumya Nayak <sn...@firstam.com> 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 <di...@gmail.com>
> Sent: Monday, January 6, 2020 12:53 PM
> To: Soumya Nayak <sn...@firstam.com>
> Cc: JMeter Users List <us...@jmeter.apache.org>
> 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 <snayak@firstam.com<mailto:
> snayak@firstam.com>> 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
>
Passing the JDBC query values list from one thread group to another
Posted by Soumya Nayak <sn...@firstam.com>.
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 <di...@gmail.com>
Sent: Monday, January 6, 2020 12:53 PM
To: Soumya Nayak <sn...@firstam.com>
Cc: JMeter Users List <us...@jmeter.apache.org>
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 <sn...@firstam.com>> 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
Re: Passing the JDBC query values list from one thread group to another
Posted by Divyang Raval <di...@gmail.com>.
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 <sn...@firstam.com> 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
>