You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Jeff Lutzow <jl...@rocketsoftware.com> on 2021/07/27 18:25:19 UTC
Have JMeter Prepare SQL ONLY once and Execute Multiple times
Is there a way to accomplish the above? Everything I have tried I still see JMeter “Prepare” the SQL statement every time when using the JDBC driver to connect to IBM Data Virtualization Manager.
I would like to run a test where it runs the same request multiple times but ONLY Prepares the request one time.
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
================================
Rocket Software, Inc. and subsidiaries ¦ 77 Fourth Avenue, Waltham MA 02451 ¦ Main Office Toll Free Number: +1 855.577.4323
Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy
================================
This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.
Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
Posted by Scott Dean <ps...@ncsu.edu>.
Greetings!
Not sure that this is a relevant approach but:
- Could the Prepare the SQL statement be run in a StartupThreadGroup that
runs 1 thread 1 time and the rest of the steps be in a separate regular
ThreadGroup that iterates over the different variations?
- Similarly, set up two threadgroups, the first is 1 thread running 1 time
with the Prepare SQL statement and the second threadgroup runs the
iterations, and mark the Threadgroups to run sequentially. You could then
have multiple pairs of TGs to run different Prepared statements. If they
were in a single Test Plan, they would run sequentially. If you need them
to run "in parallel" you would probably need to run multiple jmeter
instances, each with its own test plan for a particular Prepared SQL
statement.
Hope that helps!
-- Scott Dean
NC State University
Raleigh NC
On Thu, Jul 29, 2021 at 12:36 PM Tong Sun <su...@gmail.com> wrote:
> Hmm...
>
> - can the Prepared the SQL statement be saved once and used later? If not,
> - can the Prepared the SQL statement be saved once and used later outside
> JMeter?
>
>
>
> On Thu, Jul 29, 2021 at 11:38 AM Jeff Lutzow <jl...@rocketsoftware.com>
> wrote:
>
>> Cannot seem to get JMeter to NOT prepare the statement every time.
>>
>>
>>
>> I am trying to replicate an application server that might have queries
>> that would be prepared one time and then run multiple times with different
>> input variables. I would think that would be something JMeter supported
>> and not that hard to setup.
>>
>>
>>
>> If you have any other ideas please let me know.
>>
>>
>>
>> Thanks, Jeff
>>
>>
>>
>> *From:* A P <ab...@gmail.com>
>> *Sent:* Wednesday, July 28, 2021 4:53 AM
>> *To:* JMeter Users List <us...@jmeter.apache.org>
>> *Subject:* Re: Have JMeter Prepare SQL ONLY once and Execute Multiple
>> times
>>
>>
>>
>> *EXTERNAL EMAIL*
>>
>>
>>
>>
>> It's here:
>>
>>
>>
>>
>>
>> On Wed, Jul 28, 2021 at 2:25 AM Jeff Lutzow <jl...@rocketsoftware.com>
>> wrote:
>>
>> I can’t even find the “Critical Section Controller” area. I am running
>> the latest 5.4.1 version.
>>
>> From: A P <ab...@gmail.com>
>> Sent: Tuesday, July 27, 2021 1:43 PM
>> To: JMeter Users List <us...@jmeter.apache.org>
>> Subject: Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
>>
>> EXTERNAL EMAIL
>>
>>
>>
>> Not sure but you can try "Critical section controller"
>>
>> On Tue, Jul 27, 2021 at 11:55 PM Jeff Lutzow <jlutzow@rocketsoftware.com
>> <ma...@rocketsoftware.com>>
>> wrote:
>>
>> > Is there a way to accomplish the above? Everything I have tried I still
>> > see JMeter “Prepare” the SQL statement every time when using the JDBC
>> > driver to connect to IBM Data Virtualization Manager.
>> >
>> > I would like to run a test where it runs the same request multiple times
>> > but ONLY Prepares the request one time.
>> >
>> >
>> > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986<
>> https://go.microsoft.com/fwlink/?LinkId=550986>> for
>> > Windows 10
>> >
>> >
>> > ================================
>> > Rocket Software, Inc. and subsidiaries ¦ 77 Fourth Avenue, Waltham MA
>> > 02451 ¦ Main Office Toll Free Number: +1 855.577.4323
>> > Contact Customer Support:
>> > https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<
>> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport>
>> > Unsubscribe from Marketing Messages/Manage Your Subscription
>> Preferences -
>> > http://www.rocketsoftware.com/manage-your-email-preferences<
>> http://www.rocketsoftware.com/manage-your-email-preferences>
>> > Privacy Policy -
>> > http://www.rocketsoftware.com/company/legal/privacy-policy<
>> http://www.rocketsoftware.com/company/legal/privacy-policy>
>> > ================================
>> >
>> > This communication and any attachments may contain confidential
>> > information of Rocket Software, Inc. All unauthorized use, disclosure or
>> > distribution is prohibited. If you are not the intended recipient,
>> please
>> > notify Rocket Software immediately and destroy all copies of this
>> > communication. Thank you.
>> >
>>
>> ================================
>> Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA
>> 02451 ■ Main Office Toll Free Number: +1 855.577.4323
>> Contact Customer Support:
>> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
>> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences
>> - http://www.rocketsoftware.com/manage-your-email-preferences
>> Privacy Policy -
>> http://www.rocketsoftware.com/company/legal/privacy-policy
>> ================================
>>
>> This communication and any attachments may contain confidential
>> information of Rocket Software, Inc. All unauthorized use, disclosure or
>> distribution is prohibited. If you are not the intended recipient, please
>> notify Rocket Software immediately and destroy all copies of this
>> communication. Thank you.
>>
>> ================================
>> Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA
>> 02451 ■ Main Office Toll Free Number: +1 855.577.4323
>> Contact Customer Support:
>> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
>> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences
>> - http://www.rocketsoftware.com/manage-your-email-preferences
>> Privacy Policy -
>> http://www.rocketsoftware.com/company/legal/privacy-policy
>> ================================
>>
>> This communication and any attachments may contain confidential
>> information of Rocket Software, Inc. All unauthorized use, disclosure or
>> distribution is prohibited. If you are not the intended recipient, please
>> notify Rocket Software immediately and destroy all copies of this
>> communication. Thank you.
>>
>
RE: Have JMeter Prepare SQL ONLY once and Execute Multiple times
Posted by Jeff Lutzow <jl...@rocketsoftware.com>.
Yes…. Like we can write a Java program that does one Prepare statement and then execute that statement multiple times.
So it looks like this:
PREPARE,DESCRIBE,OPEN,FETCH,CLOSE,OPEN,FETCH,CLOSE,OPEN,FETCH,CLOSE,…
From: Tong Sun <su...@gmail.com>
Sent: Thursday, July 29, 2021 11:36 AM
To: JMeter Users List <us...@jmeter.apache.org>
Subject: Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
EXTERNAL EMAIL
Hmm...
- can the Prepared the SQL statement be saved once and used later? If not,
- can the Prepared the SQL statement be saved once and used later outside JMeter?
On Thu, Jul 29, 2021 at 11:38 AM Jeff Lutzow <jl...@rocketsoftware.com>> wrote:
Cannot seem to get JMeter to NOT prepare the statement every time.
I am trying to replicate an application server that might have queries that would be prepared one time and then run multiple times with different input variables. I would think that would be something JMeter supported and not that hard to setup.
If you have any other ideas please let me know.
Thanks, Jeff
From: A P <ab...@gmail.com>>
Sent: Wednesday, July 28, 2021 4:53 AM
To: JMeter Users List <us...@jmeter.apache.org>>
Subject: Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
EXTERNAL EMAIL
It's here:
[cid:image001.png@01D7846F.B262E1A0]
On Wed, Jul 28, 2021 at 2:25 AM Jeff Lutzow <jl...@rocketsoftware.com>> wrote:
I can’t even find the “Critical Section Controller” area. I am running the latest 5.4.1 version.
From: A P <ab...@gmail.com>>
Sent: Tuesday, July 27, 2021 1:43 PM
To: JMeter Users List <us...@jmeter.apache.org>>
Subject: Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
EXTERNAL EMAIL
Not sure but you can try "Critical section controller"
On Tue, Jul 27, 2021 at 11:55 PM Jeff Lutzow <jl...@rocketsoftware.com>>>
wrote:
> Is there a way to accomplish the above? Everything I have tried I still
> see JMeter “Prepare” the SQL statement every time when using the JDBC
> driver to connect to IBM Data Virtualization Manager.
>
> I would like to run a test where it runs the same request multiple times
> but ONLY Prepares the request one time.
>
>
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986<https://go.microsoft.com/fwlink/?LinkId=550986><https://go.microsoft.com/fwlink/?LinkId=550986<https://go.microsoft.com/fwlink/?LinkId=550986>>> for
> Windows 10
>
>
> ================================
> Rocket Software, Inc. and subsidiaries ¦ 77 Fourth Avenue, Waltham MA
> 02451 ¦ Main Office Toll Free Number: +1 855.577.4323
> Contact Customer Support:
> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport><https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport>>
> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences -
> http://www.rocketsoftware.com/manage-your-email-preferences<http://www.rocketsoftware.com/manage-your-email-preferences><http://www.rocketsoftware.com/manage-your-email-preferences<http://www.rocketsoftware.com/manage-your-email-preferences>>
> Privacy Policy -
> http://www.rocketsoftware.com/company/legal/privacy-policy<http://www.rocketsoftware.com/company/legal/privacy-policy><http://www.rocketsoftware.com/company/legal/privacy-policy<http://www.rocketsoftware.com/company/legal/privacy-policy>>
> ================================
>
> This communication and any attachments may contain confidential
> information of Rocket Software, Inc. All unauthorized use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> notify Rocket Software immediately and destroy all copies of this
> communication. Thank you.
>
================================
Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport>
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences<http://www.rocketsoftware.com/manage-your-email-preferences>
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy<http://www.rocketsoftware.com/company/legal/privacy-policy>
================================
This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.
================================
Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport>
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences<http://www.rocketsoftware.com/manage-your-email-preferences>
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy<http://www.rocketsoftware.com/company/legal/privacy-policy>
================================
This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.
================================
Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy
================================
This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.
Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
Posted by Tong Sun <su...@gmail.com>.
Hmm...
- can the Prepared the SQL statement be saved once and used later? If not,
- can the Prepared the SQL statement be saved once and used later outside
JMeter?
On Thu, Jul 29, 2021 at 11:38 AM Jeff Lutzow <jl...@rocketsoftware.com>
wrote:
> Cannot seem to get JMeter to NOT prepare the statement every time.
>
>
>
> I am trying to replicate an application server that might have queries
> that would be prepared one time and then run multiple times with different
> input variables. I would think that would be something JMeter supported
> and not that hard to setup.
>
>
>
> If you have any other ideas please let me know.
>
>
>
> Thanks, Jeff
>
>
>
> *From:* A P <ab...@gmail.com>
> *Sent:* Wednesday, July 28, 2021 4:53 AM
> *To:* JMeter Users List <us...@jmeter.apache.org>
> *Subject:* Re: Have JMeter Prepare SQL ONLY once and Execute Multiple
> times
>
>
>
> *EXTERNAL EMAIL*
>
>
>
>
> It's here:
>
>
>
>
>
> On Wed, Jul 28, 2021 at 2:25 AM Jeff Lutzow <jl...@rocketsoftware.com>
> wrote:
>
> I can’t even find the “Critical Section Controller” area. I am running
> the latest 5.4.1 version.
>
> From: A P <ab...@gmail.com>
> Sent: Tuesday, July 27, 2021 1:43 PM
> To: JMeter Users List <us...@jmeter.apache.org>
> Subject: Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
>
> EXTERNAL EMAIL
>
>
>
> Not sure but you can try "Critical section controller"
>
> On Tue, Jul 27, 2021 at 11:55 PM Jeff Lutzow <jlutzow@rocketsoftware.com
> <ma...@rocketsoftware.com>>
> wrote:
>
> > Is there a way to accomplish the above? Everything I have tried I still
> > see JMeter “Prepare” the SQL statement every time when using the JDBC
> > driver to connect to IBM Data Virtualization Manager.
> >
> > I would like to run a test where it runs the same request multiple times
> > but ONLY Prepares the request one time.
> >
> >
> > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986<
> https://go.microsoft.com/fwlink/?LinkId=550986>> for
> > Windows 10
> >
> >
> > ================================
> > Rocket Software, Inc. and subsidiaries ¦ 77 Fourth Avenue, Waltham MA
> > 02451 ¦ Main Office Toll Free Number: +1 855.577.4323
> > Contact Customer Support:
> > https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<
> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport>
> > Unsubscribe from Marketing Messages/Manage Your Subscription Preferences
> -
> > http://www.rocketsoftware.com/manage-your-email-preferences<
> http://www.rocketsoftware.com/manage-your-email-preferences>
> > Privacy Policy -
> > http://www.rocketsoftware.com/company/legal/privacy-policy<
> http://www.rocketsoftware.com/company/legal/privacy-policy>
> > ================================
> >
> > This communication and any attachments may contain confidential
> > information of Rocket Software, Inc. All unauthorized use, disclosure or
> > distribution is prohibited. If you are not the intended recipient, please
> > notify Rocket Software immediately and destroy all copies of this
> > communication. Thank you.
> >
>
> ================================
> Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA
> 02451 ■ Main Office Toll Free Number: +1 855.577.4323
> Contact Customer Support:
> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences -
> http://www.rocketsoftware.com/manage-your-email-preferences
> Privacy Policy -
> http://www.rocketsoftware.com/company/legal/privacy-policy
> ================================
>
> This communication and any attachments may contain confidential
> information of Rocket Software, Inc. All unauthorized use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> notify Rocket Software immediately and destroy all copies of this
> communication. Thank you.
>
> ================================
> Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA
> 02451 ■ Main Office Toll Free Number: +1 855.577.4323
> Contact Customer Support:
> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences -
> http://www.rocketsoftware.com/manage-your-email-preferences
> Privacy Policy -
> http://www.rocketsoftware.com/company/legal/privacy-policy
> ================================
>
> This communication and any attachments may contain confidential
> information of Rocket Software, Inc. All unauthorized use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> notify Rocket Software immediately and destroy all copies of this
> communication. Thank you.
>
RE: Have JMeter Prepare SQL ONLY once and Execute Multiple times
Posted by Jeff Lutzow <jl...@rocketsoftware.com>.
Cannot seem to get JMeter to NOT prepare the statement every time.
I am trying to replicate an application server that might have queries that would be prepared one time and then run multiple times with different input variables. I would think that would be something JMeter supported and not that hard to setup.
If you have any other ideas please let me know.
Thanks, Jeff
From: A P <ab...@gmail.com>
Sent: Wednesday, July 28, 2021 4:53 AM
To: JMeter Users List <us...@jmeter.apache.org>
Subject: Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
EXTERNAL EMAIL
It's here:
[cid:image002.png@01D78465.CE2C6BE0]
On Wed, Jul 28, 2021 at 2:25 AM Jeff Lutzow <jl...@rocketsoftware.com>> wrote:
I can’t even find the “Critical Section Controller” area. I am running the latest 5.4.1 version.
From: A P <ab...@gmail.com>>
Sent: Tuesday, July 27, 2021 1:43 PM
To: JMeter Users List <us...@jmeter.apache.org>>
Subject: Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
EXTERNAL EMAIL
Not sure but you can try "Critical section controller"
On Tue, Jul 27, 2021 at 11:55 PM Jeff Lutzow <jl...@rocketsoftware.com>>>
wrote:
> Is there a way to accomplish the above? Everything I have tried I still
> see JMeter “Prepare” the SQL statement every time when using the JDBC
> driver to connect to IBM Data Virtualization Manager.
>
> I would like to run a test where it runs the same request multiple times
> but ONLY Prepares the request one time.
>
>
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986<https://go.microsoft.com/fwlink/?LinkId=550986><https://go.microsoft.com/fwlink/?LinkId=550986<https://go.microsoft.com/fwlink/?LinkId=550986>>> for
> Windows 10
>
>
> ================================
> Rocket Software, Inc. and subsidiaries ¦ 77 Fourth Avenue, Waltham MA
> 02451 ¦ Main Office Toll Free Number: +1 855.577.4323
> Contact Customer Support:
> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport><https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport>>
> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences -
> http://www.rocketsoftware.com/manage-your-email-preferences<http://www.rocketsoftware.com/manage-your-email-preferences><http://www.rocketsoftware.com/manage-your-email-preferences<http://www.rocketsoftware.com/manage-your-email-preferences>>
> Privacy Policy -
> http://www.rocketsoftware.com/company/legal/privacy-policy<http://www.rocketsoftware.com/company/legal/privacy-policy><http://www.rocketsoftware.com/company/legal/privacy-policy<http://www.rocketsoftware.com/company/legal/privacy-policy>>
> ================================
>
> This communication and any attachments may contain confidential
> information of Rocket Software, Inc. All unauthorized use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> notify Rocket Software immediately and destroy all copies of this
> communication. Thank you.
>
================================
Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport>
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences<http://www.rocketsoftware.com/manage-your-email-preferences>
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy<http://www.rocketsoftware.com/company/legal/privacy-policy>
================================
This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.
================================
Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy
================================
This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.
Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
Posted by A P <ab...@gmail.com>.
It's here:
[image: image.png]
On Wed, Jul 28, 2021 at 2:25 AM Jeff Lutzow <jl...@rocketsoftware.com>
wrote:
> I can’t even find the “Critical Section Controller” area. I am running
> the latest 5.4.1 version.
>
> From: A P <ab...@gmail.com>
> Sent: Tuesday, July 27, 2021 1:43 PM
> To: JMeter Users List <us...@jmeter.apache.org>
> Subject: Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
>
> EXTERNAL EMAIL
>
>
>
> Not sure but you can try "Critical section controller"
>
> On Tue, Jul 27, 2021 at 11:55 PM Jeff Lutzow <jlutzow@rocketsoftware.com
> <ma...@rocketsoftware.com>>
> wrote:
>
> > Is there a way to accomplish the above? Everything I have tried I still
> > see JMeter “Prepare” the SQL statement every time when using the JDBC
> > driver to connect to IBM Data Virtualization Manager.
> >
> > I would like to run a test where it runs the same request multiple times
> > but ONLY Prepares the request one time.
> >
> >
> > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986<
> https://go.microsoft.com/fwlink/?LinkId=550986>> for
> > Windows 10
> >
> >
> > ================================
> > Rocket Software, Inc. and subsidiaries ¦ 77 Fourth Avenue, Waltham MA
> > 02451 ¦ Main Office Toll Free Number: +1 855.577.4323
> > Contact Customer Support:
> > https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<
> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport>
> > Unsubscribe from Marketing Messages/Manage Your Subscription Preferences
> -
> > http://www.rocketsoftware.com/manage-your-email-preferences<
> http://www.rocketsoftware.com/manage-your-email-preferences>
> > Privacy Policy -
> > http://www.rocketsoftware.com/company/legal/privacy-policy<
> http://www.rocketsoftware.com/company/legal/privacy-policy>
> > ================================
> >
> > This communication and any attachments may contain confidential
> > information of Rocket Software, Inc. All unauthorized use, disclosure or
> > distribution is prohibited. If you are not the intended recipient, please
> > notify Rocket Software immediately and destroy all copies of this
> > communication. Thank you.
> >
>
> ================================
> Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA
> 02451 ■ Main Office Toll Free Number: +1 855.577.4323
> Contact Customer Support:
> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences -
> http://www.rocketsoftware.com/manage-your-email-preferences
> Privacy Policy -
> http://www.rocketsoftware.com/company/legal/privacy-policy
> ================================
>
> This communication and any attachments may contain confidential
> information of Rocket Software, Inc. All unauthorized use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> notify Rocket Software immediately and destroy all copies of this
> communication. Thank you.
>
RE: Have JMeter Prepare SQL ONLY once and Execute Multiple times
Posted by Jeff Lutzow <jl...@rocketsoftware.com>.
I can’t even find the “Critical Section Controller” area. I am running the latest 5.4.1 version.
From: A P <ab...@gmail.com>
Sent: Tuesday, July 27, 2021 1:43 PM
To: JMeter Users List <us...@jmeter.apache.org>
Subject: Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
EXTERNAL EMAIL
Not sure but you can try "Critical section controller"
On Tue, Jul 27, 2021 at 11:55 PM Jeff Lutzow <jl...@rocketsoftware.com>>
wrote:
> Is there a way to accomplish the above? Everything I have tried I still
> see JMeter “Prepare” the SQL statement every time when using the JDBC
> driver to connect to IBM Data Virtualization Manager.
>
> I would like to run a test where it runs the same request multiple times
> but ONLY Prepares the request one time.
>
>
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986<https://go.microsoft.com/fwlink/?LinkId=550986>> for
> Windows 10
>
>
> ================================
> Rocket Software, Inc. and subsidiaries ¦ 77 Fourth Avenue, Waltham MA
> 02451 ¦ Main Office Toll Free Number: +1 855.577.4323
> Contact Customer Support:
> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport<https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport>
> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences -
> http://www.rocketsoftware.com/manage-your-email-preferences<http://www.rocketsoftware.com/manage-your-email-preferences>
> Privacy Policy -
> http://www.rocketsoftware.com/company/legal/privacy-policy<http://www.rocketsoftware.com/company/legal/privacy-policy>
> ================================
>
> This communication and any attachments may contain confidential
> information of Rocket Software, Inc. All unauthorized use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> notify Rocket Software immediately and destroy all copies of this
> communication. Thank you.
>
================================
Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy
================================
This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.
Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
Posted by A P <ab...@gmail.com>.
Not sure but you can try "Critical section controller"
On Tue, Jul 27, 2021 at 11:55 PM Jeff Lutzow <jl...@rocketsoftware.com>
wrote:
> Is there a way to accomplish the above? Everything I have tried I still
> see JMeter “Prepare” the SQL statement every time when using the JDBC
> driver to connect to IBM Data Virtualization Manager.
>
> I would like to run a test where it runs the same request multiple times
> but ONLY Prepares the request one time.
>
>
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
>
> ================================
> Rocket Software, Inc. and subsidiaries ¦ 77 Fourth Avenue, Waltham MA
> 02451 ¦ Main Office Toll Free Number: +1 855.577.4323
> Contact Customer Support:
> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences -
> http://www.rocketsoftware.com/manage-your-email-preferences
> Privacy Policy -
> http://www.rocketsoftware.com/company/legal/privacy-policy
> ================================
>
> This communication and any attachments may contain confidential
> information of Rocket Software, Inc. All unauthorized use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> notify Rocket Software immediately and destroy all copies of this
> communication. Thank you.
>
Re: Sharing the JDBC Connection between all the threads
Posted by Felix Schumacher <fe...@internetallee.de>.
Am 17.08.21 um 21:15 schrieb Tong Sun:
> On Tue, Aug 17, 2021 at 5:06 AM Felix Schumacher <
> felix.schumacher@internetallee.de> wrote:
>
>> Do you want to share the connections over all the threads? (This is not
>> the default in JMeter. Every thread/user has its own connection unless
>> configured otherwise)
>>
> Hi, Felix
>
> Can you elaborate on how to share a single JDBC Connection between all the
> threads pls?
>
> All the threads can share a single CSV input but for them to share a single
> JDBC Connection I'm yet to find how.
>
> It'll help to send unique values in the requests from all the threads.
To configure this, use "1" as "Max Number of Connections".
Felix
>
> thanks
>
Sharing the JDBC Connection between all the threads
Posted by Tong Sun <su...@gmail.com>.
On Tue, Aug 17, 2021 at 5:06 AM Felix Schumacher <
felix.schumacher@internetallee.de> wrote:
>
> Do you want to share the connections over all the threads? (This is not
> the default in JMeter. Every thread/user has its own connection unless
> configured otherwise)
>
Hi, Felix
Can you elaborate on how to share a single JDBC Connection between all the
threads pls?
All the threads can share a single CSV input but for them to share a single
JDBC Connection I'm yet to find how.
It'll help to send unique values in the requests from all the threads.
thanks
Re: FW: Have JMeter Prepare SQL ONLY once and Execute Multiple times
Posted by Felix Schumacher <fe...@internetallee.de>.
Hi Jeff,
enhancement issue has been filed with
https://bz.apache.org/bugzilla/show_bug.cgi?id=65515
It would be nice, if you could test the next nightly
(https://jmeter.apache.org/nightly.html) or successful build from trunk
and report back, whether it works for your use case.
Felix
Am 18.08.21 um 18:08 schrieb Jeff Lutzow:
> Correction.... your suggestion to use that JSR223 Sampler with that Groovy code works well and only does 1 Prepare followed by many Open, Fetch, Close, Open, Fetch, Close....etc.
>
> Hi Jeff,
> seems, that the prepared statements are not cached by default (and there is currently no nice way to enable it via the GUI).
> You can try to enable the prepared statements cache on the pool by using a bit of JSR223 Groovy code:
> ds = vars.getObject("AVZ1Server").configuredDataSource
> log.info("ds.preparedStatements: {}", ds.poolPreparedStatements)
> ds.poolPreparedStatements = true
> ds.maxOpenPreparedStatements = 10 // adapt to your needs
> log.info("ds.preparedStatements: {}", ds.poolPreparedStatements)
> Add a JSR223 Sampler (use Groovy as language) before the first usage of the connection and copy the above code to it.
> Does that help? If so, you might want to open a bugzilla issue to add a flag to enable prepared statement caching via the GUI.
> Felix
>
>
> Thanks very much for your help!!!
>
> I guess I should open a bug request like you suggested and have this added into the JMeter GUI.
>
> Jeff
>
> -----Original Message-----
> From: Felix Schumacher <fe...@internetallee.de>
> Sent: Wednesday, August 18, 2021 9:44 AM
> To: Jeff Lutzow <jl...@rocketsoftware.com>
> Subject: Re: FW: Have JMeter Prepare SQL ONLY once and Execute Multiple times
>
> EXTERNAL EMAIL
>
>
>
>
> ================================
> Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
> Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences
> Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy
> ================================
>
> This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.
Re: FW: Have JMeter Prepare SQL ONLY once and Execute Multiple times
Posted by Felix Schumacher <fe...@internetallee.de>.
Hi Jeff,
seems, that the prepared statements are not cached by default (and there
is currently no nice way to enable it via the GUI).
You can try to enable the prepared statements cache on the pool by using
a bit of JSR223 Groovy code:
ds = vars.getObject("AVZ1Server").configuredDataSource
log.info("ds.preparedStatements: {}", ds.poolPreparedStatements)
ds.poolPreparedStatements = true
ds.maxOpenPreparedStatements = 10 // adapt to your needs
log.info("ds.preparedStatements: {}", ds.poolPreparedStatements)
Add a JSR223 Sampler (use Groovy as language) before the first usage of
the connection and copy the above code to it.
Does that help? If so, you might want to open a bugzilla issue to add a
flag to enable prepared statement caching via the GUI.
Felix
Am 17.08.21 um 16:29 schrieb Jeff Lutzow:
>
>
>
>
>
> *From:* Jeff Lutzow
> *Sent:* Tuesday, August 17, 2021 9:28 AM
> *To:* JMeter Users List <us...@jmeter.apache.org>
> *Subject:* RE: Have JMeter Prepare SQL ONLY once and Execute Multiple
> times
>
>
>
> Here is my setup. I only have 1 thread.
>
>
>
>
>
>
>
>
>
> In the Trace for the DVM Server that these requests are being run on
> it does a Prepare everytime.
>
>
>
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Felix Schumacher <felix.schumacher@internetallee.de
> <ma...@internetallee.de>>
> Sent: Tuesday, August 17, 2021 4:06 AM
> To: user@jmeter.apache.org <ma...@jmeter.apache.org>
> Subject: Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
>
>
>
>
>
> Am 27.07.21 um 20:25 schrieb Jeff Lutzow:
>
> > Is there a way to accomplish the above? Everything I have tried I
> still see JMeter “Prepare” the SQL statement every time when using the
> JDBC driver to connect to IBM Data Virtualization Manager.
>
> >
>
> > I would like to run a test where it runs the same request multiple
> times but ONLY Prepares the request one time.
>
>
>
> How do you test, that the statements are prepared every time?
>
>
>
> What is the setup of your pool definition (in the JDBC Connection)?
>
>
>
> Do you want to share the connections over all the threads? (This is
> not the default in JMeter. Every thread/user has its own connection
> unless configured otherwise)
>
>
>
> Felix
>
>
>
>
>
> >
>
> >
>
> > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986
> <https://go.microsoft.com/fwlink/?LinkId=550986>> for
>
> > Windows 10
>
> >
>
> >
>
> > ================================
>
> > Rocket Software, Inc. and subsidiaries ¦ 77 Fourth Avenue, Waltham MA
>
> > 02451 ¦ Main Office Toll Free Number: +1 855.577.4323 Contact Customer
>
> > Support:
> https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
> <https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport>
>
> > Unsubscribe from Marketing Messages/Manage Your Subscription
>
> > Preferences -
>
> > http://www.rocketsoftware.com/manage-your-email-preferences
> <http://www.rocketsoftware.com/manage-your-email-preferences>
>
> > Privacy Policy -
>
> > http://www.rocketsoftware.com/company/legal/privacy-policy
> <http://www.rocketsoftware.com/company/legal/privacy-policy>
>
> > ================================
>
> >
>
> > This communication and any attachments may contain confidential
> information of Rocket Software, Inc. All unauthorized use, disclosure
> or distribution is prohibited. If you are not the intended recipient,
> please notify Rocket Software immediately and destroy all copies of
> this communication. Thank you.
>
> >
>
>
>
Re: Have JMeter Prepare SQL ONLY once and Execute Multiple times
Posted by Felix Schumacher <fe...@internetallee.de>.
Am 27.07.21 um 20:25 schrieb Jeff Lutzow:
> Is there a way to accomplish the above? Everything I have tried I still see JMeter “Prepare” the SQL statement every time when using the JDBC driver to connect to IBM Data Virtualization Manager.
>
> I would like to run a test where it runs the same request multiple times but ONLY Prepares the request one time.
How do you test, that the statements are prepared every time?
What is the setup of your pool definition (in the JDBC Connection)?
Do you want to share the connections over all the threads? (This is not
the default in JMeter. Every thread/user has its own connection unless
configured otherwise)
Felix
>
>
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
>
>
> ================================
> Rocket Software, Inc. and subsidiaries ¦ 77 Fourth Avenue, Waltham MA 02451 ¦ Main Office Toll Free Number: +1 855.577.4323
> Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
> Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences
> Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy
> ================================
>
> This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.
>