What is the response of ur JDBC request?
On Wed, Oct 22, 2008 at 12:23 PM, sudheer reddy <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]
> > >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 <[EMAIL PROTECTED]> wrote:
> > > >
> > > > On 21/10/2008, sudheer reddy <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote:
> > > > > > > *Body*
> > > > > > >
> > > > > > >
> > > > > > > On Tue, Oct 21, 2008 at 10:17 PM, sebb <[EMAIL PROTECTED]>
> > wrote:
> > > > > > >
> > > > > > > > And which "Response Field to check" is selected?
> > > > > > > >
> > > > > > > > On 21/10/2008, sudheer reddy <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]
> >
> > > > wrote:
> > > > > > > > >
> > > > > > > > > > On 21/10/2008, sudheer reddy <[EMAIL PROTECTED]>
> > > 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:
> > > > > > [EMAIL PROTECTED]
> > > > > > > > > > For additional commands, e-mail:
> > > > > > [EMAIL PROTECTED]
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > ---------------------------------------------------------------------
> > > > > > > > To unsubscribe, e-mail:
> > > > [EMAIL PROTECTED]
> > > > > > > > For additional commands, e-mail:
> > > > [EMAIL PROTECTED]
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > ---------------------------------------------------------------------
> > > > > > To unsubscribe, e-mail:
> > [EMAIL PROTECTED]
> > > > > > For additional commands, e-mail:
> > > [EMAIL PROTECTED]
> > > > > >
> > > > > >
> > > > >
> > > >
> > > > ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > >
> > > >
> > >
> >
>
