jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <seb...@gmail.com>
Subject Re: BeanShell Assertion in jdbc request
Date Fri, 18 Nov 2016 14:48:20 GMT
On 18 November 2016 at 14:15, Sankar Das <007bhabanisankar@gmail.com> wrote:
> Hello Everyone,
>
> Getting two columns from a jdbc sampler  i.e ID and WF. Trying to fail it,
> if it exceeds than the predefined variables by using beanshell.
> Below is the sample code.
>
> String myValue1 = vars.get("WF_1");
> String myValue2 = vars.get("WF_2");
> if(!myValue1.equals ("3")){
>   log.info("myValue1 =" + myValue1);
>   Failure = true;
>   FailureMessage = " The database value should be " + myValue1 + ".";
> }
> else if(!myValue2.equals ("5")){
>   //log something
>   Failure = true;
>   log.info("myValue2 =" + myValue2);
>    FailureMessage = " The database value should be " + myValue2 + ".";
>
> else {
>   //can be log something?
>      Failure = false;
>
>
> }
> Above code is working when I know the number of rows for a particular
> column. If the rows values are dynamic and increasing or decreasing
> according to sysdate than how to compare them with the predefined and fail
> the sampler.
>
> Please help!

As per http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request

the number of rows is stored in the variables

ID_# and WF_#

> Thanks!

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


Mime
View raw message