jmeter return results of an sql to a variable

[Ray Trejo <ra...@rackspace.com>]

Hi,

I am currently using jmeter 2.3.  I can get the jdbc request to work.  I
can view the response data in the View Results Tree listener.  So, here
is my issue.  I would like to take the response of the jdbc request and
put it in a variable and use that variable in my test.  For example:  I
query the db for a ticket number and use the ticket number in a thread.
Thanks for your help.   Ray

 

Thank you,

 

Ray Trejo



Confidentiality Notice: This e-mail message (including any attached or
embedded documents) is intended for the exclusive and confidential use of the
individual or entity to which this message is addressed, and unless otherwise
expressly indicated, is confidential and privileged information of Rackspace
Managed Hosting. Any dissemination, distribution or copying of the enclosed
material is prohibited. If you receive this transmission in error, please
notify us immediately by e-mail at abuse@rackspace.com, and delete the
original message. Your cooperation is appreciated.

Re: jmeter return results of an sql to a variable

[Marcin Zawadzki <ma...@gmail.com>]

Hi Ray,

Use Regular Expression Extractor

http://jakarta.apache.org/jmeter/usermanual/component_reference.html#Regular_Expression_Extractor

On Jan 14, 2008 2:24 PM, Ray Trejo <ra...@rackspace.com> wrote:

> Hi,
>
> I am currently using jmeter 2.3.  I can get the jdbc request to work.  I
> can view the response data in the View Results Tree listener.  So, here
> is my issue.  I would like to take the response of the jdbc request and
> put it in a variable and use that variable in my test.  For example:  I
> query the db for a ticket number and use the ticket number in a thread.
> Thanks for your help.   Ray
>
>
>
> Thank you,
>
>
>
> Ray Trejo
>
>
>
> Confidentiality Notice: This e-mail message (including any attached or
> embedded documents) is intended for the exclusive and confidential use of
> the
> individual or entity to which this message is addressed, and unless
> otherwise
> expressly indicated, is confidential and privileged information of
> Rackspace
> Managed Hosting. Any dissemination, distribution or copying of the
> enclosed
> material is prohibited. If you receive this transmission in error, please
> notify us immediately by e-mail at abuse@rackspace.com, and delete the
> original message. Your cooperation is appreciated.
>
>


-- 
Greetings,
Marcin