jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sudheer reddy" <gsudheer...@gmail.com>
Subject Re: how to use JDBC request variables in HTTP requests
Date Wed, 22 Oct 2008 07:11:22 GMT
I have given variable in JDBC request as WTPARTNUMBER

so in response is WTPARTNUMBER  xxxxxxx

and the response  is correct


On 10/22/08, Ravindra Gupta <rav.gupta@gmail.com> wrote:
>
> What is the response of ur JDBC request?
>
> On Wed, Oct 22, 2008 at 12:23 PM, sudheer reddy <gsudheer.08@gmail.com
> >wrote:
>
> > Hi Ravindra
> >
> > thanks for ur reply.
> >
> > Do I have to cange any in the Jmeter properties file.
> >
> > it will be helpful for me if u give me some detailed information  how to
> > workout with this with some example.
> >
> > this is my scenario
> >
> > in JDBC request i got the result frrom database now i have to use this
> > result  in another HTTP request
> >
> >  I have associated a Regular expression extractor to this JDBC
> request  and
> > given values in this post processor as given below
> >
> > *reference name : variable*
> > *regular expression : (.*)"*
> > *template : $1$*
> > *match number : 1*
> > *default value : error*
> > **
> > *here reference name and the variable name in JDBC request is same*
> > **
> > and  in HTTP request for  a parameter
> >
> > *number  : ${variable}*
> > **
> > when i run the test  and  check the response data this parameter in HTTP
> > request is taking default value of regular expression instead of JDBC
> > variable.
> >
> > rgds
> > Sudheer
> >
> >
> > On 10/22/08, Ravindra Gupta <rav.gupta@gmail.com> wrote:
> > >
> > > it works for JDBC request also...there must be smthing wrong with your
> > > regex
> > >
> > > On Wed, Oct 22, 2008 at 12:05 PM, sudheer reddy <gsudheer.08@gmail.com
> > > >wrote:
> > >
> > > > Hi sebb
> > > >
> > > >  I have tried  to fix the problem but not successful.
> > > >
> > > > Regular expression extractor is working fine with HTTP request but
> for
> > > JDBC
> > > > request it is taking default value.
> > > >
> > > > can you suggest a solution for this please.
> > > >
> > > > thanks
> > > >
> > > > rgds
> > > > Sudheer
> > > >
> > > >
> > > >
> > > >
> > > > On 10/21/08, sebb <sebbaz@gmail.com> wrote:
> > > > >
> > > > > On 21/10/2008, sudheer reddy <gsudheer.08@gmail.com> wrote:
> > > > > > ok sebb
> > > > > >   can u suggest another method for using this JDBC request result
> > in
> > > > HTTP
> > > > > >  request.
> > > > > >
> > > > >
> > > > > No.
> > > > >
> > > > > It is definitely possible to extract results from JDBC samplers;
> the
> > > > > way you have described it is the way I would have suggested doing
> it,
> > > > > so you just need to fix whatever is wrong...
> > > > >
> > > > > If the JDBC response data shows up in the View Results Tree
> Listener
> > -
> > > > > I assume you have checked this? - then the RE PP can extract it.
> > > > >
> > > > > >
> > > > > >  On Tue, Oct 21, 2008 at 10:33 PM, sebb <sebbaz@gmail.com>
> wrote:
> > > > > >
> > > > > >  > In that case the only possibility is that the RE is wrong.
> > > > > >  >
> > > > > >  > Is it possible that there is trailing/leading white-space
in
> the
> > > RE
> > > > > >  > field? This might cause a match failure.
> > > > > >  >
> > > > > >  > BTW, for testing REs, the Java Request can be useful -
just
> put
> > > some
> > > > > >  > sample text in the ResultData field (this will be the
Body of
> > the
> > > > > >  > response).
> > > > > >  >
> > > > > >  > On 21/10/2008, sudheer reddy <gsudheer.08@gmail.com>
wrote:
> > > > > >  > > *Body*
> > > > > >  >  >
> > > > > >  > >
> > > > > >  > >  On Tue, Oct 21, 2008 at 10:17 PM, sebb <sebbaz@gmail.com>
> > > wrote:
> > > > > >  > >
> > > > > >  > >  > And which "Response Field to check" is selected?
> > > > > >  > >  >
> > > > > >  > >  > On 21/10/2008, sudheer reddy <gsudheer.08@gmail.com>
> > wrote:
> > > > > >  > >  > >  Sebb
> > > > > >  > >  > >
> > > > > >  > >  > >  yes you are right it is JDBC request
only.
> > > > > >  > >  > >
> > > > > >  > >  > >  I have used Regular expression extractor
PP
> > > > > >  > >  > >
> > > > > >  > >  > >  as a child to JDBC request.
> > > > > >  > >  > >
> > > > > >  > >  > >  rgds
> > > > > >  > >  > >  Sudheer
> > > > > >  > >  > >
> > > > > >  > >  > >
> > > > > >  > >  > >  On Tue, Oct 21, 2008 at 9:59 PM, sebb
<
> sebbaz@gmail.com
> > >
> > > > > wrote:
> > > > > >  > >  > >
> > > > > >  > >  > >  > On 21/10/2008, sudheer reddy <gsudheer.08@gmail.com
> >
> > > > wrote:
> > > > > >  > >  > >  > > How to use JDBC request defaults
 in other
