jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nermin Caluk" <ner...@atlantbh.com>
Subject RE: Issues with JDBC Request and variables
Date Wed, 27 Jul 2011 06:46:24 GMT
Derek, 

Regarding the issue #2, substitution, have you tried using __evalVar instead
of __V? "V" function evaluates a variable name and you need "evalVar" to
actually get the value [integer in your case] stored in that variable. 

As for the first issue, double check the values using Debug Sampler (before
and after your JDBC sampler) and also try if extracting the value from
response works for you. Why do you use ${count_1}, i.e. what's stored in
${count}? Depending on JMeter version you're using, did you set "Parameter
Types" in your JDBC sampler?

Nermin

-----Original Message-----
From: derekmw [mailto:derekwrobeltest@gmail.com] 
Sent: 26. srpanj 2011 20:21
To: jmeter-user@jakarta.apache.org
Subject: Issues with JDBC Request and variables

Hi,

I apologize if this has been answered as I am not sure what to search for. 
I believe this is a unique situation.  I have two problems:

1. I have a JDBC request which does a VERY simple "select statement" with
the following sql:
select count(member_id) from member

This is then stored in a variable named count.  I know what the count should
be (should be 312), but the value count_1 gets is 40077.  What is even more
troubling is at some point, it started working and getting the correct
count.  Any idea what is going on?

2. In a seperate JDBC request, I retrieve a list of members:
select member_id from members

This is stored in a variable named members.  Then I created a THIRD JDBC
request to query and grab a random member:
select * from members where member_id = ?

In "Parameter values", I put in ${__V(member_${__Random(1,10)})} (note I put
10, not $count because I can't even get it to work correctly with a hard
coded number).  I see that this gets parsed correctly, but the error I get
is:

org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer:
"member_7"

So it's not substituting the member_7 variable's value.  Instead it's just
passing the string.  What am I doing wrong here?



--
View this message in context:
http://jmeter.512774.n5.nabble.com/Issues-with-JDBC-Request-and-variables-tp
4635807p4635807.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


Mime
View raw message