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 <jlut...@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 <abhitosh...@gmail.com> > *Sent:* Wednesday, July 28, 2021 4:53 AM > *To:* JMeter Users List <user@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 <jlut...@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 <abhitosh...@gmail.com> > Sent: Tuesday, July 27, 2021 1:43 PM > To: JMeter Users List <user@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 <jlut...@rocketsoftware.com > <mailto:jlut...@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. >