Sebb --> I don't know if it was missing from the manual. I'd attribute it to
me being a complete n00b at this point.
--
View this message in context:
http://jmeter.512774.n5.nabble.com/Using-values-from-DB-for-a-HTTP-request-tp4453447p4454609.html
Sent from the JMeter - User mailing list archive
You are right Deepak, CSV is much easier way to do it. But I do it for
exercise and not to solve a specific task. I just wanted to see how it works
in Jmeter and you sure did help with your tips.
BTW, I defined users and password in the DB just for the sake of the
exercise, I would never obviously
just to expand on that. If you setup jmeter for multiple threads then each
thread will execute the JDBC request and each thread will loop through all
the results. This is probably not what you want.
Usually you have say a 100 users and you want say 10 threads to pick up one
from this. As before you
sigh - i dont know why i thought that worked.
On Sat, Jun 4, 2011 at 10:33 AM, Bruce Ide wrote:
> I believe you always get an array, even if only 1 thing is returned. If you
> request more than 1 column from the database you can use a comma separated
> list of variables.
>
> If you haven't tried
surely you dont want to do this in 1 thread.
On Sat, Jun 4, 2011 at 11:44 AM, pavelz wrote:
> My next step would be automating a loop that would go through all the users
> and passwords that are stored.
> Let's see how can I do it... If someone has a suggestion, I'd be really
> happy to hear it!
On 4 June 2011 19:40, pavelz wrote:
> Thanks a lot guys, I finally made it! I think so anyway :)
> Extra thanks to Bruce, your tip nailed it!
It would be very helpful if you could say what is missing from the
User Manual in this regard so it can be improved for the future.
> --
> View this messa
My next step would be automating a loop that would go through all the users
and passwords that are stored.
Let's see how can I do it... If someone has a suggestion, I'd be really
happy to hear it!
--
View this message in context:
http://jmeter.512774.n5.nabble.com/Using-values-from-DB-for-a-HTTP-
Thanks a lot guys, I finally made it! I think so anyway :)
Extra thanks to Bruce, your tip nailed it!
--
View this message in context:
http://jmeter.512774.n5.nabble.com/Using-values-from-DB-for-a-HTTP-request-tp4453447p4454522.html
Sent from the JMeter - User mailing list archive at Nabble.com.
I believe you always get an array, even if only 1 thing is returned. If you
request more than 1 column from the database you can use a comma separated
list of variables.
If you haven't tried a simple test to see what it does, I suggest doing so.
Just make a test with a JDBC Config data element, a
hi
your JDBC request query should be something like
select username,passwords from usernamepasswords (you want both returned
right) - You should be able to see what this returns in view results tree.
You should also be able to check jmeter.log for errors
The parameter text boxes are data that you
Ok, I think I am advancing here. I can see that the parameter that is passed
on is "null" which is what I have defined if the query doesn't return
anything.
Is there a possibility that the JDBC connection doesn't work right? Is there
a way to see if the Test Plan attempts the query successfully? I
Have you provided a list of variable names on the JDBC screen?
Please see the user manual for details.
On 4 June 2011 12:48, pavelz wrote:
> Ok, can you please give me an example how to set it up or at least to test if
> i even catch those parameters successfully?
> I have attached 3 screenshots
Ok, can you please give me an example how to set it up or at least to test if
i even catch those parameters successfully?
I have attached 3 screenshots, I must being wrong in a very specific portion
of my plan.
http://jmeter.512774.n5.nabble.com/file/n4453787/syxg1x.jpg
http://jmeter.512774.n5.n
On 4 June 2011 12:25, pavelz wrote:
> OK, I got a question.
> I didn't quite understand what values to input into the Parameter Values
> field in JDBC request.
> I need to do a simple select that will retrieve me a list of users and
> passwords..
"If the Variable Names list is provided, then for
OK, I got a question.
I didn't quite understand what values to input into the Parameter Values
field in JDBC request.
I need to do a simple select that will retrieve me a list of users and
passwords..
--
View this message in context:
http://jmeter.512774.n5.nabble.com/Using-values-from-DB-for-a-
Hi Sebb. I am using the recent one, 2.4.
I read it but I will re-read it again.
Thanks a lot!
--
View this message in context:
http://jmeter.512774.n5.nabble.com/Using-values-from-DB-for-a-HTTP-request-tp4453447p4453743.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---
On 4 June 2011 11:30, pavelz wrote:
> I can't seem to do it right and to extract the correct information for some
> reason.
> Basically I got a table with 2 columns: user and password.
What version of JMeter are you using?
Have you read this?
http://jakarta.apache.org/jmeter/usermanual/componen
I can't seem to do it right and to extract the correct information for some
reason.
Basically I got a table with 2 columns: user and password.
Now I want to extract every time one user and one corresponding password,
sample these 2 and pass them as a variable in HTTP Request. For some reason
the De
Thank you soo very much Deepak!
I managed to work with the CSV easily but I want to learn to extract info
from database as well. I will try now what you have proposed and see how it
unfolds.
Once again, thanks for a brief reply!
--
View this message in context:
http://jmeter.512774.n5.nabble.com/
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 s
20 matches
Mail list logo
