You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by ZK <st...@gmail.com> on 2014/03/20 13:19:58 UTC
Re: Is it possible to connect to and query a database to use data
in an HTTP request in JMeter?
Hi,
yes it is possible:
- Connect to an Oracle or SQL Server database
JDBC_Connection_Configuration
<http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Connection_Configuration>
- Run a SQL query to extract some data
JDBC_Request
<http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request>
Store the SELECT variables into the Variable Names field
Varaible Names: yourVar1, yourVar2
- Use that data in an HTTP request
in the normal way ${yourVar1} ${yourVar2}
ZK
--
View this message in context: http://jmeter.512774.n5.nabble.com/Is-it-possible-to-connect-to-and-query-a-database-to-use-data-in-an-HTTP-request-in-JMeter-tp5719644p5719646.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org