Mailing-List: contact user-help@jmeter.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <user@jmeter.apache.org>
MIME-Version: 1.0
From: Sankar Das <007bhabanisankar@gmail.com>
Date: Fri, 18 Nov 2016 16:15:49 +0200
Message-ID: <CAKK90JTRS9HPddggA_=X6x1MafDTuOBb+Yymgj0CAJLUzbL4Sw@mail.gmail.com>
Subject: BeanShell Assertion in jdbc request
To: JMeter Users List <user@jmeter.apache.org>
Content-Type: multipart/alternative; boundary=001a114cd3486f89cd054193f179
archived-at: Fri, 18 Nov 2016 14:16:00 -0000

--001a114cd3486f89cd054193f179
Content-Type: text/plain; charset=UTF-8

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!

Thanks!

--001a114cd3486f89cd054193f179--