Re: JDBC requests with alternating variables
On 12/10/2007, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hey,
I stated this in another post but decided to create my own for tracking
purposes.
My current setup is as such,
3+ Thread groups
Why use multiple thread groups?
3+ JDBC Connection Elements
Runtimers
Loop Timers
and 45 individual JDBC Requests.
The reason i am looking for a method of creating an alternating JDBC request
becomes obviouse as constantly having to come up with unique searchs becomes
more and more combersome and time consuming.
Alternating implies repetition (e.g. 1,2,3,1,2,3) but then you mention
unique - which do you mean? Or do you mean variable request?
With 5 JDBC requests configured to have alternating values i could
constantly have changing searches and never have an instance or a cached
search happening and thus contaminating my results. problem is i do not know
how to create the said JDBC request.
Is it also possible to have an element alternate between different databases
without having to creat an entirely new element/thread group?
You need 1 pool for each unique set of connection attributes (database
name, driver, username etc)
The JDBC request uses the pool name to get the database connection;
the pool name can be a variable, and the SQL statement can use
variables as well.
e.g. JDBC sampler:
pool: ${pool}
statement: select ${col1} from ${table} where ${col2} = '${value}'
You may also be able to use a prepared statement with the appropriate values.
I am not a coder and would need a pretty good run down of how to perform
that kind of action. Still very new to the coding arena.
JMeter does not require coding but like any test application you
need to read the manual (probably a few times).
Equally importantly, you need a good understanding of the system you
are testing and particularly what you are trying to achieve by
running the tests.
regards,
[EMAIL PROTECTED]
--
View this message in context:
http://www.nabble.com/JDBC-requests-with-alternating-variables-tf4614204.html#a13177071
Sent from the JMeter - User mailing list archive at Nabble.com.
-
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: test plan stop working after adding a HTTP Header Manager
What do you mean no longer works ? Do the samples return errors? Or perhaps no samples are generated? Have you checked jmeter.log? Any messages in the console window? Are there any other Header Managers in the test plan? On 12/10/2007, Richard Hubbell [EMAIL PROTECTED] wrote: I've got a spider-like test plan that recurses to a limite d depth. Some sites reject the default User-Agent and so I added a Header Manager to alter the User-Agent string. But after I add the Header Manager my test plan no longer works. I don't see anything in logs. Any ideas? Is it a scope problem? I moved the Header Manager around to have a different scope but didn't matter. Tonight's top picks. What will you watch tonight? Preview the hottest shows on Yahoo! TV. http://tv.yahoo.com/ - 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]
How to generate delays with a function
Hello folks, I would like to generate a delay between HTTP requests that follows a sinusoidal function, e.g. wait between 0 and 100 ms according to a sine wave. I was thinking of using the __Javascript variable along with a constant throughput timer, or a counter preprocessor along with a BeanShell timer. I would greatly appreciate hearing from anyone who has done something like this. Regards, Marc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: How to generate delays with a function
I don't think the Constant Throughput timer would be suitable. You can use the Constant Timer with a variable or function to define the wait. Or the BeanShell timer. Something to watch out for - functions are single-threaded, so don't put the wait in a function. However you can put the wait-time calculation in a function, and use it from a Timer. Remember that Timers are aggregated and applied before any samplers which are in scope. What are you intending to base the sine calculation on? Elapsed time? Samples? Loops? S. On 12/10/2007, Marc Chiarini (Tufts) [EMAIL PROTECTED] wrote: Hello folks, I would like to generate a delay between HTTP requests that follows a sinusoidal function, e.g. wait between 0 and 100 ms according to a sine wave. I was thinking of using the __Javascript variable along with a constant throughput timer, or a counter preprocessor along with a BeanShell timer. I would greatly appreciate hearing from anyone who has done something like this. Regards, Marc - 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]
