You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Andrey Simonov <au...@bk.ru> on 2009/08/17 09:47:32 UTC
JDBC Response Assertion
Hi!
Is there any sort of response assertion for JDBC requests?
Or it's RegExp Extractor only?
If there is a way (maybe via BSF request), please provide an example :)
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
Yes, but please can you give me an example?
I have spent half a day of Friday trying to do something with variables in
BSF and BSH assertions and listeners and no luck!
All I need to do is to be able to evaluate variable and send some message to
some listener :)
An example will be greatly appreciated.
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> That's not what I meant. I meant is there an assertion that can
>> conveniently
>> parse SQL results?
>>
>> E.g. my results are: table headers and 4 values. How do I check that
>> e.g.
>> "Average" is < 30?
>
> JDBC can save results as variables.
>
> The Size Assertion is similar to what you want, unfortunately it only
> checks size... perhaps that should be extended to check a variable.
>
> Meanwhile, use a BSF or BSH Assertion to check the variable.
>
>
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> Hi!
>> >>
>> >> Is there any sort of response assertion for JDBC requests?
>> >
>> > All the Assertions can be used with JDBC.
>> >
>> >> Or it's RegExp Extractor only?
>> >>
>> >> If there is a way (maybe via BSF request), please provide an example
>> :)
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005261.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
No, you didn't. The reference to generic help you gave me does not contain
this.
I need a sample BSF/BSH Assetion script that evaluates a variable, please.
Say, "If variable > 5 Then Failed, Else Passed"
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> sebb
>>
>> You are not answering my question. You are confusing me with people who
>> do
>> not read manuals before asking questions.
>>
>> I have read all the help files and I did not find an answer to my
>> question!
>>
>> Could you please be more specific in your answers, in case you really
>> know
>> how this assertion works, of course.
>>
>> I need a sample BSF/BSH script that evaluates a variable and send a
>> message
>> to some listener.
>
> As I wrote before, Listeners only process samples and Assertions; I
> already explained how to generate a sample and how to use BSH to
> generate an Assertion:
>
>>
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> Yes, but please can you give me an example?
>> >>
>> >> I have spent half a day of Friday trying to do something with
>> variables
>> >> in
>> >> BSF and BSH assertions and listeners and no luck!
>> >>
>> >> All I need to do is to be able to evaluate variable and send some
>> >> message to
>> >> some listener :)
>> >>
>> >> An example will be greatly appreciated.
>> >>
>> >
>> > Read the following:
>> >
>> >
>> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
>> >
>> > It includes sample code.
>> >
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >>
>> >> >> That's not what I meant. I meant is there an assertion that can
>> >> >> conveniently
>> >> >> parse SQL results?
>> >> >>
>> >> >> E.g. my results are: table headers and 4 values. How do I check
>> that
>> >> >> e.g.
>> >> >> "Average" is < 30?
>> >> >
>> >> > JDBC can save results as variables.
>> >> >
>> >> > The Size Assertion is similar to what you want, unfortunately it
>> only
>> >> > checks size... perhaps that should be extended to check a
>> variable.
>> >> >
>> >> > Meanwhile, use a BSF or BSH Assertion to check the variable.
>> >> >
>> >> >
>> >> >>
>> >> >> sebb-2-2 wrote:
>> >> >> >
>> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >>
>> >> >> >> Hi!
>> >> >> >>
>> >> >> >> Is there any sort of response assertion for JDBC requests?
>> >> >> >
>> >> >> > All the Assertions can be used with JDBC.
>> >> >> >
>> >> >> >> Or it's RegExp Extractor only?
>> >> >> >>
>> >> >> >> If there is a way (maybe via BSF request), please provide an
>> >> example
>> >> >> :)
>> >> >> >>
>> >> >> >> --
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> >> >> Sent from the JMeter - User mailing list archive at
>> Nabble.com.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> > For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>> >> >>
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >>
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>> --
>>
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005711.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
Solution found:
if (Integer.parseInt(vars.get("AA_1")) < 30) {
Failure=true;
}
- vars.get
- if condition in brackets
- actions in brackets
- if starts with lowercase letters
- ";" after condition
- Integer.parseInt
- parseInt with lowercase at start
Why weren't you able to tell me this 3 hours ago??..
I'm happy it works, but it's so simple and I'm not a JMeter specialist, so I
regret a DAY wasted on this simple thing - just to evaluate a variable from
SQL response.
Andrey Simonov wrote:
>
> If it returns a string, why is an error message about objects?
>
> Why can't I compare two strings?
>
> How do I convert string to int or compare strings?
>
> I could not find this in internet in 10 mins.
>
>
> sebb-2-2 wrote:
>>
>> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>>
>>> We have already found this.
>>>
>>> If (vars.get("AA_1") < 30) {Failure=true }
>>>
>>
>> OK, so you have made some progress.
>>
>>> Assertion failure message: org.apache.jorphan.util.JMeterException:
>>> Error
>>>
>>> invoking bsh method: eval Sourced file: inline evaluation of: ``If
>>> (vars.get("AA_1") < "30") {Failure=true };'' : Operator: '"<"'
>>> inappropriate
>>> for objects.
>>>
>>> However vars.get is supposed to return not objects, but variable
>>> values. You
>>> can find it in help.
>>
>> Yes, it does return the variable value; however that is a String.
>>
>> So the condition is effectively something like:
>>
>> ("7" < "30")
>>
>> which - as the error message says - is not valid in BeanShell
>>
>>> I think you really have never done assertion like this :)
>>>
>>> You are wasting your time and mine, too.
>>>
>>> sebb, please, either stop answering or give me a working example.
>>>
>>> sebb-2-2 wrote:
>>> >
>>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>> >>
>>> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>>> >>
>>> >>
>>> >> sebb, you are very stubborn and you don't want to understand what I
>>> am
>>> >> asking.
>>> >
>>> > I am trying to answer your questions.
>>> >
>>> >> You have sent me links to help 3 times (!), but unfortunately you
>>> are
>>> >> the
>>> >> only one who is answering me.
>>> >>
>>> >> I'll try to be maximum specific, so that you will be not able to
>>> send me
>>> >> the
>>> >> link to help for the 4th time.
>>> >>
>>> >> I make a JDBC request, which results in a following output:
>>> >> Count(*)
>>> >> 28
>>> >>
>>> >> The output is assigned to a variable: AA.
>>> >>
>>> >> Then as a child to this request, I create a BeanShell Assertion,
>>> which
>>> >> reads:
>>> >>
>>> >> If vars.get("AA_1") < 30 Then {
>>> >> Failure=true }
>>> >>
>>> >> I get the following error:
>>> >>
>>> >> Assertion failure message: org.apache.jorphan.util.JMeterException:
>>> >> Error
>>> >> invoking bsh method: eval Parse error at line 1, column 8.
>>> >> Encountered: .
>>> >>
>>> >> Why?
>>> >>
>>> >
>>> > The phrase "Parse error" means that the code is not valid Java
>>> syntax.
>>> >
>>> > Compare your code with the following example from the link I
>>> provided:
>>> >
>>> > if (arr != null && arr.length != 25218)
>>> > {
>>> > Failure= true ;
>>> > FailureMessage = "The response data size was not as
>>> expected"
>>> > ;
>>> > }
>>> >
>>> > If you look carefully you will see that the general form of an "if"
>>> > statement is:
>>> >
>>> > if (condition) {
>>> > }
>>> >
>>> > Try fixing your code accordingly.
>>> >
>>> >>
>>> >>
>>> >> sebb-2-2 wrote:
>>> >> >
>>> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>> >> >>
>>> >> >> > I already explained how to generate a sample and how to use
>>> BSH to
>>> >> >> > generate an Assertion:
>>> >> >>
>>> >> >>
>>> >> >> No, you didn't. The reference to generic help you gave me does
>>> not
>>> >> >> contain
>>> >> >> this.
>>> >> >>
>>> >> >> I need a sample BSF/BSH Assetion script that evaluates a
>>> variable,
>>> >> >> please.
>>> >> >
>>> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>>> >> >
>>> >> >> Say, "If variable > 5 Then Failed, Else Passed"
>>> >> >>
>>> >> >>
>>> >> >>
>>> >> >> sebb-2-2 wrote:
>>> >> >> >
>>> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>> >> >> >>
>>> >> >> >> sebb
>>> >> >> >>
>>> >> >> >> You are not answering my question. You are confusing me
>>> with
>>> >> people
>>> >> >> who
>>> >> >> >> do
>>> >> >> >> not read manuals before asking questions.
>>> >> >> >>
>>> >> >> >> I have read all the help files and I did not find an answer
>>> to
>>> >> my
>>> >> >> >> question!
>>> >> >> >>
>>> >> >> >> Could you please be more specific in your answers, in case
>>> you
>>> >> >> really
>>> >> >> >> know
>>> >> >> >> how this assertion works, of course.
>>> >> >> >>
>>> >> >> >> I need a sample BSF/BSH script that evaluates a variable
>>> and
>>> >> send a
>>> >> >> >> message
>>> >> >> >> to some listener.
>>> >> >> >
>>> >> >> > As I wrote before, Listeners only process samples and
>>> Assertions;
>>> >> I
>>> >> >> > already explained how to generate a sample and how to use BSH
>>> to
>>> >> >> > generate an Assertion:
>>> >> >> >
>>> >> >> >>
>>> >> >> >>
>>> >> >> >> sebb-2-2 wrote:
>>> >> >> >> >
>>> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>> >> >> >> >>
>>> >> >> >> >> Yes, but please can you give me an example?
>>> >> >> >> >>
>>> >> >> >> >> I have spent half a day of Friday trying to do
>>> something
>>> >> with
>>> >> >> >> variables
>>> >> >> >> >> in
>>> >> >> >> >> BSF and BSH assertions and listeners and no luck!
>>> >> >> >> >>
>>> >> >> >> >> All I need to do is to be able to evaluate variable and
>>> send
>>> >> >> some
>>> >> >> >> >> message to
>>> >> >> >> >> some listener :)
>>> >> >> >> >>
>>> >> >> >> >> An example will be greatly appreciated.
>>> >> >> >> >>
>>> >> >> >> >
>>> >> >> >> > Read the following:
>>> >> >> >> >
>>> >> >> >> >
>>> >> >> >>
>>> >> >>
>>> >>
>>> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
>>> >> >> >> >
>>> >> >> >> > It includes sample code.
>>> >> >> >> >
>>> >> >> >> >>
>>> >> >> >> >> sebb-2-2 wrote:
>>> >> >> >> >> >
>>> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>> >> >> >> >> >>
>>> >> >> >> >> >> That's not what I meant. I meant is there an
>>> assertion
>>> >> that
>>> >> >> can
>>> >> >> >> >> >> conveniently
>>> >> >> >> >> >> parse SQL results?
>>> >> >> >> >> >>
>>> >> >> >> >> >> E.g. my results are: table headers and 4 values.
>>> How do
>>> >> I
>>> >> >> check
>>> >> >> >> that
>>> >> >> >> >> >> e.g.
>>> >> >> >> >> >> "Average" is < 30?
>>> >> >> >> >> >
>>> >> >> >> >> > JDBC can save results as variables.
>>> >> >> >> >> >
>>> >> >> >> >> > The Size Assertion is similar to what you want,
>>> >> unfortunately
>>> >> >> it
>>> >> >> >> only
>>> >> >> >> >> > checks size... perhaps that should be extended to
>>> check a
>>> >> >> >> variable.
>>> >> >> >> >> >
>>> >> >> >> >> > Meanwhile, use a BSF or BSH Assertion to check the
>>> >> variable.
>>> >> >> >> >> >
>>> >> >> >> >> >
>>> >> >> >> >> >>
>>> >> >> >> >> >> sebb-2-2 wrote:
>>> >> >> >> >> >> >
>>> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru>
>>> wrote:
>>> >> >> >> >> >> >>
>>> >> >> >> >> >> >> Hi!
>>> >> >> >> >> >> >>
>>> >> >> >> >> >> >> Is there any sort of response assertion for
>>> JDBC
>>> >> >> requests?
>>> >> >> >> >> >> >
>>> >> >> >> >> >> > All the Assertions can be used with JDBC.
>>> >> >> >> >> >> >
>>> >> >> >> >> >> >> Or it's RegExp Extractor only?
>>> >> >> >> >> >> >>
>>> >> >> >> >> >> >> If there is a way (maybe via BSF request),
>>> please
>>> >> >> provide an
>>> >> >> >> >> example
>>> >> >> >> >> >> :)
>>> >> >> >> >> >> >>
>>> >> >> >> >> >> >> --
>>> >> >> >> >> >> >> View this message in context:
>>> >> >> >> >> >> >>
>>> >> >> >> >> >>
>>> >> >> >> >>
>>> >> >> >>
>>> >> >>
>>> >>
>>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>>> >> >> >> >> >> >> Sent from the JMeter - User mailing list
>>> archive at
>>> >> >> >> Nabble.com.
>>> >> >> >> >> >> >>
>>> >> >> >> >> >> >>
>>> >> >> >> >> >> >>
>>> >> >> >> >> >>
>>> >> >> >>
>>> >>
>>> ---------------------------------------------------------------------
>>> >> >> >> >> >> >> To unsubscribe, e-mail:
>>> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>>> >> >> >> >> >> >> For additional commands, e-mail:
>>> >> >> >> >> jmeter-user-help@jakarta.apache.org
>>> >> >> >> >> >> >>
>>> >> >> >> >> >> >>
>>> >> >> >> >> >> >
>>> >> >> >> >> >> >
>>> >> >> >> >>
>>> >> >>
>>> ---------------------------------------------------------------------
>>> >> >> >> >> >> > To unsubscribe, e-mail:
>>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>>> >> >> >> >> >> > For additional commands, e-mail:
>>> >> >> >> >> jmeter-user-help@jakarta.apache.org
>>> >> >> >> >> >> >
>>> >> >> >> >> >> >
>>> >> >> >> >> >> >
>>> >> >> >> >> >>
>>> >> >> >> >> >>
>>> >> >> >> >> >> --
>>> >> >> >> >> >> View this message in context:
>>> >> >> >> >> >>
>>> >> >> >> >>
>>> >> >> >>
>>> >> >>
>>> >>
>>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>>> >> >> >> >> >>
>>> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
>>> >> >> Nabble.com.
>>> >> >> >> >> >>
>>> >> >> >> >> >>
>>> >> >> >> >> >>
>>> >> >> >> >>
>>> >> >>
>>> ---------------------------------------------------------------------
>>> >> >> >> >> >> To unsubscribe, e-mail:
>>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>>> >> >> >> >> >> For additional commands, e-mail:
>>> >> >> >> jmeter-user-help@jakarta.apache.org
>>> >> >> >> >> >>
>>> >> >> >> >> >>
>>> >> >> >> >> >
>>> >> >> >> >> >
>>> >> >> >>
>>> >>
>>> ---------------------------------------------------------------------
>>> >> >> >> >> > To unsubscribe, e-mail:
>>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>>> >> >> >> >> > For additional commands, e-mail:
>>> >> >> >> jmeter-user-help@jakarta.apache.org
>>> >> >> >> >> >
>>> >> >> >> >> >
>>> >> >> >> >> >
>>> >> >> >> >>
>>> >> >> >> >> --
>>> >> >> >> >>
>>> >> >> >> >> View this message in context:
>>> >> >> >> >>
>>> >> >> >>
>>> >> >>
>>> >>
>>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>>> >> >> >> >>
>>> >> >> >> >> Sent from the JMeter - User mailing list archive at
>>> >> Nabble.com.
>>> >> >> >> >>
>>> >> >> >> >>
>>> >> >> >> >>
>>> >> >> >>
>>> >>
>>> ---------------------------------------------------------------------
>>> >> >> >> >> To unsubscribe, e-mail:
>>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>>> >> >> >> >> For additional commands, e-mail:
>>> >> >> jmeter-user-help@jakarta.apache.org
>>> >> >> >> >>
>>> >> >> >> >>
>>> >> >> >> >
>>> >> >> >> >
>>> >> >>
>>> ---------------------------------------------------------------------
>>> >> >> >> > To unsubscribe, e-mail:
>>> >> jmeter-user-unsubscribe@jakarta.apache.org
>>> >> >> >> > For additional commands, e-mail:
>>> >> >> jmeter-user-help@jakarta.apache.org
>>> >> >> >> >
>>> >> >> >> >
>>> >> >> >> >
>>> >> >> >>
>>> >> >> >> --
>>> >> >> >>
>>> >> >> >> View this message in context:
>>> >> >> >>
>>> >> >>
>>> >>
>>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
>>> >> >> >>
>>> >> >> >> Sent from the JMeter - User mailing list archive at
>>> Nabble.com.
>>> >> >> >>
>>> >> >> >>
>>> >> >> >>
>>> >> >>
>>> ---------------------------------------------------------------------
>>> >> >> >> To unsubscribe, e-mail:
>>> >> jmeter-user-unsubscribe@jakarta.apache.org
>>> >> >> >> For additional commands, e-mail:
>>> >> jmeter-user-help@jakarta.apache.org
>>> >> >> >>
>>> >> >> >>
>>> >> >> >
>>> >> >> >
>>> >>
>>> ---------------------------------------------------------------------
>>> >> >> > To unsubscribe, e-mail:
>>> jmeter-user-unsubscribe@jakarta.apache.org
>>> >> >> > For additional commands, e-mail:
>>> >> jmeter-user-help@jakarta.apache.org
>>> >> >> >
>>> >> >> >
>>> >> >> >
>>> >> >>
>>> >> >> --
>>> >> >>
>>> >> >> View this message in context:
>>> >> >>
>>> >>
>>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
>>> >> >>
>>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>>> >> >>
>>> >> >>
>>> >> >>
>>> >>
>>> ---------------------------------------------------------------------
>>> >> >> To unsubscribe, e-mail:
>>> jmeter-user-unsubscribe@jakarta.apache.org
>>> >> >> For additional commands, e-mail:
>>> jmeter-user-help@jakarta.apache.org
>>> >> >>
>>> >> >>
>>> >> >
>>> >> >
>>> ---------------------------------------------------------------------
>>> >> > To unsubscribe, e-mail:
>>> jmeter-user-unsubscribe@jakarta.apache.org
>>> >> > For additional commands, e-mail:
>>> jmeter-user-help@jakarta.apache.org
>>> >> >
>>> >> >
>>> >> >
>>> >>
>>> >> --
>>> >>
>>> >> View this message in context:
>>> >>
>>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
>>> >>
>>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>>> >>
>>> >>
>>> >>
>>> ---------------------------------------------------------------------
>>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>> >> For additional commands, e-mail:
>>> jmeter-user-help@jakarta.apache.org
>>> >>
>>> >>
>>> >
>>> > ---------------------------------------------------------------------
>>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>> >
>>> >
>>> >
>>>
>>> --
>>>
>>> View this message in context:
>>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006598.html
>>>
>>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007241.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
I was just making a point that I was googling "BeanShell" and the guy
suggested looking for Java which is not obvious.
Noel O'Brien wrote:
>
> Javascript != Java
> http://en.wikipedia.org/wiki/Javascript#JavaScript_and_Java
>
> Beanshell ~= Java
> http://en.wikipedia.org/wiki/Beanshell
>
> Regards,
> Noel
>
> ----- "Andrey Simonov" <au...@bk.ru> wrote:
>>
>> > Google: java convert string to integer
>>
>> What if I don't know that Beanshell = Javascript = Java?
>>
>> That is not obvious for me. Anyway I hope someday you get punished for
>> such
>> a behaviour.
>>
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> If it returns a string, why is an error message about objects?
>> >
>> > Strings are objects in Java and BeanShell (which is Java-based)
>> >
>> >> Why can't I compare two strings?
>> >
>> > You can compare strings, but not using the arithmetic operators
>> > (except ==, but don't do that).
>> >
>> >> How do I convert string to int or compare strings?
>> >>
>> >> I could not find this in internet in 10 mins.
>> >
>> > Google: java convert string to integer
>> >
>> > Results 1 - 10 of about 9,350,000 for java convert string to integer.
>> > (0.44 seconds)
>> >
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >>
>> >> >> We have already found this.
>> >> >>
>> >> >> If (vars.get("AA_1") < 30) {Failure=true }
>> >> >>
>> >> >
>> >> > OK, so you have made some progress.
>> >> >
>> >> >> Assertion failure message: org.apache.jorphan.util.JMeterException:
>> >> >> Error
>> >> >>
>> >> >> invoking bsh method: eval Sourced file: inline evaluation of:
>> >> ``If
>> >> >> (vars.get("AA_1") < "30") {Failure=true };'' : Operator: '"<"'
>> >> >> inappropriate
>> >> >> for objects.
>> >> >>
>> >> >> However vars.get is supposed to return not objects, but variable
>> >> values.
>> >> >> You
>> >> >> can find it in help.
>> >> >
>> >> > Yes, it does return the variable value; however that is a String.
>> >> >
>> >> > So the condition is effectively something like:
>> >> >
>> >> > ("7" < "30")
>> >> >
>> >> > which - as the error message says - is not valid in BeanShell
>> >> >
>> >> >> I think you really have never done assertion like this :)
>> >> >>
>> >> >> You are wasting your time and mine, too.
>> >> >>
>> >> >> sebb, please, either stop answering or give me a working example.
>> >> >>
>> >> >> sebb-2-2 wrote:
>> >> >> >
>> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >>
>> >> >> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>> >> >> >>
>> >> >> >>
>> >> >> >> sebb, you are very stubborn and you don't want to understand
>> what
>> >> I
>> >> >> am
>> >> >> >> asking.
>> >> >> >
>> >> >> > I am trying to answer your questions.
>> >> >> >
>> >> >> >> You have sent me links to help 3 times (!), but unfortunately
>> >> you
>> >> >> are
>> >> >> >> the
>> >> >> >> only one who is answering me.
>> >> >> >>
>> >> >> >> I'll try to be maximum specific, so that you will be not able to
>> >> >> send me
>> >> >> >> the
>> >> >> >> link to help for the 4th time.
>> >> >> >>
>> >> >> >> I make a JDBC request, which results in a following output:
>> >> >> >> Count(*)
>> >> >> >> 28
>> >> >> >>
>> >> >> >> The output is assigned to a variable: AA.
>> >> >> >>
>> >> >> >> Then as a child to this request, I create a BeanShell Assertion,
>> >> >> which
>> >> >> >> reads:
>> >> >> >>
>> >> >> >> If vars.get("AA_1") < 30 Then {
>> >> >> >> Failure=true }
>> >> >> >>
>> >> >> >> I get the following error:
>> >> >> >>
>> >> >> >> Assertion failure message:
>> >> org.apache.jorphan.util.JMeterException:
>> >> >> >> Error
>> >> >> >> invoking bsh method: eval Parse error at line 1, column 8.
>> >> >> >> Encountered: .
>> >> >> >>
>> >> >> >> Why?
>> >> >> >>
>> >> >> >
>> >> >> > The phrase "Parse error" means that the code is not valid Java
>> >> syntax.
>> >> >> >
>> >> >> > Compare your code with the following example from the link I
>> >> provided:
>> >> >> >
>> >> >> > if (arr != null && arr.length != 25218)
>> >> >> > {
>> >> >> > Failure= true ;
>> >> >> > FailureMessage = "The response data size was not as
>> >> >> expected"
>> >> >> > ;
>> >> >> > }
>> >> >> >
>> >> >> > If you look carefully you will see that the general form of an
>> >> "if"
>> >> >> > statement is:
>> >> >> >
>> >> >> > if (condition) {
>> >> >> > }
>> >> >> >
>> >> >> > Try fixing your code accordingly.
>> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >> sebb-2-2 wrote:
>> >> >> >> >
>> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >>
>> >> >> >> >> > I already explained how to generate a sample and how to
>> >> use
>> >> >> BSH to
>> >> >> >> >> > generate an Assertion:
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> No, you didn't. The reference to generic help you gave me
>> >> does
>> >> >> not
>> >> >> >> >> contain
>> >> >> >> >> this.
>> >> >> >> >>
>> >> >> >> >> I need a sample BSF/BSH Assetion script that evaluates a
>> >> >> variable,
>> >> >> >> >> please.
>> >> >> >> >
>> >> >> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>> >> >> >> >
>> >> >> >> >> Say, "If variable > 5 Then Failed, Else Passed"
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >
>> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >> >>
>> >> >> >> >> >> sebb
>> >> >> >> >> >>
>> >> >> >> >> >> You are not answering my question. You are confusing me
>> >> with
>> >> >> >> people
>> >> >> >> >> who
>> >> >> >> >> >> do
>> >> >> >> >> >> not read manuals before asking questions.
>> >> >> >> >> >>
>> >> >> >> >> >> I have read all the help files and I did not find an
>> >> answer
>> >> >> to
>> >> >> >> my
>> >> >> >> >> >> question!
>> >> >> >> >> >>
>> >> >> >> >> >> Could you please be more specific in your answers, in
>> >> case
>> >> >> you
>> >> >> >> >> really
>> >> >> >> >> >> know
>> >> >> >> >> >> how this assertion works, of course.
>> >> >> >> >> >>
>> >> >> >> >> >> I need a sample BSF/BSH script that evaluates a variable
>> >> and
>> >> >> >> send a
>> >> >> >> >> >> message
>> >> >> >> >> >> to some listener.
>> >> >> >> >> >
>> >> >> >> >> > As I wrote before, Listeners only process samples and
>> >> >> Assertions;
>> >> >> >> I
>> >> >> >> >> > already explained how to generate a sample and how to use
>> >> BSH
>> >> >> to
>> >> >> >> >> > generate an Assertion:
>> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >> >
>> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Yes, but please can you give me an example?
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> I have spent half a day of Friday trying to do
>> >> something
>> >> >> >> with
>> >> >> >> >> >> variables
>> >> >> >> >> >> >> in
>> >> >> >> >> >> >> BSF and BSH assertions and listeners and no luck!
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> All I need to do is to be able to evaluate variable
>> >> and
>> >> >> send
>> >> >> >> >> some
>> >> >> >> >> >> >> message to
>> >> >> >> >> >> >> some listener :)
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> An example will be greatly appreciated.
>> >> >> >> >> >> >>
>> >> >> >> >> >> >
>> >> >> >> >> >> > Read the following:
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
>> >> >> >> >> >> >
>> >> >> >> >> >> > It includes sample code.
>> >> >> >> >> >> >
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> That's not what I meant. I meant is there an
>> >> >> assertion
>> >> >> >> that
>> >> >> >> >> can
>> >> >> >> >> >> >> >> conveniently
>> >> >> >> >> >> >> >> parse SQL results?
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> E.g. my results are: table headers and 4 values.
>> >> How
>> >> >> do
>> >> >> >> I
>> >> >> >> >> check
>> >> >> >> >> >> that
>> >> >> >> >> >> >> >> e.g.
>> >> >> >> >> >> >> >> "Average" is < 30?
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> > JDBC can save results as variables.
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> > The Size Assertion is similar to what you want,
>> >> >> >> unfortunately
>> >> >> >> >> it
>> >> >> >> >> >> only
>> >> >> >> >> >> >> > checks size... perhaps that should be extended to
>> >> >> check a
>> >> >> >> >> >> variable.
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> > Meanwhile, use a BSF or BSH Assertion to check the
>> >> >> >> variable.
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru>
>> >> wrote:
>> >> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> >> Hi!
>> >> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> >> Is there any sort of response assertion for
>> >> JDBC
>> >> >> >> >> requests?
>> >> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >> > All the Assertions can be used with JDBC.
>> >> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >> >> Or it's RegExp Extractor only?
>> >> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> >> If there is a way (maybe via BSF request),
>> >> >> please
>> >> >> >> >> provide an
>> >> >> >> >> >> >> example
>> >> >> >> >> >> >> >> :)
>> >> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> >> --
>> >> >> >> >> >> >> >> >> View this message in context:
>> >> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> >> >> >> >> >> >> >> Sent from the JMeter - User mailing list
>> >> archive
>> >> >> at
>> >> >> >> >> >> Nabble.com.
>> >> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >> >
>> >> >> >> >> >> >>
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> --
>> >> >> >> >> >> >> >> View this message in context:
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive
>> >> at
>> >> >> >> >> Nabble.com.
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> --
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> View this message in context:
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> >> >> Nabble.com.
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >> --
>> >> >> >> >> >>
>> >> >> >> >> >> View this message in context:
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
>> >> >> >> >> >>
>> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> >> Nabble.com.
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >>
>> >> >> >> >> View this message in context:
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
>> >> >> >> >>
>> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> Nabble.com.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> > To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> > For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >> --
>> >> >> >>
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
>> >> >> >>
>> >> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> > For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >>
>> >> >> View this message in context:
>> >> >>
>> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006598.html
>> >> >>
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >>
>> >> View this message in context:
>> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007044.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007374.html
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007652.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Noel O'Brien <no...@newbay.com>.
Javascript != Java
http://en.wikipedia.org/wiki/Javascript#JavaScript_and_Java
Beanshell ~= Java
http://en.wikipedia.org/wiki/Beanshell
Regards,
Noel
----- "Andrey Simonov" <au...@bk.ru> wrote:
>
> > Google: java convert string to integer
>
> What if I don't know that Beanshell = Javascript = Java?
>
> That is not obvious for me. Anyway I hope someday you get punished for such
> a behaviour.
>
>
> sebb-2-2 wrote:
> >
> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >>
> >> If it returns a string, why is an error message about objects?
> >
> > Strings are objects in Java and BeanShell (which is Java-based)
> >
> >> Why can't I compare two strings?
> >
> > You can compare strings, but not using the arithmetic operators
> > (except ==, but don't do that).
> >
> >> How do I convert string to int or compare strings?
> >>
> >> I could not find this in internet in 10 mins.
> >
> > Google: java convert string to integer
> >
> > Results 1 - 10 of about 9,350,000 for java convert string to integer.
> > (0.44 seconds)
> >
> >>
> >> sebb-2-2 wrote:
> >> >
> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >>
> >> >> We have already found this.
> >> >>
> >> >> If (vars.get("AA_1") < 30) {Failure=true }
> >> >>
> >> >
> >> > OK, so you have made some progress.
> >> >
> >> >> Assertion failure message: org.apache.jorphan.util.JMeterException:
> >> >> Error
> >> >>
> >> >> invoking bsh method: eval Sourced file: inline evaluation of:
> >> ``If
> >> >> (vars.get("AA_1") < "30") {Failure=true };'' : Operator: '"<"'
> >> >> inappropriate
> >> >> for objects.
> >> >>
> >> >> However vars.get is supposed to return not objects, but variable
> >> values.
> >> >> You
> >> >> can find it in help.
> >> >
> >> > Yes, it does return the variable value; however that is a String.
> >> >
> >> > So the condition is effectively something like:
> >> >
> >> > ("7" < "30")
> >> >
> >> > which - as the error message says - is not valid in BeanShell
> >> >
> >> >> I think you really have never done assertion like this :)
> >> >>
> >> >> You are wasting your time and mine, too.
> >> >>
> >> >> sebb, please, either stop answering or give me a working example.
> >> >>
> >> >> sebb-2-2 wrote:
> >> >> >
> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >>
> >> >> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
> >> >> >>
> >> >> >>
> >> >> >> sebb, you are very stubborn and you don't want to understand what
> >> I
> >> >> am
> >> >> >> asking.
> >> >> >
> >> >> > I am trying to answer your questions.
> >> >> >
> >> >> >> You have sent me links to help 3 times (!), but unfortunately
> >> you
> >> >> are
> >> >> >> the
> >> >> >> only one who is answering me.
> >> >> >>
> >> >> >> I'll try to be maximum specific, so that you will be not able to
> >> >> send me
> >> >> >> the
> >> >> >> link to help for the 4th time.
> >> >> >>
> >> >> >> I make a JDBC request, which results in a following output:
> >> >> >> Count(*)
> >> >> >> 28
> >> >> >>
> >> >> >> The output is assigned to a variable: AA.
> >> >> >>
> >> >> >> Then as a child to this request, I create a BeanShell Assertion,
> >> >> which
> >> >> >> reads:
> >> >> >>
> >> >> >> If vars.get("AA_1") < 30 Then {
> >> >> >> Failure=true }
> >> >> >>
> >> >> >> I get the following error:
> >> >> >>
> >> >> >> Assertion failure message:
> >> org.apache.jorphan.util.JMeterException:
> >> >> >> Error
> >> >> >> invoking bsh method: eval Parse error at line 1, column 8.
> >> >> >> Encountered: .
> >> >> >>
> >> >> >> Why?
> >> >> >>
> >> >> >
> >> >> > The phrase "Parse error" means that the code is not valid Java
> >> syntax.
> >> >> >
> >> >> > Compare your code with the following example from the link I
> >> provided:
> >> >> >
> >> >> > if (arr != null && arr.length != 25218)
> >> >> > {
> >> >> > Failure= true ;
> >> >> > FailureMessage = "The response data size was not as
> >> >> expected"
> >> >> > ;
> >> >> > }
> >> >> >
> >> >> > If you look carefully you will see that the general form of an
> >> "if"
> >> >> > statement is:
> >> >> >
> >> >> > if (condition) {
> >> >> > }
> >> >> >
> >> >> > Try fixing your code accordingly.
> >> >> >
> >> >> >>
> >> >> >>
> >> >> >> sebb-2-2 wrote:
> >> >> >> >
> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >>
> >> >> >> >> > I already explained how to generate a sample and how to
> >> use
> >> >> BSH to
> >> >> >> >> > generate an Assertion:
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> No, you didn't. The reference to generic help you gave me
> >> does
> >> >> not
> >> >> >> >> contain
> >> >> >> >> this.
> >> >> >> >>
> >> >> >> >> I need a sample BSF/BSH Assetion script that evaluates a
> >> >> variable,
> >> >> >> >> please.
> >> >> >> >
> >> >> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
> >> >> >> >
> >> >> >> >> Say, "If variable > 5 Then Failed, Else Passed"
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> sebb-2-2 wrote:
> >> >> >> >> >
> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >> >>
> >> >> >> >> >> sebb
> >> >> >> >> >>
> >> >> >> >> >> You are not answering my question. You are confusing me
> >> with
> >> >> >> people
> >> >> >> >> who
> >> >> >> >> >> do
> >> >> >> >> >> not read manuals before asking questions.
> >> >> >> >> >>
> >> >> >> >> >> I have read all the help files and I did not find an
> >> answer
> >> >> to
> >> >> >> my
> >> >> >> >> >> question!
> >> >> >> >> >>
> >> >> >> >> >> Could you please be more specific in your answers, in
> >> case
> >> >> you
> >> >> >> >> really
> >> >> >> >> >> know
> >> >> >> >> >> how this assertion works, of course.
> >> >> >> >> >>
> >> >> >> >> >> I need a sample BSF/BSH script that evaluates a variable
> >> and
> >> >> >> send a
> >> >> >> >> >> message
> >> >> >> >> >> to some listener.
> >> >> >> >> >
> >> >> >> >> > As I wrote before, Listeners only process samples and
> >> >> Assertions;
> >> >> >> I
> >> >> >> >> > already explained how to generate a sample and how to use
> >> BSH
> >> >> to
> >> >> >> >> > generate an Assertion:
> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> sebb-2-2 wrote:
> >> >> >> >> >> >
> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >> >> >>
> >> >> >> >> >> >> Yes, but please can you give me an example?
> >> >> >> >> >> >>
> >> >> >> >> >> >> I have spent half a day of Friday trying to do
> >> something
> >> >> >> with
> >> >> >> >> >> variables
> >> >> >> >> >> >> in
> >> >> >> >> >> >> BSF and BSH assertions and listeners and no luck!
> >> >> >> >> >> >>
> >> >> >> >> >> >> All I need to do is to be able to evaluate variable
> >> and
> >> >> send
> >> >> >> >> some
> >> >> >> >> >> >> message to
> >> >> >> >> >> >> some listener :)
> >> >> >> >> >> >>
> >> >> >> >> >> >> An example will be greatly appreciated.
> >> >> >> >> >> >>
> >> >> >> >> >> >
> >> >> >> >> >> > Read the following:
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
> >> >> >> >> >> >
> >> >> >> >> >> > It includes sample code.
> >> >> >> >> >> >
> >> >> >> >> >> >>
> >> >> >> >> >> >> sebb-2-2 wrote:
> >> >> >> >> >> >> >
> >> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> That's not what I meant. I meant is there an
> >> >> assertion
> >> >> >> that
> >> >> >> >> can
> >> >> >> >> >> >> >> conveniently
> >> >> >> >> >> >> >> parse SQL results?
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> E.g. my results are: table headers and 4 values.
> >> How
> >> >> do
> >> >> >> I
> >> >> >> >> check
> >> >> >> >> >> that
> >> >> >> >> >> >> >> e.g.
> >> >> >> >> >> >> >> "Average" is < 30?
> >> >> >> >> >> >> >
> >> >> >> >> >> >> > JDBC can save results as variables.
> >> >> >> >> >> >> >
> >> >> >> >> >> >> > The Size Assertion is similar to what you want,
> >> >> >> unfortunately
> >> >> >> >> it
> >> >> >> >> >> only
> >> >> >> >> >> >> > checks size... perhaps that should be extended to
> >> >> check a
> >> >> >> >> >> variable.
> >> >> >> >> >> >> >
> >> >> >> >> >> >> > Meanwhile, use a BSF or BSH Assertion to check the
> >> >> >> variable.
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> sebb-2-2 wrote:
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru>
> >> wrote:
> >> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> >> Hi!
> >> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> >> Is there any sort of response assertion for
> >> JDBC
> >> >> >> >> requests?
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >> >> > All the Assertions can be used with JDBC.
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >> >> >> Or it's RegExp Extractor only?
> >> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> >> If there is a way (maybe via BSF request),
> >> >> please
> >> >> >> >> provide an
> >> >> >> >> >> >> example
> >> >> >> >> >> >> >> :)
> >> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> >> --
> >> >> >> >> >> >> >> >> View this message in context:
> >> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
> >> >> >> >> >> >> >> >> Sent from the JMeter - User mailing list
> >> archive
> >> >> at
> >> >> >> >> >> Nabble.com.
> >> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> >> >> >> >> To unsubscribe, e-mail:
> >> >> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> >> >> >> For additional commands, e-mail:
> >> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >>
> >> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> >> >> >> >> > To unsubscribe, e-mail:
> >> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> >> >> > For additional commands, e-mail:
> >> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> --
> >> >> >> >> >> >> >> View this message in context:
> >> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive
> >> at
> >> >> >> >> Nabble.com.
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> >> >> >> >> To unsubscribe, e-mail:
> >> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> >> >> For additional commands, e-mail:
> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> >> >> > To unsubscribe, e-mail:
> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> >> > For additional commands, e-mail:
> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >
> >> >> >> >> >> >>
> >> >> >> >> >> >> --
> >> >> >> >> >> >>
> >> >> >> >> >> >> View this message in context:
> >> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
> >> >> >> >> >> >>
> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> >> >> Nabble.com.
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> >> >> To unsubscribe, e-mail:
> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> >> For additional commands, e-mail:
> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> >> >> > To unsubscribe, e-mail:
> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> > For additional commands, e-mail:
> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >>
> >> >> >> >> >> View this message in context:
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
> >> >> >> >> >>
> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> >> Nabble.com.
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> >> >> To unsubscribe, e-mail:
> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> For additional commands, e-mail:
> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >
> >> >> >> >> >
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> > To unsubscribe, e-mail:
> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> > For additional commands, e-mail:
> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >>
> >> >> >> >> View this message in context:
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
> >> >> >> >>
> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> Nabble.com.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> To unsubscribe, e-mail:
> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> For additional commands, e-mail:
> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >>
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> ---------------------------------------------------------------------
> >> >> >> > To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> > For additional commands, e-mail:
> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >> --
> >> >> >>
> >> >> >> View this message in context:
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
> >> >> >>
> >> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> ---------------------------------------------------------------------
> >> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> > For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >> --
> >> >>
> >> >> View this message in context:
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006598.html
> >> >>
> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >>
> >> >>
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> >>
> >> --
> >>
> >> View this message in context:
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007044.html
> >>
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> --
> View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007374.html
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
> Google: java convert string to integer
What if I don't know that Beanshell = Javascript = Java?
That is not obvious for me. Anyway I hope someday you get punished for such
a behaviour.
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> If it returns a string, why is an error message about objects?
>
> Strings are objects in Java and BeanShell (which is Java-based)
>
>> Why can't I compare two strings?
>
> You can compare strings, but not using the arithmetic operators
> (except ==, but don't do that).
>
>> How do I convert string to int or compare strings?
>>
>> I could not find this in internet in 10 mins.
>
> Google: java convert string to integer
>
> Results 1 - 10 of about 9,350,000 for java convert string to integer.
> (0.44 seconds)
>
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> We have already found this.
>> >>
>> >> If (vars.get("AA_1") < 30) {Failure=true }
>> >>
>> >
>> > OK, so you have made some progress.
>> >
>> >> Assertion failure message: org.apache.jorphan.util.JMeterException:
>> >> Error
>> >>
>> >> invoking bsh method: eval Sourced file: inline evaluation of:
>> ``If
>> >> (vars.get("AA_1") < "30") {Failure=true };'' : Operator: '"<"'
>> >> inappropriate
>> >> for objects.
>> >>
>> >> However vars.get is supposed to return not objects, but variable
>> values.
>> >> You
>> >> can find it in help.
>> >
>> > Yes, it does return the variable value; however that is a String.
>> >
>> > So the condition is effectively something like:
>> >
>> > ("7" < "30")
>> >
>> > which - as the error message says - is not valid in BeanShell
>> >
>> >> I think you really have never done assertion like this :)
>> >>
>> >> You are wasting your time and mine, too.
>> >>
>> >> sebb, please, either stop answering or give me a working example.
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >>
>> >> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>> >> >>
>> >> >>
>> >> >> sebb, you are very stubborn and you don't want to understand what
>> I
>> >> am
>> >> >> asking.
>> >> >
>> >> > I am trying to answer your questions.
>> >> >
>> >> >> You have sent me links to help 3 times (!), but unfortunately
>> you
>> >> are
>> >> >> the
>> >> >> only one who is answering me.
>> >> >>
>> >> >> I'll try to be maximum specific, so that you will be not able to
>> >> send me
>> >> >> the
>> >> >> link to help for the 4th time.
>> >> >>
>> >> >> I make a JDBC request, which results in a following output:
>> >> >> Count(*)
>> >> >> 28
>> >> >>
>> >> >> The output is assigned to a variable: AA.
>> >> >>
>> >> >> Then as a child to this request, I create a BeanShell Assertion,
>> >> which
>> >> >> reads:
>> >> >>
>> >> >> If vars.get("AA_1") < 30 Then {
>> >> >> Failure=true }
>> >> >>
>> >> >> I get the following error:
>> >> >>
>> >> >> Assertion failure message:
>> org.apache.jorphan.util.JMeterException:
>> >> >> Error
>> >> >> invoking bsh method: eval Parse error at line 1, column 8.
>> >> >> Encountered: .
>> >> >>
>> >> >> Why?
>> >> >>
>> >> >
>> >> > The phrase "Parse error" means that the code is not valid Java
>> syntax.
>> >> >
>> >> > Compare your code with the following example from the link I
>> provided:
>> >> >
>> >> > if (arr != null && arr.length != 25218)
>> >> > {
>> >> > Failure= true ;
>> >> > FailureMessage = "The response data size was not as
>> >> expected"
>> >> > ;
>> >> > }
>> >> >
>> >> > If you look carefully you will see that the general form of an
>> "if"
>> >> > statement is:
>> >> >
>> >> > if (condition) {
>> >> > }
>> >> >
>> >> > Try fixing your code accordingly.
>> >> >
>> >> >>
>> >> >>
>> >> >> sebb-2-2 wrote:
>> >> >> >
>> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >>
>> >> >> >> > I already explained how to generate a sample and how to
>> use
>> >> BSH to
>> >> >> >> > generate an Assertion:
>> >> >> >>
>> >> >> >>
>> >> >> >> No, you didn't. The reference to generic help you gave me
>> does
>> >> not
>> >> >> >> contain
>> >> >> >> this.
>> >> >> >>
>> >> >> >> I need a sample BSF/BSH Assetion script that evaluates a
>> >> variable,
>> >> >> >> please.
>> >> >> >
>> >> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>> >> >> >
>> >> >> >> Say, "If variable > 5 Then Failed, Else Passed"
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> sebb-2-2 wrote:
>> >> >> >> >
>> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >>
>> >> >> >> >> sebb
>> >> >> >> >>
>> >> >> >> >> You are not answering my question. You are confusing me
>> with
>> >> >> people
>> >> >> >> who
>> >> >> >> >> do
>> >> >> >> >> not read manuals before asking questions.
>> >> >> >> >>
>> >> >> >> >> I have read all the help files and I did not find an
>> answer
>> >> to
>> >> >> my
>> >> >> >> >> question!
>> >> >> >> >>
>> >> >> >> >> Could you please be more specific in your answers, in
>> case
>> >> you
>> >> >> >> really
>> >> >> >> >> know
>> >> >> >> >> how this assertion works, of course.
>> >> >> >> >>
>> >> >> >> >> I need a sample BSF/BSH script that evaluates a variable
>> and
>> >> >> send a
>> >> >> >> >> message
>> >> >> >> >> to some listener.
>> >> >> >> >
>> >> >> >> > As I wrote before, Listeners only process samples and
>> >> Assertions;
>> >> >> I
>> >> >> >> > already explained how to generate a sample and how to use
>> BSH
>> >> to
>> >> >> >> > generate an Assertion:
>> >> >> >> >
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >
>> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >> >>
>> >> >> >> >> >> Yes, but please can you give me an example?
>> >> >> >> >> >>
>> >> >> >> >> >> I have spent half a day of Friday trying to do
>> something
>> >> >> with
>> >> >> >> >> variables
>> >> >> >> >> >> in
>> >> >> >> >> >> BSF and BSH assertions and listeners and no luck!
>> >> >> >> >> >>
>> >> >> >> >> >> All I need to do is to be able to evaluate variable
>> and
>> >> send
>> >> >> >> some
>> >> >> >> >> >> message to
>> >> >> >> >> >> some listener :)
>> >> >> >> >> >>
>> >> >> >> >> >> An example will be greatly appreciated.
>> >> >> >> >> >>
>> >> >> >> >> >
>> >> >> >> >> > Read the following:
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
>> >> >> >> >> >
>> >> >> >> >> > It includes sample code.
>> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >> >
>> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> That's not what I meant. I meant is there an
>> >> assertion
>> >> >> that
>> >> >> >> can
>> >> >> >> >> >> >> conveniently
>> >> >> >> >> >> >> parse SQL results?
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> E.g. my results are: table headers and 4 values.
>> How
>> >> do
>> >> >> I
>> >> >> >> check
>> >> >> >> >> that
>> >> >> >> >> >> >> e.g.
>> >> >> >> >> >> >> "Average" is < 30?
>> >> >> >> >> >> >
>> >> >> >> >> >> > JDBC can save results as variables.
>> >> >> >> >> >> >
>> >> >> >> >> >> > The Size Assertion is similar to what you want,
>> >> >> unfortunately
>> >> >> >> it
>> >> >> >> >> only
>> >> >> >> >> >> > checks size... perhaps that should be extended to
>> >> check a
>> >> >> >> >> variable.
>> >> >> >> >> >> >
>> >> >> >> >> >> > Meanwhile, use a BSF or BSH Assertion to check the
>> >> >> variable.
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru>
>> wrote:
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> Hi!
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> Is there any sort of response assertion for
>> JDBC
>> >> >> >> requests?
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> > All the Assertions can be used with JDBC.
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >> Or it's RegExp Extractor only?
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> If there is a way (maybe via BSF request),
>> >> please
>> >> >> >> provide an
>> >> >> >> >> >> example
>> >> >> >> >> >> >> :)
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >> --
>> >> >> >> >> >> >> >> View this message in context:
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> >> >> >> >> >> >> Sent from the JMeter - User mailing list
>> archive
>> >> at
>> >> >> >> >> Nabble.com.
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >>
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> --
>> >> >> >> >> >> >> View this message in context:
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive
>> at
>> >> >> >> Nabble.com.
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >> --
>> >> >> >> >> >>
>> >> >> >> >> >> View this message in context:
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>> >> >> >> >> >>
>> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> >> Nabble.com.
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >>
>> >> >> >> >> View this message in context:
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
>> >> >> >> >>
>> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> Nabble.com.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> > To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> > For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >> --
>> >> >> >>
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
>> >> >> >>
>> >> >> >> Sent from the JMeter - User mailing list archive at
>> Nabble.com.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> > For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >>
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
>> >> >>
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >>
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006598.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>> --
>>
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007044.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007374.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by sebb <se...@gmail.com>.
On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>
> If it returns a string, why is an error message about objects?
Strings are objects in Java and BeanShell (which is Java-based)
> Why can't I compare two strings?
You can compare strings, but not using the arithmetic operators
(except ==, but don't do that).
> How do I convert string to int or compare strings?
>
> I could not find this in internet in 10 mins.
Google: java convert string to integer
Results 1 - 10 of about 9,350,000 for java convert string to integer.
(0.44 seconds)
>
> sebb-2-2 wrote:
> >
> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >>
> >> We have already found this.
> >>
> >> If (vars.get("AA_1") < 30) {Failure=true }
> >>
> >
> > OK, so you have made some progress.
> >
> >> Assertion failure message: org.apache.jorphan.util.JMeterException:
> >> Error
> >>
> >> invoking bsh method: eval Sourced file: inline evaluation of: ``If
> >> (vars.get("AA_1") < "30") {Failure=true };'' : Operator: '"<"'
> >> inappropriate
> >> for objects.
> >>
> >> However vars.get is supposed to return not objects, but variable values.
> >> You
> >> can find it in help.
> >
> > Yes, it does return the variable value; however that is a String.
> >
> > So the condition is effectively something like:
> >
> > ("7" < "30")
> >
> > which - as the error message says - is not valid in BeanShell
> >
> >> I think you really have never done assertion like this :)
> >>
> >> You are wasting your time and mine, too.
> >>
> >> sebb, please, either stop answering or give me a working example.
> >>
> >> sebb-2-2 wrote:
> >> >
> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >>
> >> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
> >> >>
> >> >>
> >> >> sebb, you are very stubborn and you don't want to understand what I
> >> am
> >> >> asking.
> >> >
> >> > I am trying to answer your questions.
> >> >
> >> >> You have sent me links to help 3 times (!), but unfortunately you
> >> are
> >> >> the
> >> >> only one who is answering me.
> >> >>
> >> >> I'll try to be maximum specific, so that you will be not able to
> >> send me
> >> >> the
> >> >> link to help for the 4th time.
> >> >>
> >> >> I make a JDBC request, which results in a following output:
> >> >> Count(*)
> >> >> 28
> >> >>
> >> >> The output is assigned to a variable: AA.
> >> >>
> >> >> Then as a child to this request, I create a BeanShell Assertion,
> >> which
> >> >> reads:
> >> >>
> >> >> If vars.get("AA_1") < 30 Then {
> >> >> Failure=true }
> >> >>
> >> >> I get the following error:
> >> >>
> >> >> Assertion failure message: org.apache.jorphan.util.JMeterException:
> >> >> Error
> >> >> invoking bsh method: eval Parse error at line 1, column 8.
> >> >> Encountered: .
> >> >>
> >> >> Why?
> >> >>
> >> >
> >> > The phrase "Parse error" means that the code is not valid Java syntax.
> >> >
> >> > Compare your code with the following example from the link I provided:
> >> >
> >> > if (arr != null && arr.length != 25218)
> >> > {
> >> > Failure= true ;
> >> > FailureMessage = "The response data size was not as
> >> expected"
> >> > ;
> >> > }
> >> >
> >> > If you look carefully you will see that the general form of an "if"
> >> > statement is:
> >> >
> >> > if (condition) {
> >> > }
> >> >
> >> > Try fixing your code accordingly.
> >> >
> >> >>
> >> >>
> >> >> sebb-2-2 wrote:
> >> >> >
> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >>
> >> >> >> > I already explained how to generate a sample and how to use
> >> BSH to
> >> >> >> > generate an Assertion:
> >> >> >>
> >> >> >>
> >> >> >> No, you didn't. The reference to generic help you gave me does
> >> not
> >> >> >> contain
> >> >> >> this.
> >> >> >>
> >> >> >> I need a sample BSF/BSH Assetion script that evaluates a
> >> variable,
> >> >> >> please.
> >> >> >
> >> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
> >> >> >
> >> >> >> Say, "If variable > 5 Then Failed, Else Passed"
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> sebb-2-2 wrote:
> >> >> >> >
> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >>
> >> >> >> >> sebb
> >> >> >> >>
> >> >> >> >> You are not answering my question. You are confusing me with
> >> >> people
> >> >> >> who
> >> >> >> >> do
> >> >> >> >> not read manuals before asking questions.
> >> >> >> >>
> >> >> >> >> I have read all the help files and I did not find an answer
> >> to
> >> >> my
> >> >> >> >> question!
> >> >> >> >>
> >> >> >> >> Could you please be more specific in your answers, in case
> >> you
> >> >> >> really
> >> >> >> >> know
> >> >> >> >> how this assertion works, of course.
> >> >> >> >>
> >> >> >> >> I need a sample BSF/BSH script that evaluates a variable and
> >> >> send a
> >> >> >> >> message
> >> >> >> >> to some listener.
> >> >> >> >
> >> >> >> > As I wrote before, Listeners only process samples and
> >> Assertions;
> >> >> I
> >> >> >> > already explained how to generate a sample and how to use BSH
> >> to
> >> >> >> > generate an Assertion:
> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> sebb-2-2 wrote:
> >> >> >> >> >
> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >> >>
> >> >> >> >> >> Yes, but please can you give me an example?
> >> >> >> >> >>
> >> >> >> >> >> I have spent half a day of Friday trying to do something
> >> >> with
> >> >> >> >> variables
> >> >> >> >> >> in
> >> >> >> >> >> BSF and BSH assertions and listeners and no luck!
> >> >> >> >> >>
> >> >> >> >> >> All I need to do is to be able to evaluate variable and
> >> send
> >> >> >> some
> >> >> >> >> >> message to
> >> >> >> >> >> some listener :)
> >> >> >> >> >>
> >> >> >> >> >> An example will be greatly appreciated.
> >> >> >> >> >>
> >> >> >> >> >
> >> >> >> >> > Read the following:
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
> >> >> >> >> >
> >> >> >> >> > It includes sample code.
> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >> sebb-2-2 wrote:
> >> >> >> >> >> >
> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >> >> >>
> >> >> >> >> >> >> That's not what I meant. I meant is there an
> >> assertion
> >> >> that
> >> >> >> can
> >> >> >> >> >> >> conveniently
> >> >> >> >> >> >> parse SQL results?
> >> >> >> >> >> >>
> >> >> >> >> >> >> E.g. my results are: table headers and 4 values. How
> >> do
> >> >> I
> >> >> >> check
> >> >> >> >> that
> >> >> >> >> >> >> e.g.
> >> >> >> >> >> >> "Average" is < 30?
> >> >> >> >> >> >
> >> >> >> >> >> > JDBC can save results as variables.
> >> >> >> >> >> >
> >> >> >> >> >> > The Size Assertion is similar to what you want,
> >> >> unfortunately
> >> >> >> it
> >> >> >> >> only
> >> >> >> >> >> > checks size... perhaps that should be extended to
> >> check a
> >> >> >> >> variable.
> >> >> >> >> >> >
> >> >> >> >> >> > Meanwhile, use a BSF or BSH Assertion to check the
> >> >> variable.
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >> >>
> >> >> >> >> >> >> sebb-2-2 wrote:
> >> >> >> >> >> >> >
> >> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> Hi!
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> Is there any sort of response assertion for JDBC
> >> >> >> requests?
> >> >> >> >> >> >> >
> >> >> >> >> >> >> > All the Assertions can be used with JDBC.
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >> Or it's RegExp Extractor only?
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> If there is a way (maybe via BSF request),
> >> please
> >> >> >> provide an
> >> >> >> >> >> example
> >> >> >> >> >> >> :)
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >> --
> >> >> >> >> >> >> >> View this message in context:
> >> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
> >> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive
> >> at
> >> >> >> >> Nabble.com.
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> >> >> >> >> To unsubscribe, e-mail:
> >> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> >> >> For additional commands, e-mail:
> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >>
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> >> >> > To unsubscribe, e-mail:
> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> >> > For additional commands, e-mail:
> >> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >> --
> >> >> >> >> >> >> View this message in context:
> >> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
> >> >> >> >> >> >>
> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> >> >> Nabble.com.
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> >> >> To unsubscribe, e-mail:
> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> >> For additional commands, e-mail:
> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> >> >> > To unsubscribe, e-mail:
> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> > For additional commands, e-mail:
> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >>
> >> >> >> >> >> View this message in context:
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
> >> >> >> >> >>
> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> >> Nabble.com.
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> >> >> To unsubscribe, e-mail:
> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> For additional commands, e-mail:
> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >
> >> >> >> >> >
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> > To unsubscribe, e-mail:
> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> > For additional commands, e-mail:
> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >>
> >> >> >> >> View this message in context:
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
> >> >> >> >>
> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> Nabble.com.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> To unsubscribe, e-mail:
> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> For additional commands, e-mail:
> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >>
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> ---------------------------------------------------------------------
> >> >> >> > To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> > For additional commands, e-mail:
> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >> --
> >> >> >>
> >> >> >> View this message in context:
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
> >> >> >>
> >> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> ---------------------------------------------------------------------
> >> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> > For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >> --
> >> >>
> >> >> View this message in context:
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
> >> >>
> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >>
> >> >>
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> >>
> >> --
> >>
> >> View this message in context:
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006598.html
> >>
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> --
>
> View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007044.html
>
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
If it returns a string, why is an error message about objects?
Why can't I compare two strings?
How do I convert string to int or compare strings?
I could not find this in internet in 10 mins.
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> We have already found this.
>>
>> If (vars.get("AA_1") < 30) {Failure=true }
>>
>
> OK, so you have made some progress.
>
>> Assertion failure message: org.apache.jorphan.util.JMeterException:
>> Error
>>
>> invoking bsh method: eval Sourced file: inline evaluation of: ``If
>> (vars.get("AA_1") < "30") {Failure=true };'' : Operator: '"<"'
>> inappropriate
>> for objects.
>>
>> However vars.get is supposed to return not objects, but variable values.
>> You
>> can find it in help.
>
> Yes, it does return the variable value; however that is a String.
>
> So the condition is effectively something like:
>
> ("7" < "30")
>
> which - as the error message says - is not valid in BeanShell
>
>> I think you really have never done assertion like this :)
>>
>> You are wasting your time and mine, too.
>>
>> sebb, please, either stop answering or give me a working example.
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>> >>
>> >>
>> >> sebb, you are very stubborn and you don't want to understand what I
>> am
>> >> asking.
>> >
>> > I am trying to answer your questions.
>> >
>> >> You have sent me links to help 3 times (!), but unfortunately you
>> are
>> >> the
>> >> only one who is answering me.
>> >>
>> >> I'll try to be maximum specific, so that you will be not able to
>> send me
>> >> the
>> >> link to help for the 4th time.
>> >>
>> >> I make a JDBC request, which results in a following output:
>> >> Count(*)
>> >> 28
>> >>
>> >> The output is assigned to a variable: AA.
>> >>
>> >> Then as a child to this request, I create a BeanShell Assertion,
>> which
>> >> reads:
>> >>
>> >> If vars.get("AA_1") < 30 Then {
>> >> Failure=true }
>> >>
>> >> I get the following error:
>> >>
>> >> Assertion failure message: org.apache.jorphan.util.JMeterException:
>> >> Error
>> >> invoking bsh method: eval Parse error at line 1, column 8.
>> >> Encountered: .
>> >>
>> >> Why?
>> >>
>> >
>> > The phrase "Parse error" means that the code is not valid Java syntax.
>> >
>> > Compare your code with the following example from the link I provided:
>> >
>> > if (arr != null && arr.length != 25218)
>> > {
>> > Failure= true ;
>> > FailureMessage = "The response data size was not as
>> expected"
>> > ;
>> > }
>> >
>> > If you look carefully you will see that the general form of an "if"
>> > statement is:
>> >
>> > if (condition) {
>> > }
>> >
>> > Try fixing your code accordingly.
>> >
>> >>
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >>
>> >> >> > I already explained how to generate a sample and how to use
>> BSH to
>> >> >> > generate an Assertion:
>> >> >>
>> >> >>
>> >> >> No, you didn't. The reference to generic help you gave me does
>> not
>> >> >> contain
>> >> >> this.
>> >> >>
>> >> >> I need a sample BSF/BSH Assetion script that evaluates a
>> variable,
>> >> >> please.
>> >> >
>> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>> >> >
>> >> >> Say, "If variable > 5 Then Failed, Else Passed"
>> >> >>
>> >> >>
>> >> >>
>> >> >> sebb-2-2 wrote:
>> >> >> >
>> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >>
>> >> >> >> sebb
>> >> >> >>
>> >> >> >> You are not answering my question. You are confusing me with
>> >> people
>> >> >> who
>> >> >> >> do
>> >> >> >> not read manuals before asking questions.
>> >> >> >>
>> >> >> >> I have read all the help files and I did not find an answer
>> to
>> >> my
>> >> >> >> question!
>> >> >> >>
>> >> >> >> Could you please be more specific in your answers, in case
>> you
>> >> >> really
>> >> >> >> know
>> >> >> >> how this assertion works, of course.
>> >> >> >>
>> >> >> >> I need a sample BSF/BSH script that evaluates a variable and
>> >> send a
>> >> >> >> message
>> >> >> >> to some listener.
>> >> >> >
>> >> >> > As I wrote before, Listeners only process samples and
>> Assertions;
>> >> I
>> >> >> > already explained how to generate a sample and how to use BSH
>> to
>> >> >> > generate an Assertion:
>> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >> sebb-2-2 wrote:
>> >> >> >> >
>> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >>
>> >> >> >> >> Yes, but please can you give me an example?
>> >> >> >> >>
>> >> >> >> >> I have spent half a day of Friday trying to do something
>> >> with
>> >> >> >> variables
>> >> >> >> >> in
>> >> >> >> >> BSF and BSH assertions and listeners and no luck!
>> >> >> >> >>
>> >> >> >> >> All I need to do is to be able to evaluate variable and
>> send
>> >> >> some
>> >> >> >> >> message to
>> >> >> >> >> some listener :)
>> >> >> >> >>
>> >> >> >> >> An example will be greatly appreciated.
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> > Read the following:
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >>
>> >>
>> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
>> >> >> >> >
>> >> >> >> > It includes sample code.
>> >> >> >> >
>> >> >> >> >>
>> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >
>> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >> >>
>> >> >> >> >> >> That's not what I meant. I meant is there an
>> assertion
>> >> that
>> >> >> can
>> >> >> >> >> >> conveniently
>> >> >> >> >> >> parse SQL results?
>> >> >> >> >> >>
>> >> >> >> >> >> E.g. my results are: table headers and 4 values. How
>> do
>> >> I
>> >> >> check
>> >> >> >> that
>> >> >> >> >> >> e.g.
>> >> >> >> >> >> "Average" is < 30?
>> >> >> >> >> >
>> >> >> >> >> > JDBC can save results as variables.
>> >> >> >> >> >
>> >> >> >> >> > The Size Assertion is similar to what you want,
>> >> unfortunately
>> >> >> it
>> >> >> >> only
>> >> >> >> >> > checks size... perhaps that should be extended to
>> check a
>> >> >> >> variable.
>> >> >> >> >> >
>> >> >> >> >> > Meanwhile, use a BSF or BSH Assertion to check the
>> >> variable.
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >> >
>> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Hi!
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Is there any sort of response assertion for JDBC
>> >> >> requests?
>> >> >> >> >> >> >
>> >> >> >> >> >> > All the Assertions can be used with JDBC.
>> >> >> >> >> >> >
>> >> >> >> >> >> >> Or it's RegExp Extractor only?
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> If there is a way (maybe via BSF request),
>> please
>> >> >> provide an
>> >> >> >> >> example
>> >> >> >> >> >> :)
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> --
>> >> >> >> >> >> >> View this message in context:
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive
>> at
>> >> >> >> Nabble.com.
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> --
>> >> >> >> >> >> View this message in context:
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>> >> >> >> >> >>
>> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> >> Nabble.com.
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >>
>> >> >> >> >> View this message in context:
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>> >> >> >> >>
>> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> Nabble.com.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> > To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> > For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >> --
>> >> >> >>
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
>> >> >> >>
>> >> >> >> Sent from the JMeter - User mailing list archive at
>> Nabble.com.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> > For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >>
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
>> >> >>
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >>
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>> --
>>
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006598.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007044.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
Solution found:
if (Integer.parseInt(vars.get("AA_1")) < 30) {
Failure=true;
}
- vars.get
- if condition in brackets
- actions in brackets
- if starts with lowercase letters
- ";" after condition
- Integer.parseInt
- parseInt with lowercase at start
Why weren't you able to tell me this 3 hours ago??..
I'm happy it works, but it's so simple and I'm not a JMeter specialist, so I
regret a DAY wasted on this simple thing - just to evaluate a variable from
SQL response.
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> We have already found this.
>>
>> If (vars.get("AA_1") < 30) {Failure=true }
>>
>
> OK, so you have made some progress.
>
>> Assertion failure message: org.apache.jorphan.util.JMeterException:
>> Error
>>
>> invoking bsh method: eval Sourced file: inline evaluation of: ``If
>> (vars.get("AA_1") < "30") {Failure=true };'' : Operator: '"<"'
>> inappropriate
>> for objects.
>>
>> However vars.get is supposed to return not objects, but variable values.
>> You
>> can find it in help.
>
> Yes, it does return the variable value; however that is a String.
>
> So the condition is effectively something like:
>
> ("7" < "30")
>
> which - as the error message says - is not valid in BeanShell
>
>> I think you really have never done assertion like this :)
>>
>> You are wasting your time and mine, too.
>>
>> sebb, please, either stop answering or give me a working example.
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>> >>
>> >>
>> >> sebb, you are very stubborn and you don't want to understand what I
>> am
>> >> asking.
>> >
>> > I am trying to answer your questions.
>> >
>> >> You have sent me links to help 3 times (!), but unfortunately you
>> are
>> >> the
>> >> only one who is answering me.
>> >>
>> >> I'll try to be maximum specific, so that you will be not able to
>> send me
>> >> the
>> >> link to help for the 4th time.
>> >>
>> >> I make a JDBC request, which results in a following output:
>> >> Count(*)
>> >> 28
>> >>
>> >> The output is assigned to a variable: AA.
>> >>
>> >> Then as a child to this request, I create a BeanShell Assertion,
>> which
>> >> reads:
>> >>
>> >> If vars.get("AA_1") < 30 Then {
>> >> Failure=true }
>> >>
>> >> I get the following error:
>> >>
>> >> Assertion failure message: org.apache.jorphan.util.JMeterException:
>> >> Error
>> >> invoking bsh method: eval Parse error at line 1, column 8.
>> >> Encountered: .
>> >>
>> >> Why?
>> >>
>> >
>> > The phrase "Parse error" means that the code is not valid Java syntax.
>> >
>> > Compare your code with the following example from the link I provided:
>> >
>> > if (arr != null && arr.length != 25218)
>> > {
>> > Failure= true ;
>> > FailureMessage = "The response data size was not as
>> expected"
>> > ;
>> > }
>> >
>> > If you look carefully you will see that the general form of an "if"
>> > statement is:
>> >
>> > if (condition) {
>> > }
>> >
>> > Try fixing your code accordingly.
>> >
>> >>
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >>
>> >> >> > I already explained how to generate a sample and how to use
>> BSH to
>> >> >> > generate an Assertion:
>> >> >>
>> >> >>
>> >> >> No, you didn't. The reference to generic help you gave me does
>> not
>> >> >> contain
>> >> >> this.
>> >> >>
>> >> >> I need a sample BSF/BSH Assetion script that evaluates a
>> variable,
>> >> >> please.
>> >> >
>> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>> >> >
>> >> >> Say, "If variable > 5 Then Failed, Else Passed"
>> >> >>
>> >> >>
>> >> >>
>> >> >> sebb-2-2 wrote:
>> >> >> >
>> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >>
>> >> >> >> sebb
>> >> >> >>
>> >> >> >> You are not answering my question. You are confusing me with
>> >> people
>> >> >> who
>> >> >> >> do
>> >> >> >> not read manuals before asking questions.
>> >> >> >>
>> >> >> >> I have read all the help files and I did not find an answer
>> to
>> >> my
>> >> >> >> question!
>> >> >> >>
>> >> >> >> Could you please be more specific in your answers, in case
>> you
>> >> >> really
>> >> >> >> know
>> >> >> >> how this assertion works, of course.
>> >> >> >>
>> >> >> >> I need a sample BSF/BSH script that evaluates a variable and
>> >> send a
>> >> >> >> message
>> >> >> >> to some listener.
>> >> >> >
>> >> >> > As I wrote before, Listeners only process samples and
>> Assertions;
>> >> I
>> >> >> > already explained how to generate a sample and how to use BSH
>> to
>> >> >> > generate an Assertion:
>> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >> sebb-2-2 wrote:
>> >> >> >> >
>> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >>
>> >> >> >> >> Yes, but please can you give me an example?
>> >> >> >> >>
>> >> >> >> >> I have spent half a day of Friday trying to do something
>> >> with
>> >> >> >> variables
>> >> >> >> >> in
>> >> >> >> >> BSF and BSH assertions and listeners and no luck!
>> >> >> >> >>
>> >> >> >> >> All I need to do is to be able to evaluate variable and
>> send
>> >> >> some
>> >> >> >> >> message to
>> >> >> >> >> some listener :)
>> >> >> >> >>
>> >> >> >> >> An example will be greatly appreciated.
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> > Read the following:
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >>
>> >>
>> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
>> >> >> >> >
>> >> >> >> > It includes sample code.
>> >> >> >> >
>> >> >> >> >>
>> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >
>> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >> >>
>> >> >> >> >> >> That's not what I meant. I meant is there an
>> assertion
>> >> that
>> >> >> can
>> >> >> >> >> >> conveniently
>> >> >> >> >> >> parse SQL results?
>> >> >> >> >> >>
>> >> >> >> >> >> E.g. my results are: table headers and 4 values. How
>> do
>> >> I
>> >> >> check
>> >> >> >> that
>> >> >> >> >> >> e.g.
>> >> >> >> >> >> "Average" is < 30?
>> >> >> >> >> >
>> >> >> >> >> > JDBC can save results as variables.
>> >> >> >> >> >
>> >> >> >> >> > The Size Assertion is similar to what you want,
>> >> unfortunately
>> >> >> it
>> >> >> >> only
>> >> >> >> >> > checks size... perhaps that should be extended to
>> check a
>> >> >> >> variable.
>> >> >> >> >> >
>> >> >> >> >> > Meanwhile, use a BSF or BSH Assertion to check the
>> >> variable.
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >> >
>> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Hi!
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Is there any sort of response assertion for JDBC
>> >> >> requests?
>> >> >> >> >> >> >
>> >> >> >> >> >> > All the Assertions can be used with JDBC.
>> >> >> >> >> >> >
>> >> >> >> >> >> >> Or it's RegExp Extractor only?
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> If there is a way (maybe via BSF request),
>> please
>> >> >> provide an
>> >> >> >> >> example
>> >> >> >> >> >> :)
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> --
>> >> >> >> >> >> >> View this message in context:
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive
>> at
>> >> >> >> Nabble.com.
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> --
>> >> >> >> >> >> View this message in context:
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>> >> >> >> >> >>
>> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> >> Nabble.com.
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >>
>> >> >> >> >> View this message in context:
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>> >> >> >> >>
>> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> Nabble.com.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> > To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> > For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >> --
>> >> >> >>
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
>> >> >> >>
>> >> >> >> Sent from the JMeter - User mailing list archive at
>> Nabble.com.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> > For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >>
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
>> >> >>
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >>
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>> --
>>
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006598.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25007430.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by sebb <se...@gmail.com>.
On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>
> We have already found this.
>
> If (vars.get("AA_1") < 30) {Failure=true }
>
OK, so you have made some progress.
> Assertion failure message: org.apache.jorphan.util.JMeterException: Error
>
> invoking bsh method: eval Sourced file: inline evaluation of: ``If
> (vars.get("AA_1") < "30") {Failure=true };'' : Operator: '"<"' inappropriate
> for objects.
>
> However vars.get is supposed to return not objects, but variable values. You
> can find it in help.
Yes, it does return the variable value; however that is a String.
So the condition is effectively something like:
("7" < "30")
which - as the error message says - is not valid in BeanShell
> I think you really have never done assertion like this :)
>
> You are wasting your time and mine, too.
>
> sebb, please, either stop answering or give me a working example.
>
> sebb-2-2 wrote:
> >
> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >>
> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
> >>
> >>
> >> sebb, you are very stubborn and you don't want to understand what I am
> >> asking.
> >
> > I am trying to answer your questions.
> >
> >> You have sent me links to help 3 times (!), but unfortunately you are
> >> the
> >> only one who is answering me.
> >>
> >> I'll try to be maximum specific, so that you will be not able to send me
> >> the
> >> link to help for the 4th time.
> >>
> >> I make a JDBC request, which results in a following output:
> >> Count(*)
> >> 28
> >>
> >> The output is assigned to a variable: AA.
> >>
> >> Then as a child to this request, I create a BeanShell Assertion, which
> >> reads:
> >>
> >> If vars.get("AA_1") < 30 Then {
> >> Failure=true }
> >>
> >> I get the following error:
> >>
> >> Assertion failure message: org.apache.jorphan.util.JMeterException:
> >> Error
> >> invoking bsh method: eval Parse error at line 1, column 8.
> >> Encountered: .
> >>
> >> Why?
> >>
> >
> > The phrase "Parse error" means that the code is not valid Java syntax.
> >
> > Compare your code with the following example from the link I provided:
> >
> > if (arr != null && arr.length != 25218)
> > {
> > Failure= true ;
> > FailureMessage = "The response data size was not as expected"
> > ;
> > }
> >
> > If you look carefully you will see that the general form of an "if"
> > statement is:
> >
> > if (condition) {
> > }
> >
> > Try fixing your code accordingly.
> >
> >>
> >>
> >> sebb-2-2 wrote:
> >> >
> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >>
> >> >> > I already explained how to generate a sample and how to use BSH to
> >> >> > generate an Assertion:
> >> >>
> >> >>
> >> >> No, you didn't. The reference to generic help you gave me does not
> >> >> contain
> >> >> this.
> >> >>
> >> >> I need a sample BSF/BSH Assetion script that evaluates a variable,
> >> >> please.
> >> >
> >> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
> >> >
> >> >> Say, "If variable > 5 Then Failed, Else Passed"
> >> >>
> >> >>
> >> >>
> >> >> sebb-2-2 wrote:
> >> >> >
> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >>
> >> >> >> sebb
> >> >> >>
> >> >> >> You are not answering my question. You are confusing me with
> >> people
> >> >> who
> >> >> >> do
> >> >> >> not read manuals before asking questions.
> >> >> >>
> >> >> >> I have read all the help files and I did not find an answer to
> >> my
> >> >> >> question!
> >> >> >>
> >> >> >> Could you please be more specific in your answers, in case you
> >> >> really
> >> >> >> know
> >> >> >> how this assertion works, of course.
> >> >> >>
> >> >> >> I need a sample BSF/BSH script that evaluates a variable and
> >> send a
> >> >> >> message
> >> >> >> to some listener.
> >> >> >
> >> >> > As I wrote before, Listeners only process samples and Assertions;
> >> I
> >> >> > already explained how to generate a sample and how to use BSH to
> >> >> > generate an Assertion:
> >> >> >
> >> >> >>
> >> >> >>
> >> >> >> sebb-2-2 wrote:
> >> >> >> >
> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >>
> >> >> >> >> Yes, but please can you give me an example?
> >> >> >> >>
> >> >> >> >> I have spent half a day of Friday trying to do something
> >> with
> >> >> >> variables
> >> >> >> >> in
> >> >> >> >> BSF and BSH assertions and listeners and no luck!
> >> >> >> >>
> >> >> >> >> All I need to do is to be able to evaluate variable and send
> >> >> some
> >> >> >> >> message to
> >> >> >> >> some listener :)
> >> >> >> >>
> >> >> >> >> An example will be greatly appreciated.
> >> >> >> >>
> >> >> >> >
> >> >> >> > Read the following:
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >>
> >> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
> >> >> >> >
> >> >> >> > It includes sample code.
> >> >> >> >
> >> >> >> >>
> >> >> >> >> sebb-2-2 wrote:
> >> >> >> >> >
> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >> >>
> >> >> >> >> >> That's not what I meant. I meant is there an assertion
> >> that
> >> >> can
> >> >> >> >> >> conveniently
> >> >> >> >> >> parse SQL results?
> >> >> >> >> >>
> >> >> >> >> >> E.g. my results are: table headers and 4 values. How do
> >> I
> >> >> check
> >> >> >> that
> >> >> >> >> >> e.g.
> >> >> >> >> >> "Average" is < 30?
> >> >> >> >> >
> >> >> >> >> > JDBC can save results as variables.
> >> >> >> >> >
> >> >> >> >> > The Size Assertion is similar to what you want,
> >> unfortunately
> >> >> it
> >> >> >> only
> >> >> >> >> > checks size... perhaps that should be extended to check a
> >> >> >> variable.
> >> >> >> >> >
> >> >> >> >> > Meanwhile, use a BSF or BSH Assertion to check the
> >> variable.
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >> sebb-2-2 wrote:
> >> >> >> >> >> >
> >> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >> >> >>
> >> >> >> >> >> >> Hi!
> >> >> >> >> >> >>
> >> >> >> >> >> >> Is there any sort of response assertion for JDBC
> >> >> requests?
> >> >> >> >> >> >
> >> >> >> >> >> > All the Assertions can be used with JDBC.
> >> >> >> >> >> >
> >> >> >> >> >> >> Or it's RegExp Extractor only?
> >> >> >> >> >> >>
> >> >> >> >> >> >> If there is a way (maybe via BSF request), please
> >> >> provide an
> >> >> >> >> example
> >> >> >> >> >> :)
> >> >> >> >> >> >>
> >> >> >> >> >> >> --
> >> >> >> >> >> >> View this message in context:
> >> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
> >> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> >> >> Nabble.com.
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> >> >> To unsubscribe, e-mail:
> >> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> >> For additional commands, e-mail:
> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> >> >> > To unsubscribe, e-mail:
> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> > For additional commands, e-mail:
> >> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >> View this message in context:
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
> >> >> >> >> >>
> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> >> Nabble.com.
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> >> >> To unsubscribe, e-mail:
> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> For additional commands, e-mail:
> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >
> >> >> >> >> >
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> > To unsubscribe, e-mail:
> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> > For additional commands, e-mail:
> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >>
> >> >> >> >> View this message in context:
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
> >> >> >> >>
> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> Nabble.com.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> To unsubscribe, e-mail:
> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> For additional commands, e-mail:
> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >>
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> ---------------------------------------------------------------------
> >> >> >> > To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> > For additional commands, e-mail:
> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >> --
> >> >> >>
> >> >> >> View this message in context:
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
> >> >> >>
> >> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> ---------------------------------------------------------------------
> >> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> > For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >> --
> >> >>
> >> >> View this message in context:
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
> >> >>
> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >>
> >> >>
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> >>
> >> --
> >>
> >> View this message in context:
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
> >>
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> --
>
> View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006598.html
>
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
We have already found this.
If (vars.get("AA_1") < 30) {Failure=true }
Assertion failure message: org.apache.jorphan.util.JMeterException: Error
invoking bsh method: eval Sourced file: inline evaluation of: ``If
(vars.get("AA_1") < "30") {Failure=true };'' : Operator: '"<"' inappropriate
for objects.
However vars.get is supposed to return not objects, but variable values. You
can find it in help.
I think you really have never done assertion like this :)
You are wasting your time and mine, too.
sebb, please, either stop answering or give me a working example.
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>>
>>
>> sebb, you are very stubborn and you don't want to understand what I am
>> asking.
>
> I am trying to answer your questions.
>
>> You have sent me links to help 3 times (!), but unfortunately you are
>> the
>> only one who is answering me.
>>
>> I'll try to be maximum specific, so that you will be not able to send me
>> the
>> link to help for the 4th time.
>>
>> I make a JDBC request, which results in a following output:
>> Count(*)
>> 28
>>
>> The output is assigned to a variable: AA.
>>
>> Then as a child to this request, I create a BeanShell Assertion, which
>> reads:
>>
>> If vars.get("AA_1") < 30 Then {
>> Failure=true }
>>
>> I get the following error:
>>
>> Assertion failure message: org.apache.jorphan.util.JMeterException:
>> Error
>> invoking bsh method: eval Parse error at line 1, column 8.
>> Encountered: .
>>
>> Why?
>>
>
> The phrase "Parse error" means that the code is not valid Java syntax.
>
> Compare your code with the following example from the link I provided:
>
> if (arr != null && arr.length != 25218)
> {
> Failure= true ;
> FailureMessage = "The response data size was not as expected"
> ;
> }
>
> If you look carefully you will see that the general form of an "if"
> statement is:
>
> if (condition) {
> }
>
> Try fixing your code accordingly.
>
>>
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> > I already explained how to generate a sample and how to use BSH to
>> >> > generate an Assertion:
>> >>
>> >>
>> >> No, you didn't. The reference to generic help you gave me does not
>> >> contain
>> >> this.
>> >>
>> >> I need a sample BSF/BSH Assetion script that evaluates a variable,
>> >> please.
>> >
>> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>> >
>> >> Say, "If variable > 5 Then Failed, Else Passed"
>> >>
>> >>
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >>
>> >> >> sebb
>> >> >>
>> >> >> You are not answering my question. You are confusing me with
>> people
>> >> who
>> >> >> do
>> >> >> not read manuals before asking questions.
>> >> >>
>> >> >> I have read all the help files and I did not find an answer to
>> my
>> >> >> question!
>> >> >>
>> >> >> Could you please be more specific in your answers, in case you
>> >> really
>> >> >> know
>> >> >> how this assertion works, of course.
>> >> >>
>> >> >> I need a sample BSF/BSH script that evaluates a variable and
>> send a
>> >> >> message
>> >> >> to some listener.
>> >> >
>> >> > As I wrote before, Listeners only process samples and Assertions;
>> I
>> >> > already explained how to generate a sample and how to use BSH to
>> >> > generate an Assertion:
>> >> >
>> >> >>
>> >> >>
>> >> >> sebb-2-2 wrote:
>> >> >> >
>> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >>
>> >> >> >> Yes, but please can you give me an example?
>> >> >> >>
>> >> >> >> I have spent half a day of Friday trying to do something
>> with
>> >> >> variables
>> >> >> >> in
>> >> >> >> BSF and BSH assertions and listeners and no luck!
>> >> >> >>
>> >> >> >> All I need to do is to be able to evaluate variable and send
>> >> some
>> >> >> >> message to
>> >> >> >> some listener :)
>> >> >> >>
>> >> >> >> An example will be greatly appreciated.
>> >> >> >>
>> >> >> >
>> >> >> > Read the following:
>> >> >> >
>> >> >> >
>> >> >>
>> >>
>> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
>> >> >> >
>> >> >> > It includes sample code.
>> >> >> >
>> >> >> >>
>> >> >> >> sebb-2-2 wrote:
>> >> >> >> >
>> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >>
>> >> >> >> >> That's not what I meant. I meant is there an assertion
>> that
>> >> can
>> >> >> >> >> conveniently
>> >> >> >> >> parse SQL results?
>> >> >> >> >>
>> >> >> >> >> E.g. my results are: table headers and 4 values. How do
>> I
>> >> check
>> >> >> that
>> >> >> >> >> e.g.
>> >> >> >> >> "Average" is < 30?
>> >> >> >> >
>> >> >> >> > JDBC can save results as variables.
>> >> >> >> >
>> >> >> >> > The Size Assertion is similar to what you want,
>> unfortunately
>> >> it
>> >> >> only
>> >> >> >> > checks size... perhaps that should be extended to check a
>> >> >> variable.
>> >> >> >> >
>> >> >> >> > Meanwhile, use a BSF or BSH Assertion to check the
>> variable.
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >>
>> >> >> >> >> sebb-2-2 wrote:
>> >> >> >> >> >
>> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >> >>
>> >> >> >> >> >> Hi!
>> >> >> >> >> >>
>> >> >> >> >> >> Is there any sort of response assertion for JDBC
>> >> requests?
>> >> >> >> >> >
>> >> >> >> >> > All the Assertions can be used with JDBC.
>> >> >> >> >> >
>> >> >> >> >> >> Or it's RegExp Extractor only?
>> >> >> >> >> >>
>> >> >> >> >> >> If there is a way (maybe via BSF request), please
>> >> provide an
>> >> >> >> example
>> >> >> >> >> :)
>> >> >> >> >> >>
>> >> >> >> >> >> --
>> >> >> >> >> >> View this message in context:
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> >> Nabble.com.
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> >> >> To unsubscribe, e-mail:
>> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> >> For additional commands, e-mail:
>> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> > To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> > For additional commands, e-mail:
>> >> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >> View this message in context:
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>> >> >> >> >>
>> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> Nabble.com.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> > To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> > For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >> --
>> >> >> >>
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>> >> >> >>
>> >> >> >> Sent from the JMeter - User mailing list archive at
>> Nabble.com.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> > For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >>
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
>> >> >>
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >>
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>> --
>>
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006598.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by sebb <se...@gmail.com>.
On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>
> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>
>
> sebb, you are very stubborn and you don't want to understand what I am
> asking.
I am trying to answer your questions.
> You have sent me links to help 3 times (!), but unfortunately you are the
> only one who is answering me.
>
> I'll try to be maximum specific, so that you will be not able to send me the
> link to help for the 4th time.
>
> I make a JDBC request, which results in a following output:
> Count(*)
> 28
>
> The output is assigned to a variable: AA.
>
> Then as a child to this request, I create a BeanShell Assertion, which
> reads:
>
> If vars.get("AA_1") < 30 Then {
> Failure=true }
>
> I get the following error:
>
> Assertion failure message: org.apache.jorphan.util.JMeterException: Error
> invoking bsh method: eval Parse error at line 1, column 8. Encountered: .
>
> Why?
>
The phrase "Parse error" means that the code is not valid Java syntax.
Compare your code with the following example from the link I provided:
if (arr != null && arr.length != 25218)
{
Failure= true ;
FailureMessage = "The response data size was not as expected" ;
}
If you look carefully you will see that the general form of an "if"
statement is:
if (condition) {
}
Try fixing your code accordingly.
>
>
> sebb-2-2 wrote:
> >
> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >>
> >> > I already explained how to generate a sample and how to use BSH to
> >> > generate an Assertion:
> >>
> >>
> >> No, you didn't. The reference to generic help you gave me does not
> >> contain
> >> this.
> >>
> >> I need a sample BSF/BSH Assetion script that evaluates a variable,
> >> please.
> >
> > http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
> >
> >> Say, "If variable > 5 Then Failed, Else Passed"
> >>
> >>
> >>
> >> sebb-2-2 wrote:
> >> >
> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >>
> >> >> sebb
> >> >>
> >> >> You are not answering my question. You are confusing me with people
> >> who
> >> >> do
> >> >> not read manuals before asking questions.
> >> >>
> >> >> I have read all the help files and I did not find an answer to my
> >> >> question!
> >> >>
> >> >> Could you please be more specific in your answers, in case you
> >> really
> >> >> know
> >> >> how this assertion works, of course.
> >> >>
> >> >> I need a sample BSF/BSH script that evaluates a variable and send a
> >> >> message
> >> >> to some listener.
> >> >
> >> > As I wrote before, Listeners only process samples and Assertions; I
> >> > already explained how to generate a sample and how to use BSH to
> >> > generate an Assertion:
> >> >
> >> >>
> >> >>
> >> >> sebb-2-2 wrote:
> >> >> >
> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >>
> >> >> >> Yes, but please can you give me an example?
> >> >> >>
> >> >> >> I have spent half a day of Friday trying to do something with
> >> >> variables
> >> >> >> in
> >> >> >> BSF and BSH assertions and listeners and no luck!
> >> >> >>
> >> >> >> All I need to do is to be able to evaluate variable and send
> >> some
> >> >> >> message to
> >> >> >> some listener :)
> >> >> >>
> >> >> >> An example will be greatly appreciated.
> >> >> >>
> >> >> >
> >> >> > Read the following:
> >> >> >
> >> >> >
> >> >>
> >> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
> >> >> >
> >> >> > It includes sample code.
> >> >> >
> >> >> >>
> >> >> >> sebb-2-2 wrote:
> >> >> >> >
> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >>
> >> >> >> >> That's not what I meant. I meant is there an assertion that
> >> can
> >> >> >> >> conveniently
> >> >> >> >> parse SQL results?
> >> >> >> >>
> >> >> >> >> E.g. my results are: table headers and 4 values. How do I
> >> check
> >> >> that
> >> >> >> >> e.g.
> >> >> >> >> "Average" is < 30?
> >> >> >> >
> >> >> >> > JDBC can save results as variables.
> >> >> >> >
> >> >> >> > The Size Assertion is similar to what you want, unfortunately
> >> it
> >> >> only
> >> >> >> > checks size... perhaps that should be extended to check a
> >> >> variable.
> >> >> >> >
> >> >> >> > Meanwhile, use a BSF or BSH Assertion to check the variable.
> >> >> >> >
> >> >> >> >
> >> >> >> >>
> >> >> >> >> sebb-2-2 wrote:
> >> >> >> >> >
> >> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >> >>
> >> >> >> >> >> Hi!
> >> >> >> >> >>
> >> >> >> >> >> Is there any sort of response assertion for JDBC
> >> requests?
> >> >> >> >> >
> >> >> >> >> > All the Assertions can be used with JDBC.
> >> >> >> >> >
> >> >> >> >> >> Or it's RegExp Extractor only?
> >> >> >> >> >>
> >> >> >> >> >> If there is a way (maybe via BSF request), please
> >> provide an
> >> >> >> example
> >> >> >> >> :)
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >> View this message in context:
> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
> >> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> >> Nabble.com.
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> >> >> To unsubscribe, e-mail:
> >> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> >> For additional commands, e-mail:
> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >
> >> >> >> >> >
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> > To unsubscribe, e-mail:
> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> > For additional commands, e-mail:
> >> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> View this message in context:
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
> >> >> >> >>
> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> Nabble.com.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> To unsubscribe, e-mail:
> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> For additional commands, e-mail:
> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >>
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> ---------------------------------------------------------------------
> >> >> >> > To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> > For additional commands, e-mail:
> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >> --
> >> >> >>
> >> >> >> View this message in context:
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
> >> >> >>
> >> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> ---------------------------------------------------------------------
> >> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> > For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >> --
> >> >>
> >> >> View this message in context:
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
> >> >>
> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >>
> >> >>
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> >>
> >> --
> >>
> >> View this message in context:
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
> >>
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> --
>
> View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
>
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
> http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
sebb, you are very stubborn and you don't want to understand what I am
asking.
You have sent me links to help 3 times (!), but unfortunately you are the
only one who is answering me.
I'll try to be maximum specific, so that you will be not able to send me the
link to help for the 4th time.
I make a JDBC request, which results in a following output:
Count(*)
28
The output is assigned to a variable: AA.
Then as a child to this request, I create a BeanShell Assertion, which
reads:
If vars.get("AA_1") < 30 Then {
Failure=true }
I get the following error:
Assertion failure message: org.apache.jorphan.util.JMeterException: Error
invoking bsh method: eval Parse error at line 1, column 8. Encountered: .
Why?
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> > I already explained how to generate a sample and how to use BSH to
>> > generate an Assertion:
>>
>>
>> No, you didn't. The reference to generic help you gave me does not
>> contain
>> this.
>>
>> I need a sample BSF/BSH Assetion script that evaluates a variable,
>> please.
>
> http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
>
>> Say, "If variable > 5 Then Failed, Else Passed"
>>
>>
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> sebb
>> >>
>> >> You are not answering my question. You are confusing me with people
>> who
>> >> do
>> >> not read manuals before asking questions.
>> >>
>> >> I have read all the help files and I did not find an answer to my
>> >> question!
>> >>
>> >> Could you please be more specific in your answers, in case you
>> really
>> >> know
>> >> how this assertion works, of course.
>> >>
>> >> I need a sample BSF/BSH script that evaluates a variable and send a
>> >> message
>> >> to some listener.
>> >
>> > As I wrote before, Listeners only process samples and Assertions; I
>> > already explained how to generate a sample and how to use BSH to
>> > generate an Assertion:
>> >
>> >>
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >>
>> >> >> Yes, but please can you give me an example?
>> >> >>
>> >> >> I have spent half a day of Friday trying to do something with
>> >> variables
>> >> >> in
>> >> >> BSF and BSH assertions and listeners and no luck!
>> >> >>
>> >> >> All I need to do is to be able to evaluate variable and send
>> some
>> >> >> message to
>> >> >> some listener :)
>> >> >>
>> >> >> An example will be greatly appreciated.
>> >> >>
>> >> >
>> >> > Read the following:
>> >> >
>> >> >
>> >>
>> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
>> >> >
>> >> > It includes sample code.
>> >> >
>> >> >>
>> >> >> sebb-2-2 wrote:
>> >> >> >
>> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >>
>> >> >> >> That's not what I meant. I meant is there an assertion that
>> can
>> >> >> >> conveniently
>> >> >> >> parse SQL results?
>> >> >> >>
>> >> >> >> E.g. my results are: table headers and 4 values. How do I
>> check
>> >> that
>> >> >> >> e.g.
>> >> >> >> "Average" is < 30?
>> >> >> >
>> >> >> > JDBC can save results as variables.
>> >> >> >
>> >> >> > The Size Assertion is similar to what you want, unfortunately
>> it
>> >> only
>> >> >> > checks size... perhaps that should be extended to check a
>> >> variable.
>> >> >> >
>> >> >> > Meanwhile, use a BSF or BSH Assertion to check the variable.
>> >> >> >
>> >> >> >
>> >> >> >>
>> >> >> >> sebb-2-2 wrote:
>> >> >> >> >
>> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >> >>
>> >> >> >> >> Hi!
>> >> >> >> >>
>> >> >> >> >> Is there any sort of response assertion for JDBC
>> requests?
>> >> >> >> >
>> >> >> >> > All the Assertions can be used with JDBC.
>> >> >> >> >
>> >> >> >> >> Or it's RegExp Extractor only?
>> >> >> >> >>
>> >> >> >> >> If there is a way (maybe via BSF request), please
>> provide an
>> >> >> example
>> >> >> >> :)
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >> View this message in context:
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> >> >> >> Sent from the JMeter - User mailing list archive at
>> >> Nabble.com.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> >> To unsubscribe, e-mail:
>> >> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> >> For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> > To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> > For additional commands, e-mail:
>> >> >> jmeter-user-help@jakarta.apache.org
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>> >> >> >>
>> >> >> >> Sent from the JMeter - User mailing list archive at
>> Nabble.com.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> > For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >>
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>> >> >>
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >>
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>> --
>>
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25006196.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by sebb <se...@gmail.com>.
On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>
> > I already explained how to generate a sample and how to use BSH to
> > generate an Assertion:
>
>
> No, you didn't. The reference to generic help you gave me does not contain
> this.
>
> I need a sample BSF/BSH Assetion script that evaluates a variable, please.
http://jakarta.apache.org/jmeter/demos/BeanShellAssertion.bsh
> Say, "If variable > 5 Then Failed, Else Passed"
>
>
>
> sebb-2-2 wrote:
> >
> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >>
> >> sebb
> >>
> >> You are not answering my question. You are confusing me with people who
> >> do
> >> not read manuals before asking questions.
> >>
> >> I have read all the help files and I did not find an answer to my
> >> question!
> >>
> >> Could you please be more specific in your answers, in case you really
> >> know
> >> how this assertion works, of course.
> >>
> >> I need a sample BSF/BSH script that evaluates a variable and send a
> >> message
> >> to some listener.
> >
> > As I wrote before, Listeners only process samples and Assertions; I
> > already explained how to generate a sample and how to use BSH to
> > generate an Assertion:
> >
> >>
> >>
> >> sebb-2-2 wrote:
> >> >
> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >>
> >> >> Yes, but please can you give me an example?
> >> >>
> >> >> I have spent half a day of Friday trying to do something with
> >> variables
> >> >> in
> >> >> BSF and BSH assertions and listeners and no luck!
> >> >>
> >> >> All I need to do is to be able to evaluate variable and send some
> >> >> message to
> >> >> some listener :)
> >> >>
> >> >> An example will be greatly appreciated.
> >> >>
> >> >
> >> > Read the following:
> >> >
> >> >
> >> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
> >> >
> >> > It includes sample code.
> >> >
> >> >>
> >> >> sebb-2-2 wrote:
> >> >> >
> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >>
> >> >> >> That's not what I meant. I meant is there an assertion that can
> >> >> >> conveniently
> >> >> >> parse SQL results?
> >> >> >>
> >> >> >> E.g. my results are: table headers and 4 values. How do I check
> >> that
> >> >> >> e.g.
> >> >> >> "Average" is < 30?
> >> >> >
> >> >> > JDBC can save results as variables.
> >> >> >
> >> >> > The Size Assertion is similar to what you want, unfortunately it
> >> only
> >> >> > checks size... perhaps that should be extended to check a
> >> variable.
> >> >> >
> >> >> > Meanwhile, use a BSF or BSH Assertion to check the variable.
> >> >> >
> >> >> >
> >> >> >>
> >> >> >> sebb-2-2 wrote:
> >> >> >> >
> >> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >> >>
> >> >> >> >> Hi!
> >> >> >> >>
> >> >> >> >> Is there any sort of response assertion for JDBC requests?
> >> >> >> >
> >> >> >> > All the Assertions can be used with JDBC.
> >> >> >> >
> >> >> >> >> Or it's RegExp Extractor only?
> >> >> >> >>
> >> >> >> >> If there is a way (maybe via BSF request), please provide an
> >> >> example
> >> >> >> :)
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> View this message in context:
> >> >> >> >>
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
> >> >> >> >> Sent from the JMeter - User mailing list archive at
> >> Nabble.com.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> >> To unsubscribe, e-mail:
> >> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> >> For additional commands, e-mail:
> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >>
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> ---------------------------------------------------------------------
> >> >> >> > To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> > For additional commands, e-mail:
> >> >> jmeter-user-help@jakarta.apache.org
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> View this message in context:
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
> >> >> >>
> >> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> ---------------------------------------------------------------------
> >> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> > For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >> --
> >> >>
> >> >> View this message in context:
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
> >> >>
> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >>
> >> >>
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> >>
> >> --
> >>
> >> View this message in context:
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
> >>
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> --
>
> View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
>
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
> I already explained how to generate a sample and how to use BSH to
> generate an Assertion:
No, you didn't. The reference to generic help you gave me does not contain
this.
I need a sample BSF/BSH Assetion script that evaluates a variable, please.
Say, "If variable > 5 Then Failed, Else Passed"
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> sebb
>>
>> You are not answering my question. You are confusing me with people who
>> do
>> not read manuals before asking questions.
>>
>> I have read all the help files and I did not find an answer to my
>> question!
>>
>> Could you please be more specific in your answers, in case you really
>> know
>> how this assertion works, of course.
>>
>> I need a sample BSF/BSH script that evaluates a variable and send a
>> message
>> to some listener.
>
> As I wrote before, Listeners only process samples and Assertions; I
> already explained how to generate a sample and how to use BSH to
> generate an Assertion:
>
>>
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> Yes, but please can you give me an example?
>> >>
>> >> I have spent half a day of Friday trying to do something with
>> variables
>> >> in
>> >> BSF and BSH assertions and listeners and no luck!
>> >>
>> >> All I need to do is to be able to evaluate variable and send some
>> >> message to
>> >> some listener :)
>> >>
>> >> An example will be greatly appreciated.
>> >>
>> >
>> > Read the following:
>> >
>> >
>> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
>> >
>> > It includes sample code.
>> >
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >>
>> >> >> That's not what I meant. I meant is there an assertion that can
>> >> >> conveniently
>> >> >> parse SQL results?
>> >> >>
>> >> >> E.g. my results are: table headers and 4 values. How do I check
>> that
>> >> >> e.g.
>> >> >> "Average" is < 30?
>> >> >
>> >> > JDBC can save results as variables.
>> >> >
>> >> > The Size Assertion is similar to what you want, unfortunately it
>> only
>> >> > checks size... perhaps that should be extended to check a
>> variable.
>> >> >
>> >> > Meanwhile, use a BSF or BSH Assertion to check the variable.
>> >> >
>> >> >
>> >> >>
>> >> >> sebb-2-2 wrote:
>> >> >> >
>> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >> >>
>> >> >> >> Hi!
>> >> >> >>
>> >> >> >> Is there any sort of response assertion for JDBC requests?
>> >> >> >
>> >> >> > All the Assertions can be used with JDBC.
>> >> >> >
>> >> >> >> Or it's RegExp Extractor only?
>> >> >> >>
>> >> >> >> If there is a way (maybe via BSF request), please provide an
>> >> example
>> >> >> :)
>> >> >> >>
>> >> >> >> --
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> >> >> Sent from the JMeter - User mailing list archive at
>> Nabble.com.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> >> To unsubscribe, e-mail:
>> >> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> >> For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> > For additional commands, e-mail:
>> >> jmeter-user-help@jakarta.apache.org
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>> >> >>
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >>
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>> --
>>
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005738.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by sebb <se...@gmail.com>.
On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>
> sebb
>
> You are not answering my question. You are confusing me with people who do
> not read manuals before asking questions.
>
> I have read all the help files and I did not find an answer to my question!
>
> Could you please be more specific in your answers, in case you really know
> how this assertion works, of course.
>
> I need a sample BSF/BSH script that evaluates a variable and send a message
> to some listener.
As I wrote before, Listeners only process samples and Assertions; I
already explained how to generate a sample and how to use BSH to
generate an Assertion:
>
>
> sebb-2-2 wrote:
> >
> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >>
> >> Yes, but please can you give me an example?
> >>
> >> I have spent half a day of Friday trying to do something with variables
> >> in
> >> BSF and BSH assertions and listeners and no luck!
> >>
> >> All I need to do is to be able to evaluate variable and send some
> >> message to
> >> some listener :)
> >>
> >> An example will be greatly appreciated.
> >>
> >
> > Read the following:
> >
> > http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
> >
> > It includes sample code.
> >
> >>
> >> sebb-2-2 wrote:
> >> >
> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >>
> >> >> That's not what I meant. I meant is there an assertion that can
> >> >> conveniently
> >> >> parse SQL results?
> >> >>
> >> >> E.g. my results are: table headers and 4 values. How do I check that
> >> >> e.g.
> >> >> "Average" is < 30?
> >> >
> >> > JDBC can save results as variables.
> >> >
> >> > The Size Assertion is similar to what you want, unfortunately it only
> >> > checks size... perhaps that should be extended to check a variable.
> >> >
> >> > Meanwhile, use a BSF or BSH Assertion to check the variable.
> >> >
> >> >
> >> >>
> >> >> sebb-2-2 wrote:
> >> >> >
> >> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >> >>
> >> >> >> Hi!
> >> >> >>
> >> >> >> Is there any sort of response assertion for JDBC requests?
> >> >> >
> >> >> > All the Assertions can be used with JDBC.
> >> >> >
> >> >> >> Or it's RegExp Extractor only?
> >> >> >>
> >> >> >> If there is a way (maybe via BSF request), please provide an
> >> example
> >> >> :)
> >> >> >>
> >> >> >> --
> >> >> >> View this message in context:
> >> >> >>
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
> >> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> >> To unsubscribe, e-mail:
> >> jmeter-user-unsubscribe@jakarta.apache.org
> >> >> >> For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> ---------------------------------------------------------------------
> >> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> > For additional commands, e-mail:
> >> jmeter-user-help@jakarta.apache.org
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
> >> >>
> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >>
> >> >>
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> >>
> >> --
> >>
> >> View this message in context:
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
> >>
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> --
>
> View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
>
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
sebb
You are not answering my question. You are confusing me with people who do
not read manuals before asking questions.
I have read all the help files and I did not find an answer to my question!
Could you please be more specific in your answers, in case you really know
how this assertion works, of course.
I need a sample BSF/BSH script that evaluates a variable and send a message
to some listener.
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> Yes, but please can you give me an example?
>>
>> I have spent half a day of Friday trying to do something with variables
>> in
>> BSF and BSH assertions and listeners and no luck!
>>
>> All I need to do is to be able to evaluate variable and send some
>> message to
>> some listener :)
>>
>> An example will be greatly appreciated.
>>
>
> Read the following:
>
> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
>
> It includes sample code.
>
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> That's not what I meant. I meant is there an assertion that can
>> >> conveniently
>> >> parse SQL results?
>> >>
>> >> E.g. my results are: table headers and 4 values. How do I check that
>> >> e.g.
>> >> "Average" is < 30?
>> >
>> > JDBC can save results as variables.
>> >
>> > The Size Assertion is similar to what you want, unfortunately it only
>> > checks size... perhaps that should be extended to check a variable.
>> >
>> > Meanwhile, use a BSF or BSH Assertion to check the variable.
>> >
>> >
>> >>
>> >> sebb-2-2 wrote:
>> >> >
>> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >> >>
>> >> >> Hi!
>> >> >>
>> >> >> Is there any sort of response assertion for JDBC requests?
>> >> >
>> >> > All the Assertions can be used with JDBC.
>> >> >
>> >> >> Or it's RegExp Extractor only?
>> >> >>
>> >> >> If there is a way (maybe via BSF request), please provide an
>> example
>> >> :)
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>> >> >> For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> > For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>> >>
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>> --
>>
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005482.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by sebb <se...@gmail.com>.
On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>
> Yes, but please can you give me an example?
>
> I have spent half a day of Friday trying to do something with variables in
> BSF and BSH assertions and listeners and no luck!
>
> All I need to do is to be able to evaluate variable and send some message to
> some listener :)
>
> An example will be greatly appreciated.
>
Read the following:
http://jakarta.apache.org/jmeter/usermanual/component_reference.html#BeanShell_Assertion
It includes sample code.
>
> sebb-2-2 wrote:
> >
> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >>
> >> That's not what I meant. I meant is there an assertion that can
> >> conveniently
> >> parse SQL results?
> >>
> >> E.g. my results are: table headers and 4 values. How do I check that
> >> e.g.
> >> "Average" is < 30?
> >
> > JDBC can save results as variables.
> >
> > The Size Assertion is similar to what you want, unfortunately it only
> > checks size... perhaps that should be extended to check a variable.
> >
> > Meanwhile, use a BSF or BSH Assertion to check the variable.
> >
> >
> >>
> >> sebb-2-2 wrote:
> >> >
> >> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >> >>
> >> >> Hi!
> >> >>
> >> >> Is there any sort of response assertion for JDBC requests?
> >> >
> >> > All the Assertions can be used with JDBC.
> >> >
> >> >> Or it's RegExp Extractor only?
> >> >>
> >> >> If there is a way (maybe via BSF request), please provide an example
> >> :)
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >>
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
> >> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >>
> >> >>
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> >>
> >>
> >> --
> >> View this message in context:
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
> >>
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> --
>
> View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
>
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
Yes, but please can you give me an example?
I have spent half a day of Friday trying to do something with variables in
BSF and BSH assertions and listeners and no luck!
All I need to do is to be able to evaluate variable and send some message to
some listener :)
An example will be greatly appreciated.
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> That's not what I meant. I meant is there an assertion that can
>> conveniently
>> parse SQL results?
>>
>> E.g. my results are: table headers and 4 values. How do I check that
>> e.g.
>> "Average" is < 30?
>
> JDBC can save results as variables.
>
> The Size Assertion is similar to what you want, unfortunately it only
> checks size... perhaps that should be extended to check a variable.
>
> Meanwhile, use a BSF or BSH Assertion to check the variable.
>
>
>>
>> sebb-2-2 wrote:
>> >
>> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>> >>
>> >> Hi!
>> >>
>> >> Is there any sort of response assertion for JDBC requests?
>> >
>> > All the Assertions can be used with JDBC.
>> >
>> >> Or it's RegExp Extractor only?
>> >>
>> >> If there is a way (maybe via BSF request), please provide an example
>> :)
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> >> Sent from the JMeter - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >>
>> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >>
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>>
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005283.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by sebb <se...@gmail.com>.
On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>
> That's not what I meant. I meant is there an assertion that can conveniently
> parse SQL results?
>
> E.g. my results are: table headers and 4 values. How do I check that e.g.
> "Average" is < 30?
JDBC can save results as variables.
The Size Assertion is similar to what you want, unfortunately it only
checks size... perhaps that should be extended to check a variable.
Meanwhile, use a BSF or BSH Assertion to check the variable.
>
> sebb-2-2 wrote:
> >
> > On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
> >>
> >> Hi!
> >>
> >> Is there any sort of response assertion for JDBC requests?
> >
> > All the Assertions can be used with JDBC.
> >
> >> Or it's RegExp Extractor only?
> >>
> >> If there is a way (maybe via BSF request), please provide an example :)
> >>
> >> --
> >> View this message in context:
> >> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
> >> Sent from the JMeter - User mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
>
> --
> View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
>
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by Andrey Simonov <au...@bk.ru>.
That's not what I meant. I meant is there an assertion that can conveniently
parse SQL results?
E.g. my results are: table headers and 4 values. How do I check that e.g.
"Average" is < 30?
sebb-2-2 wrote:
>
> On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>>
>> Hi!
>>
>> Is there any sort of response assertion for JDBC requests?
>
> All the Assertions can be used with JDBC.
>
>> Or it's RegExp Extractor only?
>>
>> If there is a way (maybe via BSF request), please provide an example :)
>>
>> --
>> View this message in context:
>> http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25005147.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Response Assertion
Posted by sebb <se...@gmail.com>.
On 17/08/2009, Andrey Simonov <au...@bk.ru> wrote:
>
> Hi!
>
> Is there any sort of response assertion for JDBC requests?
All the Assertions can be used with JDBC.
> Or it's RegExp Extractor only?
>
> If there is a way (maybe via BSF request), please provide an example :)
>
> --
> View this message in context: http://www.nabble.com/JDBC-Response-Assertion-tp25002488p25002488.html
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org