> requests
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > There is no such element as a JDBC
Request Default.
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > There is a JDBC Connection Configuration
element
> which
> > > can
> > > > > only
> > > > > >  > be
> > > > > >  > >  > >  > used in a  JDBC Request sampler.
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > >  I have written a sql query
in JDBC request and I
> > got
> > > > the
> > > > > >  > result but
> > > > > >  > >  > i
> > > > > >  > >  > >  > don't
> > > > > >  > >  > >  > >  know how to use this variable
in other HTTP
> > request.
> > > > > >  > >  > >  > >
> > > > > >  > >  > >  > >  scenario
> > > > > >  > >  > >  > >
> > > > > >  > >  > >  > >  using JDBC request i have
got result which is
> > > assigned
> > > > to
> > > > > a
> > > > > >  > >  > variable say
> > > > > >  > >  > >  > '*
> > > > > >  > >  > >  > >  A'.*
> > > > > >  > >  > >  > >  **
> > > > > >  > >  > >  > >  Now I have to use this '*A'
*in HTTP request for
> a
> > > > > parameter
> > > > > >  > say '
> > > > > >  > >  > *X* '
> > > > > >  > >  > >  > .
> > > > > >  > >  > >  > >
> > > > > >  > >  > >  > >  I have associated a Regular
expression extractor
> to
> > > > this
> > > > > JDBC
> > > > > >  > >  > request
> > > > > >  > >  > >  >  and
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > What do you mean by "associated"
?
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > >  given values in this post
processor as given
> below
> > > > > >  > >  > >  > >
> > > > > >  > >  > >  > >  *reference name : variable*
> > > > > >  > >  > >  > >  *regular expression : (.*)"*
> > > > > >  > >  > >  > >  *template : $1$*
> > > > > >  > >  > >  > >  *match number : 1*
> > > > > >  > >  > >  > >  *default value : error*
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > Looks OK.
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > >  **
> > > > > >  > >  > >  > >  *here reference name and the
variable name in
> JDBC
> > > > > request is
> > > > > >  > same*
> > > > > >  > >  > >  > >  **
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > JMeter variables are not related
in any way to SQL
> > > names.
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > >  and  in HTTP request for 
a parameter
> > > > > >  > >  > >  > >
> > > > > >  > >  > >  > >  *number  : ${variable}*
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > OK
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > >  **
> > > > > >  > >  > >  > >  when i run the test  and 
check the response data
> > > this
> > > > > >  > parameter in
> > > > > >  > >  > HTTP
> > > > > >  > >  > >  > >  request is taking default
value of regular
> > expression
> > > > > instead
> > > > > >  > of
> > > > > >  > >  > JDBC
> > > > > >  > >  > >  > >  variable.
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > That means the RE PostProcessor
has been run OK, and
> > the
> > > > > HTTP
> > > > > >  > sampler
> > > > > >  > >  > >  > used the correct variable, but the
RE PP was either
> > > > applied
> > > > > to
> > > > > >  > the
> > > > > >  > >  > >  > wrong input or the RE was incorrect.
Given that the
> RE
> > > is
> > > > > very
> > > > > >  > simple,
> > > > > >  > >  > >  > it's probably because the RE PP
was applied to the
> > wrong
> > > > > input.
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > Did you add the RE PP as a child
of the JDBC
> Sampler?
> > > > > >  > >  > >  >
> > > > > >  > >  > >  > >  Assist me in solving ths issue
> > > > > >  > >  > >  > >
> > > > > >  > >  > >  > >  rgds
> > > > > >  > >  > >  > >  Sudheer
> > > > > >  > >  > >  > >  **
> > > > > >  > >  > >  > >
> > > > > >  > >  > >  >
> > > > > >  > >  > >
> > > > > >  > >  > > >
> > > > > >  >
> > > > ---------------------------------------------------------------------
> > > > > >  > >  > >  > To unsubscribe, e-mail:
> > > > > >  > jmeter-user-unsubscribe@jakarta.apache.org
> > > > > >  > >  > >  > For additional commands, e-mail:
> > > > > >  > jmeter-user-help@jakarta.apache.org
> > > > > >  > >  > >  >
> > > > > >  > >  > >  >
> > > > > >  > >  > >
> > > > > >  > >  >
> > > > > >  > >  >
> > > > >
> ---------------------------------------------------------------------
> > > > > >  > >  > To unsubscribe, e-mail:
> > > > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > > >  > >  > For additional commands, e-mail:
> > > > > jmeter-user-help@jakarta.apache.org
> > > > > >  > >  >
> > > > > >  > >  >
> > > > > >  > >
> > > > > >  >
> > > > > >  >
> > > > ---------------------------------------------------------------------
> > > > > >  > To unsubscribe, e-mail:
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > > >  > For additional commands, e-mail:
> > > > jmeter-user-help@jakarta.apache.org
> > > > > >  >
> > > > > >  >
> > > > > >
> > > > >
> > > > >
> ---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > > > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > >
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message