What happens when both the A & B configs and A & B samplers are in the same scope?
As far as I know, this is supposed to work. S. On 09/02/06, Ivan Rancati <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]