Mailing-List: contact jmeter-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <jmeter-user@jakarta.apache.org>
Received-SPF: pass (athena.apache.org: domain of shettyd@gmail.com designates
 74.125.83.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=i0Gdi9GEVqaSSrt5y20JMDgHSdPc27dsDNzU9wK8bkHogHhFXDS5oRWq+enGis3Hgc
         0KFgO2UL8U4TSaqfQVtmlw0eU7bBGZFSQvY5hWQ2LNiPpmbT0TgkeyFsySjofqzYWpxH
         Q41HYxB/rSpWt/ADD/c+lfjiff1rlE+RfNv6w=
MIME-Version: 1.0
In-Reply-To: <1307175999890-4453447.post@n5.nabble.com>
References: <1307175999890-4453447.post@n5.nabble.com>
Date: Sat, 4 Jun 2011 01:42:18 -0700
Message-ID: <BANLkTi=im4TyJPxEO7+Py0jwfjwX8ZC1OA@mail.gmail.com>
Subject: Re: Using values from DB for a HTTP request
From: Deepak Shetty <shettyd@gmail.com>
To: JMeter Users List <jmeter-user@jakarta.apache.org>
Content-Type: multipart/alternative; boundary=000e0cd6d10813fcdd04a4ded93a

--000e0cd6d10813fcdd04a4ded93a
Content-Type: text/plain; charset=ISO-8859-1

the simple answer is to use a CSV file instead (Im assuming eventually you
will want to run your test with multiple threads and this user name will
vary per thread).

Then you simply use the CSV Data Set config . In the variable name field you
specify say username,password (number of variables is same as number of
columns in your CSV) and in your HTTP request you use ${username} and
${password} wherever you want to post the value.
various comments in the mail archives describe this

You can ofcourse use various techniques to generate this CSV (including
generating it from within Jmeter, but usually this is done outside the test)
-


If you still wanted to answer your original question then
+Threadgroup
++JDBC Connection Configuration (db settings, datasource name)
++JDBC Request Sampler (uses above datasource, in the variable names field
specify any names (number should be same as columns returned by sql - e.g.
username,password
++Debug Sampler (to validate what is being returned , you can remove once
you get it working
++HTTP Sampler (use ${username} and ${password} for parameter values -
assuming only 1 row is returned
+View Results tree listener

if you database stores password in anything other than a one way salted hash
then you have a serious security risk.

regards
deepak

On Sat, Jun 4, 2011 at 1:26 AM, pavelz <zagalsky@gmail.com> wrote:

> Hi guys, I'm a n00b here so I'd really appreciate your help on some small
> thing:
> I need to extract from DB a user and a password in order to pass them as
> parameters within HTTP request.
> For some reason what I do at the moment I fail miserably.
> Many thanks in advance!
> Pavel
>
> --
> View this message in context:
> http://jmeter.512774.n5.nabble.com/Using-values-from-DB-for-a-HTTP-request-tp4453447p4453447.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
>
>

--000e0cd6d10813fcdd04a4ded93a--