Can JMeter retreive a value for a parameter in a HTTP Request using an SQL Query?

[Mary George <ma...@infosys.com>]

Hi,

Before sending a particular HTTP request in a thread group, can JMeter
be configured to retreive a value for a parameter being passed with the
request, from Oracle using an SQL Query? If this can be done, is there
any way of differentiating between the time taken by the HTTP request,
and the time taken for running the query? Any thoughts you can give me
on this would be much appreciated.

...Mary





**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Re: Can JMeter retreive a value for a parameter in a HTTP Request using an SQL Query?

[Manish Mathuria <mm...@yahoo.com>]

Hi
 
I have not exactly done it my self, but you could potentially use JDBC sampler, extract the output using a regex and use it on your next HTTP call. 
 
JMeter will track all these calls separately, or you could use a transaction element to wrap a transaction around your HTTP call. Let me know if you have more questions
 
Manish
 


Mary George <ma...@infosys.com> wrote:

Hi,

Before sending a particular HTTP request in a thread group, can JMeter
be configured to retreive a value for a parameter being passed with the
request, from Oracle using an SQL Query? If this can be done, is there
any way of differentiating between the time taken by the HTTP request,
and the time taken for running the query? Any thoughts you can give me
on this would be much appreciated.

...Mary





**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com