read a value from an SQL SELECT statement

[Richard Sullivan <it...@gmail.com>]

Hi,

I want to query the database (via a select statement) for a value.  I want to
store this value in a variable and later use this value in order check the
results of a HTTP POST request.

For example the sql might check the database for the number of items in stock
and then later an assertion should check that a query made via a web application
returns the same number.

I have seen a lot of examples of people sending SQL SELECTS and UPDATES to a
database via JDBCSampler but I never saw anyone really doing anything with the
results.  I guess I will have to use the BeanShell for this.

Any ideas/examples ?

Thanks,
Richard


---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org