I found a way to get this to work:
- create two Connection Configuration objects with different pool names
- limit the scope of the Configuration object using a logic controller
Example
Thread group
JDBC Connection Configuration for pool 1 pointing to database A
JDBC Request for database A
Simple Controller
JDBC Connection Configuration for pool 2 pointing to database B
JDBC Request for database B
.....
JDBC Request for database A
As it might be of interest I thought I'd share it; apologies if it's old
news, or if it's clearly explained in the documentation
Ivan
Ivan Rancati wrote:
> I think this is not possible with the JDBC Request, but based on this
> email discussion I thought I'd ask
> http://marc.theaimsgroup.com/?l=jmeter-user&m=106285267110499&w=2
> ...
>
> If you specified two connections with the same URL but different
> user/password, it would still use only one pool, and only one
> username/password. This problem should be fixed in the latest code in
> CVS, but has not been fixed in the 1.9 branch.
>
> ...
>
> I tried to specify two different JDBC connection configuration, each of
> them with a different pool variable name, and then some JDBC request
> that reference one of the pools.
> What happens (which I think is by design, but all suggestions are
> welcome) is that the first pool is instantiated, the second one is not,
> and its corresponding request fail with this
>
> 2006/02/08 18:21:49 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler:
> Error in JDBC sampling java.sql.SQLException: No pool created
> at
> org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:76)
> at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:247)
> at java.lang.Thread.run(Thread.java:595)
>
>
> thanks
>
>
--
Ivan Rancati
SharpMind QA
--
Ivan Rancati
SharpMind QA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
