jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michele Mase'" <michele.m...@gmail.com>
Subject Re: Tricky DB Test Plan
Date Wed, 22 Feb 2012 15:18:34 GMT
Tx!
The debug postprocessor after the regex extractor helped me.
the following  regex/template/match no/default value are working now:
([0-9]{7}) / $0$ / 0 / dummy
Regards
MM'

On Wed, Feb 22, 2012 at 11:25 AM, sebb <sebbaz@gmail.com> wrote:

> On 22 February 2012 09:42, Michele Mase' <michele.mase@gmail.com> wrote:
> > I've tried unsuccessfully with regex extractor.
> > This is the response from the query1:
> > INVP0
> > 9315554
> > 9315555
> > 9315556
> > 9315557
> > 9315558
> > 9315559
> > 9315560
> > ...
> > The response field to check is the body.
> > If I apply the following  regex/template/match no/default value
> > ([0-9]{7}) / $1$ / 1 / dummy
> > query2 is made using null as variable value, that means the query string
> > does not contain any data :(
> > What's my mistake?
>
> Did you add a variable name on the JDBC Sampler?
>
> Try adding a Debug Sampler after the JDBC Sampler.
>
> It should show the list of values stored in variables, see:
>
> http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request
>
> >
> >
> > On Tue, Feb 21, 2012 at 6:31 PM, Britto Christy <brittobtech@gmail.com
> >wrote:
> >
> >> Get the value by using regular expression from query1 result and assign
> it
> >>  variable. Now you can use this variable to query 2.
> >>
> >>
> >> On Tuesday, February 21, 2012, Michele Mase' <michele.mase@gmail.com>
> >> wrote:
> >> > I'm recording a new test plan;
> >> > Old style:
> >> > Extracting a list of value from query1
> >> > Putting those data in a CVS Data Set Config, using variable1
> >> > Calling query2 with variable1
> >> > All works
> >> > New Style:
> >> > query1
> >> > SELECT  data1 FROM table1 where data1 >= (SELECT MAX (data1)-1000 FROM
> >> > table1)
> >> > the response is a long list
> >> > value1
> >> > value2
> >> > ...
> >> > valuen
> >> > I'm unable to:
> >> > Getting the value directly from query1 and putting them into a
> variable
> >> > variable1
> >> > Utilizing variable1 for query2
> >> > How can I do it?
> >> > Regards
> >> > MM'
> >> >
> >>
> >> --
> >>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>

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