Re: JDBC Request question
Variable/function substitution is simple textual substitution, so if
you want to replace the string test in the following:
select from table where col = 'test'
you need to use
select from table where col = '${Var}'
i.e. the quotes are still needed
- unless you set the variable Var to include the enclosing quotes.
Could this be your problem?
==
To display the value of a variable you can add a JavaTest Sampler, and
include the value in one of its fields - e.g. the Label - which will
then show up in the Listeners.
Or you can wrap the variable/function reference in ${__log()}, for example
${__log(${Counter})}
which will print the value to the jmeter.log file.
The return value of the __log() function is its first parameter so the
enclosing text is unaffected.
Note: a variable/function that is not recognised is not logged - it is
just left as is - so if you are expecting to see 1234 and you see
${Counter} that's because Counter is not recognised as a variable.
S.
On Fri, 11 Mar 2005 21:08:08 -0500, Peter Lin [EMAIL PROTECTED] wrote:
that's what I was guessing. is username read from a previous query or
some place else?
peter
On Fri, 11 Mar 2005 21:02:32 -0500, Mike Buzzetti
[EMAIL PROTECTED] wrote:
Gino, I played around with your test plan, and I could not get it to
work with the newest nightly build. Basically the error is that
${Username} is not getting changed to the value of the username.
I don't know why, but I believe that is the problem. ( I am not 100%
positive since I only looked at it for about an hour)
anyone have any ideas?
On Fri, 11 Mar 2005 14:29:13 -0600, Craig S. Wilson [EMAIL PROTECTED]
wrote:
Gino Gargiulo wrote:
The sql is fine, I sent in the same request replacing the ${Username}
with a value 'test' and the statement ran fine.
Are there any samples of this where it is working?
I have user variables and property variables in JDBC SQL statements.
Examples of the SQL I use:
delete from job where job.id = media_title.id and media_title.account_id
= ${__property(deleteaccountjdbc.accountnamestart)};
select job_status_id from job where media_title_id = ${mtid};
Usually, when an SQL operation fails for me it is because I have some
syntax error.
--
---
Craig S. Wilson [EMAIL PROTECTED]
WaveFront Communications, Inc.
1677 Lake Valentine Road
Arden Hills MN 55112-2840
1.651.638.9594 1.612.865.8794
===
Note: If you send me HTML-mail, it will
probably end up in my SPAM bucket.
---
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: How to record script in JMETER without proxy server?
Hello Suneetha I already have sended you an attachment plz check it. If you face any problem while executing those scripts feel free to write me anytime. Reagrds SantoshK -Original Message- From: suneetha suneetha [mailto:[EMAIL PROTECTED] Sent: Sat 3/12/2005 11:47 AM To: JMeter Users List Cc: Subject: RE: How to record script in JMETER without proxy server? Hi friends I am sunita Is there any code coverage tool for dotnet that to related to jmeter if any one knows about this please mail me thanks sunita Jayashree K [EMAIL PROTECTED] wrote::-) Mike, I recorded script in bad boy and now I'm trying to execute that in JMeter. Will that also create a prob in JMeter? (I means HTTPS). Is any special settings I need to take care of? Another prob, with me is my records are not getting saved in database. And Post query is on https only :-( Michael Stover wrote: HTTPS requests cannot be intercepted and recorded by JMeter. http://wiki.apache.org/jakarta-jmeter/JMeterFAQ#head-d7d6b439cbb64a17ac50c302cf9bbc483ccc0d3e -Mike On Thu, 2005-03-10 at 01:01, Jayashree K wrote: :-)) This is very strange. I tried it outguess what??? It DID WORKED for me even :-) But, still I got stuck in further problem. It did worked for HTTP request. I means HTTP Protocol got recorded...but since in between there is HTTPS ...protocol. Recording stopped and I can't move further now. :-( Any other strange idea for this? Thx, Jayashree Kiran wrote: Hi , I am very new to jmeter.But I faced this .In that case What I did is ,I gave the URL of website and site is loaded. Then I change the settings as local host and 80. Click START in jmeter to record. I was able to go navigate and record. Instead if u change setting to localhost and 80 at the beginning and try to load the site ,it will give page cannot be displayed. I am not sure whether it is the correct way. But it worked for me. Regards Kiran -Original Message- From: Jayashree K [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 10:22 AM To: jmeter-user@jakarta.apache.org Subject: How to record script in JMETER without proxy server? Jmeter help says to have IE Settings and Jmeter-HTTP Proxy server to be same. specify Ex: Localhost 80 at both the places. Then recording happesn. TRUE. But here, When I specify localhost and 80 in my IE. I'm not able to see the website (Page can't be displayed comes.) Here, proxy is transperent. So now what to do? Unless and until I specify anything, HOW can i record? From SysAdmin, I got to know one IP and 3128 as port. When I set that in IE...i can access the pages. But when I specify that in HTTP Proxy Server of JMETER...It doesn't work. REcording doesn't happen. Is there any way to do the recording in JMeter in such cases? OR If Address and port is other than 80 or 8080. How to do recording with other machines IP and Port?? Can anyone plz let me know the steps to do? Thx Jayashree - Do you Yahoo!? Yahoo! Small Business - Try our new resources site! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Do you Yahoo!? Make Yahoo! your home page -- Michael Stover Apache Software Foundation - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Do you Yahoo!? Yahoo! Small Business - Try our new resources site! - Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL
Re: random controller question
On Fri, 11 Mar 2005 23:54:55 +, sebb [EMAIL PROTECTED] wrote: On Fri, 11 Mar 2005 17:55:27 -0500, Nathan J. Mehl [EMAIL PROTECTED] wrote: If I have a test plan that looks like this: Random Controller [...] By the way, there is a minor bug in the randomisation - the first time, the first item is always selected. Thereafter, it is random. Sorry, that was wrong - the Random Controller does not always select the first item the first time. S. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE Cookie Manager Session Issue
Thanks for the tip. I checked out all the javascript and didn't see any issue with the session. I also got better and determining the result of a request from a view results tree and found that the login attempt was failing. I fixed this and now it works. I assumed those accounts were good since they were used successfully recently... Thanks for your suggestions... - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Graph Result Throughput
I can't find a way to search the mailing list archive to see if this question has been asked before, so I apologize if it has. I'm thinking there must be a way to do this, I just don't know what it is... In any case, I'm a little confused over what the throughput average actually means. I ran my first test with just 1 user and noticed that the throughput started at about 20 trxn / min and climbed all the way to 217 trxn / min within 14000 samples. There is no think time. All other results remained reasonably constant. I would expect that throughput should also remain fairly constant. I want to run tests with more users and compare throughput; and response but I don't trust the numbers I'm getting for throughput. Is there a problem here or can this be explained? Thanks in advance... - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
