JDBC sampler and sql select ... as ...
I'm having some trouble with the JDBC sampler: when issuing a sql select query of the form select field1, field2 as alias2 from mytable; the resulting response has the fields named (field1, field2) instead of the expected (field1, alias2). I'm using mysql and I've checked the queries directly via the command line and there I get the correct result. I've stumbled upon this problem when joining two tables with the same field names. Anyone else had the same problem? Regards, Nicola
User Parameters Pre Processor
Hi, I was wondering why the User Parameters is a pre-processor rather than a Config Element? I just spent few minutes looking for it in the wrong place... ;) Best, Shmuel Krakower. www.Beatsoo.org - re-use your jmeter scripts for application performance monitoring from worldwide locations for free.
Re: I can not get the parameter in my jmx script
where.the name of your csv file? I dont see a file extension (csv, txt, etc) such as: stringProp name=filename/home/MSDOMAIN1/dtian/Data/stock.csv/stringProp ZK -- View this message in context: http://jmeter.512774.n5.nabble.com/I-can-not-get-the-parameter-in-my-jmx-script-tp5719674p5719675.html Sent from the JMeter - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org For additional commands, e-mail: user-h...@jmeter.apache.org
Re: User Parameters Pre Processor
On 24 March 2014 08:03, Shmuel Krakower shmul...@gmail.com wrote: Hi, I was wondering why the User Parameters is a pre-processor rather than a Config Element? I just spent few minutes looking for it in the wrong place... ;) Partly because it is. Partly because Pre-Processors are processed before every sample; Config elements are not. Best, Shmuel Krakower. www.Beatsoo.org - re-use your jmeter scripts for application performance monitoring from worldwide locations for free. - To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org For additional commands, e-mail: user-h...@jmeter.apache.org
Re: Problems authenticating using @ as sid
I am passing the variables as shown below in a post POST submit form.
[image: Inline image 1]
Jmeter is sending this in the request form and I am not getting any errors
in the jmeter.log.
*Sampler resul*t.
Thread Name: Thread Group 1-1
Sample Start: 2014-03-24 09:37:52 EDT
Load time: 19
Latency: 19
Size in bytes: 7553
Headers size in bytes: 320
Body size in bytes: 7233
Sample Count: 1
Error Count: 0
Response code: 200
Response message: OK
Response headers:
HTTP/1.1 200 OK
Date: Mon, 24 Mar 2014 13:37:52 GMT
Server: Oracle-Application-Server-11g
Content-Length: 7233
Set-Cookie: SESSID=;expires=Mon, 01-Jan-1990 08:00:00 GMT
Set-Cookie: PROXY_HASH=;expires=Mon, 01-Jan-1990 08:00:00 GMT
Connection: close
Content-Type: text/html; charset=UTF-8
Content-Language: en
HTTPSampleResult fields:
ContentType: text/html; charset=UTF-8
DataEncoding: UTF-8
*Request.*
POST http://xxx.xxx.xxx./devssb/twbkwbis.P_ValLogin
POST data:
sid=%4001294064pin=082396
Cookie Data:
TESTID=set; accessibility=false
Request Headers:
Accept-Language: en-US,en;q=0.5
Content-Length: 30
Referer: http:/xxx.xxx.xxx/devssb/twbkwbis.P_WWWLogin
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:27.0) Gecko/20100101
Firefox/27.0
Connection: keep-alive
Content-Type: application/x-www-form-urlencoded
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
*Cesar Sosa*
*Banner/Oracle Database Administrator*
*Fashion Institute of Technology*
On Sun, Mar 23, 2014 at 8:53 PM, Jeff Ohrstrom johrst...@hotmail.comwrote:
We're going to need more information probably. Are you sending these
variables as header key/value pairs, in a POST submit form or in a url
query string.
Without knowing more I'm guessing the '@' character is getting url encoded
through Jmeter which the server didn't expect.
What does Jmeter send out on the wire (through a 'view results in a tree'
listener or through http debug logs) versus what is expected (I'm assuming
how you send it through a web browser?).
From: cesar_s...@fitnyc.edu
Date: Wed, 19 Mar 2014 15:50:33 -0400
Subject: Problems authenticating using @ as sid
To: user@jmeter.apache.org
I am using JMeter 2.11 to load test Self Service on a Weblogic Server
and I
am having problem authenticating. In the ValLogin page, I created two
variables
sid ${sid}
pin ${pin}
The format for sid is like @01251234 and pin is 1234, but are having
problems when running the script. If I go the manual way and insert the
values into the varialbes, I don't have any problems. Is there any way
that I can resolve this issue?
*Cesar Sosa*
*Banner/Oracle Database Administrator*
RE: User Parameters Pre Processor
I think it is because a 'config element' is processed once when the test plan
is loaded, but a 'pre-processor' is processed before each sample is run. There
is a similar 'config element' called User Defined Variables that are
processed at load-time for the test case. But bear in mind, if you use these -
only the last one in the whole test plan is valid for a given variable.
Whereas, if you use User Parameters those are valid for a specific sample
based on the how they are defined as the test case is processing.
For example, say you have a test plan that looks like this:
User Defined Variables: username = foobar
Thread Group 1: (uses '${username}' variable)
User Defined Variables: username = notfoobar
In this case, when you run the test plan, the ${username} variable will be set
to notfoobar - because the User Defined Variables are all processed
_before_ the thread group runs - and the value is set to the last one that
defined it.
In example 2, we see User Parameters at work:
Thread Group 1:
User Parameter: username = foobar${__threadNum}
Sampler A: (uses ${username} variable)
Thread Group 2:
User Parameter: username = notfoobar${__threadNum}
Sampler B: (uses ${username} variable)
In this example, Thread Group 1 will increment the 'username' value through
foobar1, foobar2, etc. for as many different threads as you run through it.
Likewise, thread group 2 will increment the username variable through
notfoobar1, notfoobar2, etc. because the User Parameters are evaluated at
the sample run time.
--
Robin D. Wilson
Sr. Director of Web Development
KingsIsle Entertainment, Inc.
VOICE: 512-777-1861
http://www.kingsisle.com
-Original Message-
From: Shmuel Krakower [mailto:shmul...@gmail.com]
Sent: Monday, March 24, 2014 3:03 AM
To: JMeter Users List
Subject: User Parameters Pre Processor
Hi,
I was wondering why the User Parameters is a pre-processor rather than a Config
Element?
I just spent few minutes looking for it in the wrong place... ;)
Best,
Shmuel Krakower.
www.Beatsoo.org - re-use your jmeter scripts for application performance
monitoring from worldwide locations for free.
-
To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
For additional commands, e-mail: user-h...@jmeter.apache.org
RE: Problems authenticating using @ as sid
Yea it is being URL encoded. Does the server expect that? Try it in the 'POST
Body' text field instead of the default way (I forget what to call it). that
way it can be the static sid=@01294064pin=082396 and not formatted
differently. Or there's a checkbox there to url encode and inlude =. Try
unchecking the url encode.
Also did you redact the cookies or do you just not have them? Maybe you
need the cookies set before you POST. Are you doing a GET on the URL before
you POST the user/login? Or do you just jump right to the POST?
If you're not doing the GET before the POST, try doing that. And also using a
Jmeter Cookie-Manager config element to store the cookies from the GET to be
used in the subsequent POST.
From: cesar_s...@fitnyc.edu
Date: Mon, 24 Mar 2014 09:42:30 -0400
Subject: Re: Problems authenticating using @ as sid
To: user@jmeter.apache.org
I am passing the variables as shown below in a post POST submit form.
Jmeter is sending this in the request form and I am not getting any errors in
the jmeter.log.
Sampler result.Thread Name: Thread Group 1-1Sample Start: 2014-03-24
09:37:52 EDTLoad time: 19Latency: 19Size in bytes: 7553
Headers size in bytes: 320Body size in bytes: 7233Sample Count: 1Error Count:
0Response code: 200Response message: OK
Response headers:
HTTP/1.1 200 OKDate: Mon, 24 Mar 2014 13:37:52 GMTServer:
Oracle-Application-Server-11gContent-Length: 7233Set-Cookie:
SESSID=;expires=Mon, 01-Jan-1990 08:00:00 GMT
Set-Cookie: PROXY_HASH=;expires=Mon, 01-Jan-1990 08:00:00 GMTConnection:
closeContent-Type: text/html; charset=UTF-8Content-Language: en
HTTPSampleResult fields:
ContentType: text/html; charset=UTF-8DataEncoding: UTF-8
Request.POST http://xxx.xxx.xxx./devssb/twbkwbis.P_ValLogin
POST data:sid=%4001294064pin=082396
Cookie Data:TESTID=set; accessibility=false
Request Headers:Accept-Language: en-US,en;q=0.5
Content-Length: 30Referer:
http:/xxx.xxx.xxx/devssb/twbkwbis.P_WWWLoginAccept-Encoding: gzip,
deflateUser-Agent: Mozilla/5.0 (Windows NT 6.1; rv:27.0) Gecko/20100101
Firefox/27.0
Connection: keep-aliveContent-Type: application/x-www-form-urlencodedAccept:
text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Cesar Sosa
Banner/Oracle Database Administrator
Fashion Institute of Technology
On Sun, Mar 23, 2014 at 8:53 PM, Jeff Ohrstrom johrst...@hotmail.com wrote:
We're going to need more information probably. Are you sending these variables
as header key/value pairs, in a POST submit form or in a url query string.
Without knowing more I'm guessing the '@' character is getting url encoded
through Jmeter which the server didn't expect.
What does Jmeter send out on the wire (through a 'view results in a tree'
listener or through http debug logs) versus what is expected (I'm assuming how
you send it through a web browser?).
From: cesar_s...@fitnyc.edu
Date: Wed, 19 Mar 2014 15:50:33 -0400
Subject: Problems authenticating using @ as sid
To: user@jmeter.apache.org
I am using JMeter 2.11 to load test Self Service on a Weblogic Server and I
am having problem authenticating. In the ValLogin page, I created two
variables
sid ${sid}
pin ${pin}
The format for sid is like @01251234 and pin is 1234, but are having
problems when running the script. If I go the manual way and insert the
values into the varialbes, I don't have any problems. Is there any way
that I can resolve this issue?
*Cesar Sosa*
*Banner/Oracle Database Administrator*
