use jdbc request as following
-your JDBC request
------Add post processor(regular expression exctractor to it) - should be
child of JDBC request.
-Your HTTP request (pass variable of regex to it).
it should work
On Wed, Oct 22, 2008 at 12:41 PM, sudheer reddy <[EMAIL PROTECTED]>wrote:
> 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 <[EMAIL PROTECTED]> wrote:
> >
> > 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]
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
