Return-Path: Delivered-To: apmail-jakarta-jmeter-user-archive@www.apache.org Received: (qmail 63679 invoked from network); 17 Aug 2009 11:41:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 17 Aug 2009 11:41:55 -0000 Received: (qmail 40077 invoked by uid 500); 17 Aug 2009 11:42:00 -0000 Delivered-To: apmail-jakarta-jmeter-user-archive@jakarta.apache.org Received: (qmail 40034 invoked by uid 500); 17 Aug 2009 11:42:00 -0000 Mailing-List: contact jmeter-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "JMeter Users List" Reply-To: "JMeter Users List" Delivered-To: mailing list jmeter-user@jakarta.apache.org Received: (qmail 40024 invoked by uid 99); 17 Aug 2009 11:42:00 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Aug 2009 11:42:00 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Aug 2009 11:41:50 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1Md0af-0002P6-De for jmeter-user@jakarta.apache.org; Mon, 17 Aug 2009 04:41:29 -0700 Message-ID: <25005261.post@talk.nabble.com> Date: Mon, 17 Aug 2009 04:41:29 -0700 (PDT) From: Andrey Simonov To: jmeter-user@jakarta.apache.org Subject: Re: JDBC Response Assertion In-Reply-To: <25aac9fc0908170436g3d03fcf4l6bd6f21af5f2311d@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: aurum@bk.ru References: <25002488.post@talk.nabble.com> <25aac9fc0908170424t3ff751e5qb6fa50632e70e833@mail.gmail.com> <25005147.post@talk.nabble.com> <25aac9fc0908170436g3d03fcf4l6bd6f21af5f2311d@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org 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 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 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