Send me ur test plan as attachment to personal mail ID
[EMAIL PROTECTED]
2008/10/22 sudheer reddy <[EMAIL PROTECTED]>
> ok i have done as u told but am not successfull
>
> her with am sending u the snap shots of my plan
>
> regular expression sheet and also http request
>
>
>
>
> On 10/22/08, Ravindra Gupta <[EMAIL PROTECTED]> wrote:
>>
>> 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]
>> > > > > > >
>> > > > > > >
>> > > > > >
>> > > > >
>> > > >
>> > >
>> >
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
