Quantcast

(new user)Issue with using result of Sql query as parameter to HTTP request

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

(new user)Issue with using result of Sql query as parameter to HTTP request

Richa Pant
I am a new user to Jmeter.
  I needed to run a SQL query against a database .The result of this query is to be used in another query against different database.
  The result returned from the second query ,I need to pass as a parameter to a HTTP sampler request.
  The flow at run time has to be like as under
  Run Ist Query(against DB1) -> Make second query using result of Ist query( run against DB2-> Run Http request with result of 2nd Query as parameter.
   
  I am able to connect and run queries against the two databases separately and able to get proper response from hard coded HTTP sampler.I was wondering how to combine it all to be able to get values dynamically at runtime.
   
  Is there any way of doing the same with Jmeter. I ll really appreciate the response,
   
  Thanks,
  Richa

               
---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail  makes sharing a breeze.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: (new user)Issue with using result of Sql query as parameter to HTTP request

Wade Catron
I'm thinking you could use a regular expression extractor (post
processor) on the first db request, which allows you to capture all or
part of the response into a variable.  Then use that variable in the
next db request, and again use a regular expression extractor to grab
the results you want, which you can then feed into your HTTP request.

For more info, check the manual:
http://jakarta.apache.org/jmeter/usermanual/component_reference.html#Regular_Expression_Extractor

Hope this helps!



On Fri, 10 Mar 2006 12:51:10 -0800 (PST), "Richa Pant"
<[hidden email]> said:

> I am a new user to Jmeter.
>   I needed to run a SQL query against a database .The result of this
>   query is to be used in another query against different database.
>   The result returned from the second query ,I need to pass as a
>   parameter to a HTTP sampler request.
>   The flow at run time has to be like as under
>   Run Ist Query(against DB1) -> Make second query using result of Ist
>   query( run against DB2-> Run Http request with result of 2nd Query as
>   parameter.
>    
>   I am able to connect and run queries against the two databases
>   separately and able to get proper response from hard coded HTTP
>   sampler.I was wondering how to combine it all to be able to get values
>   dynamically at runtime.
>    
>   Is there any way of doing the same with Jmeter. I ll really appreciate
>   the response,
>    
>   Thanks,
>   Richa
>
>
> ---------------------------------
> Yahoo! Mail
> Bring photos to life! New PhotoMail  makes sharing a breeze.

--
http://www.fastmail.fm - Or how I learned to stop worrying and
                          love email again


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: (new user)Issue with using result of Sql query as parameter to HTTP request

Richa Pant
Thanks alot Wade,
   
  I followed your suggestion. It worked ,
   
  Thanks Again
   
 

Wade Catron <[hidden email]> wrote:
  I'm thinking you could use a regular expression extractor (post
processor) on the first db request, which allows you to capture all or
part of the response into a variable. Then use that variable in the
next db request, and again use a regular expression extractor to grab
the results you want, which you can then feed into your HTTP request.

For more info, check the manual:
http://jakarta.apache.org/jmeter/usermanual/component_reference.html#Regular_Expression_Extractor

Hope this helps!



On Fri, 10 Mar 2006 12:51:10 -0800 (PST), "Richa Pant"
said:

> I am a new user to Jmeter.
> I needed to run a SQL query against a database .The result of this
> query is to be used in another query against different database.
> The result returned from the second query ,I need to pass as a
> parameter to a HTTP sampler request.
> The flow at run time has to be like as under
> Run Ist Query(against DB1) -> Make second query using result of Ist
> query( run against DB2-> Run Http request with result of 2nd Query as
> parameter.
>
> I am able to connect and run queries against the two databases
> separately and able to get proper response from hard coded HTTP
> sampler.I was wondering how to combine it all to be able to get values
> dynamically at runtime.
>
> Is there any way of doing the same with Jmeter. I ll really appreciate
> the response,
>
> Thanks,
> Richa
>
>
> ---------------------------------
> Yahoo! Mail
> Bring photos to life! New PhotoMail makes sharing a breeze.

--
http://www.fastmail.fm - Or how I learned to stop worrying and
love email again


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]



               
---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail  makes sharing a breeze.
Loading...