Return-Path: Delivered-To: apmail-jakarta-jmeter-user-archive@www.apache.org Received: (qmail 3004 invoked from network); 31 Dec 2008 22:42:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 31 Dec 2008 22:42:04 -0000 Received: (qmail 57523 invoked by uid 500); 31 Dec 2008 22:41:58 -0000 Delivered-To: apmail-jakarta-jmeter-user-archive@jakarta.apache.org Received: (qmail 57500 invoked by uid 500); 31 Dec 2008 22:41:58 -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 57482 invoked by uid 99); 31 Dec 2008 22:41:58 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 31 Dec 2008 14:41:58 -0800 X-ASF-Spam-Status: No, hits=4.0 required=10.0 tests=DNS_FROM_OPENWHOIS,FORGED_YAHOO_RCVD,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG 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; Wed, 31 Dec 2008 22:41:49 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1LI9km-0007ZO-SM for jmeter-user@jakarta.apache.org; Wed, 31 Dec 2008 14:41:28 -0800 Message-ID: <21237661.post@talk.nabble.com> Date: Wed, 31 Dec 2008 14:41:28 -0800 (PST) From: yaroslav1 To: jmeter-user@jakarta.apache.org Subject: Re: JDBC Request: Select returning values to variables In-Reply-To: <25aac9fc0812221149n2a2bc2b4p6c9f7b295308ba7@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: slavko_h@yahoo.com References: <20931986.post@talk.nabble.com> <25aac9fc0812221149n2a2bc2b4p6c9f7b295308ba7@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org Hi Paul-the-hat, You can use some tricky technique to get your goal. You need to update SELECT statement to use your defined column names with printing each of them in new line. Once you reach this result you can just simply use post-regular-expression-extractor to create variables for them. If you need more detail, let me know. Happy New Years everybody! sebb-2-2 wrote: > > On 10/12/2008, Paul-the-hat wrote: >> >> I'm facing the problem that I need to dynamically use data read via a >> JDBC >> Request during the subsequent test strategy. >> >> Around the beginning of November I read that the next JMeter release >> would >> include the functionality to extract data from a SELECT statement into >> user >> variables. Does anyone know when that release is likely to become >> available? >> > > Hopefully there will be a JMeter release early next year. > > The JDBC variable code is in the nightly builds (linked from the > website) if you want to give it a try. > >> Cheers >> Paul >> >> -- >> View this message in context: >> http://www.nabble.com/JDBC-Request%3A-Select-returning-values-to-variables-tp20931986p20931986.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-Request%3A-Select-returning-values-to-variables-tp20931986p21237661.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