You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by "Roberts, Jeremie" <Je...@henryschein.com> on 2012/08/14 22:01:41 UTC
JDBC Request or PreProcessor driving variables for HTTP Request
testing and validation
Hi,
I am trying to use a JDBC Request to get a list of variable values to drive my HTTP Request testing, then once I get the results from the HTTP Request, I want to validate the results against another JDBC Request.
I have been looking at the documentation, and I am a bit confused as to how the Result Variable Name is used. It appears that this is what I want to use, but I can't find any good examples of how to really implement this. I believe I want to use a Loop Controller or ForEach Controller so that I can get the HTTP Request to iterate through the results of the JDBC Request.
Do you have some recommendations or examples to help me configure these tests?
Thanks,
Jeremie Roberts
Henry Schein Practice Solutions
Please consider the environment before printing this email.
E-mail messages may contain viruses, worms, or other malicious code. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective action against such code. Henry Schein is not liable for any loss or damage arising from this message.
The information in this email is confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this e-mail by anyone else is unauthorized.
Re: JDBC Request or PreProcessor driving variables for HTTP Request
testing and validation
Posted by Deepak Shetty <sh...@gmail.com>.
> I want to be able to pull SQL data and run my tests instead of having to
extract a CSV file every time I want to run my tests against a different
>database
As before you can run this as part of a setup thread group
>I would like to avoid CSV files as this would introduce extra overhead to
my testing.
DB calls while a test is running is easily much more overhead - especially
when you want to do multi-threaded tests.
In any case match your variable names to the number of columns
for e.g. select a,b from table
Then in the variable names text box have something like vara,varb (these
need not be same as your column names)
foreach inputvariableprefix = vara
Output variable = outa
If you have multiple columns - you usually need to start an incremented
counter inside the for loop so you can access the corresponding varb.
regards
deepak
On Tue, Aug 14, 2012 at 1:22 PM, Roberts, Jeremie <
Jeremie.Roberts@henryschein.com> wrote:
> At this point I am trying to just drive a single thread. I would like to
> drive to multiple threads eventually, but I want to get the basic tests
> running properly first before I worry about multiple threads.
>
> I am more of a SQL users, and since I know the SQL data that I have is
> correct, I want to be able to pull SQL data and run my tests instead of
> having to extract a CSV file every time I want to run my tests against a
> different database. I would like to avoid CSV files as this would introduce
> extra overhead to my testing.
>
> Thanks,
>
> Jeremie Roberts
> Henry Schein Practice Solutions
>
>
> -----Original Message-----
> From: Deepak Shetty [mailto:shettyd@gmail.com]
> Sent: Tuesday, August 14, 2012 2:15 PM
> To: JMeter Users List
> Subject: Re: JDBC Request or PreProcessor driving variables for HTTP
> Request testing and validation
>
> Hi
> You should use Variable Name (
> http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request)
> result variable can also be used but needs BeanShell or some other
> scripting
>
> However are you only going to get data that is needed for a single thread?
> Usually you get a bunch of data that will be used over multiple threads.
> In which case you'd rather write the response to a CSV file (probably in a
> setup thread group) and use that in the next thread group
>
> regards
> deepak
>
> On Tue, Aug 14, 2012 at 1:01 PM, Roberts, Jeremie <
> Jeremie.Roberts@henryschein.com> wrote:
>
> > Hi,
> >
> > I am trying to use a JDBC Request to get a list of variable values to
> > drive my HTTP Request testing, then once I get the results from the
> > HTTP Request, I want to validate the results against another JDBC
> Request.
> >
> > I have been looking at the documentation, and I am a bit confused as
> > to how the Result Variable Name is used. It appears that this is what
> > I want to use, but I can't find any good examples of how to really
> implement this.
> > I believe I want to use a Loop Controller or ForEach Controller so
> > that I can get the HTTP Request to iterate through the results of the
> JDBC Request.
> >
> > Do you have some recommendations or examples to help me configure
> > these tests?
> >
> > Thanks,
> >
> > Jeremie Roberts
> > Henry Schein Practice Solutions
> >
> >
> >
> >
> > Please consider the environment before printing this email.
> >
> >
> > E-mail messages may contain viruses, worms, or other malicious code.
> > By reading the message and opening any attachments, the recipient
> > accepts full responsibility for taking protective action against such
> > code. Henry Schein is not liable for any loss or damage arising from
> this message.
> >
> > The information in this email is confidential and may be legally
> > privileged. It is intended solely for the addressee(s). Access to this
> > e-mail by anyone else is unauthorized.
> >
>
>
>
> Please consider the environment before printing this email.
>
>
> E-mail messages may contain viruses, worms, or other malicious code. By
> reading the message and opening any attachments, the recipient accepts full
> responsibility for taking protective action against such code. Henry Schein
> is not liable for any loss or damage arising from this message.
>
> The information in this email is confidential and may be legally
> privileged. It is intended solely for the addressee(s). Access to this
> e-mail by anyone else is unauthorized.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>
RE: JDBC Request or PreProcessor driving variables for HTTP Request
testing and validation
Posted by "Roberts, Jeremie" <Je...@henryschein.com>.
At this point I am trying to just drive a single thread. I would like to drive to multiple threads eventually, but I want to get the basic tests running properly first before I worry about multiple threads.
I am more of a SQL users, and since I know the SQL data that I have is correct, I want to be able to pull SQL data and run my tests instead of having to extract a CSV file every time I want to run my tests against a different database. I would like to avoid CSV files as this would introduce extra overhead to my testing.
Thanks,
Jeremie Roberts
Henry Schein Practice Solutions
-----Original Message-----
From: Deepak Shetty [mailto:shettyd@gmail.com]
Sent: Tuesday, August 14, 2012 2:15 PM
To: JMeter Users List
Subject: Re: JDBC Request or PreProcessor driving variables for HTTP Request testing and validation
Hi
You should use Variable Name (
http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request)
result variable can also be used but needs BeanShell or some other scripting
However are you only going to get data that is needed for a single thread?
Usually you get a bunch of data that will be used over multiple threads. In which case you'd rather write the response to a CSV file (probably in a setup thread group) and use that in the next thread group
regards
deepak
On Tue, Aug 14, 2012 at 1:01 PM, Roberts, Jeremie < Jeremie.Roberts@henryschein.com> wrote:
> Hi,
>
> I am trying to use a JDBC Request to get a list of variable values to
> drive my HTTP Request testing, then once I get the results from the
> HTTP Request, I want to validate the results against another JDBC Request.
>
> I have been looking at the documentation, and I am a bit confused as
> to how the Result Variable Name is used. It appears that this is what
> I want to use, but I can't find any good examples of how to really implement this.
> I believe I want to use a Loop Controller or ForEach Controller so
> that I can get the HTTP Request to iterate through the results of the JDBC Request.
>
> Do you have some recommendations or examples to help me configure
> these tests?
>
> Thanks,
>
> Jeremie Roberts
> Henry Schein Practice Solutions
>
>
>
>
> Please consider the environment before printing this email.
>
>
> E-mail messages may contain viruses, worms, or other malicious code.
> By reading the message and opening any attachments, the recipient
> accepts full responsibility for taking protective action against such
> code. Henry Schein is not liable for any loss or damage arising from this message.
>
> The information in this email is confidential and may be legally
> privileged. It is intended solely for the addressee(s). Access to this
> e-mail by anyone else is unauthorized.
>
Please consider the environment before printing this email.
E-mail messages may contain viruses, worms, or other malicious code. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective action against such code. Henry Schein is not liable for any loss or damage arising from this message.
The information in this email is confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this e-mail by anyone else is unauthorized.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org
Re: JDBC Request or PreProcessor driving variables for HTTP Request
testing and validation
Posted by Deepak Shetty <sh...@gmail.com>.
Hi
You should use Variable Name (
http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request)
result variable can also be used but needs BeanShell or some other scripting
However are you only going to get data that is needed for a single thread?
Usually you get a bunch of data that will be used over multiple threads. In
which case you'd rather write the response to a CSV file (probably in a
setup thread group) and use that in the next thread group
regards
deepak
On Tue, Aug 14, 2012 at 1:01 PM, Roberts, Jeremie <
Jeremie.Roberts@henryschein.com> wrote:
> Hi,
>
> I am trying to use a JDBC Request to get a list of variable values to
> drive my HTTP Request testing, then once I get the results from the HTTP
> Request, I want to validate the results against another JDBC Request.
>
> I have been looking at the documentation, and I am a bit confused as to
> how the Result Variable Name is used. It appears that this is what I want
> to use, but I can't find any good examples of how to really implement this.
> I believe I want to use a Loop Controller or ForEach Controller so that I
> can get the HTTP Request to iterate through the results of the JDBC Request.
>
> Do you have some recommendations or examples to help me configure these
> tests?
>
> Thanks,
>
> Jeremie Roberts
> Henry Schein Practice Solutions
>
>
>
>
> Please consider the environment before printing this email.
>
>
> E-mail messages may contain viruses, worms, or other malicious code. By
> reading the message and opening any attachments, the recipient accepts full
> responsibility for taking protective action against such code. Henry Schein
> is not liable for any loss or damage arising from this message.
>
> The information in this email is confidential and may be legally
> privileged. It is intended solely for the addressee(s). Access to this
> e-mail by anyone else is unauthorized.
>