What do you mean you have to restart JMeter to run a different test plan? That doesn't happen to me (and I've fixed my problem with start/stop).
Your change in "addCustomTestElement" might break things. If something extends ConfigTestElement but shouldn't be merged in, then that'll cause a problem. I would suggest putting debug code into the DBKey class, and see for yourself all the parameters the JDBCSampler is using. If the username and password are there, maybe the problem is with the way JMeter invokes the PostGreSQL driver? -Mike -----Original Message----- From: Martin Ramshaw [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 1:50 PM To: JMeter Developers Subject: RE: Login Config Element vs. Login Configuration (JDBC Request & FTP Request) >The JDBC worked Ok for me, though I am having other problems (I >can't start test, stop, and then start again under certain conditions, but >that has to do with other things, not JDBC). Me neither. Ctrl-C will kill it though. Also, it would be nice to be able to load a different test plan without having to close down and re-start. I know that you are actively working on this stuff, so this is just a comment. The drag-n-drop stuff is pretty cool. >Can you be more specific about your problem? By adding debug statements, I was able to see that the user parameters were not getting to the DBConnectionManager. The problem seemed to be that these values were not getting set in the JDBCSampler. I thought that something like the following might be the problem: diff -u JDBCSampler.java JDBCSampler.java_wip --- JDBCSampler.java Tue May 28 14:20:03 2002 +++ JDBCSampler.java_wip Thu May 23 15:26:07 2002 @@ -100,8 +100,9 @@ public void addCustomTestElement(TestElement element) { + System.out.println("JDBCSampler element = " + element); if(element instanceof SqlConfig || element instanceof PoolConfig || - element instanceof DbConfig) + element instanceof DbConfig || element instanceof ConfigTestElement) { this.mergeIn(element); } (I tried an FTP test plan, which also had problems with the user parameters) Here's a partial stack trace (the test plan is attached): martin@living:~/JMeter/jakarta-jmeter/bin> ./jmeter log4j:ERROR No appenders could be found for category (org.apache.jmeter.util.ClassFinder). log4j:ERROR Please initialize the log4j system properly. Running the test! found 1 threadgroups notifying test listeners: 3 (No such file or directory) number of threads = 1 starting a thread:tree list = [org.apache.jmeter.threads.ThreadGroup@d9e279] Thread Thread Group1 started Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLException: No Postgres username specified in startup packet. Stack Trace: java.sql.SQLException: No Postgres username specified in startup packet. at org.postgresql.Connection.openConnection(Connection.java:170) at org.postgresql.Driver.connect(Driver.java:122) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.setup(DBConnectionM anager.java:152) at org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.getKey(DBConnection Manager.java:124) at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.getKey(JDBCSampler.java: 263) at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java: 149) at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:114) at java.lang.Thread.run(Thread.java:536) End of Stack Trace at org.postgresql.Driver.connect(Driver.java:131) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.setup(DBConnectionM anager.java:152) at org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.getKey(DBConnection Manager.java:124) at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.getKey(JDBCSampler.java: 263) at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java: 149) at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:114) at java.lang.Thread.run(Thread.java:536) ConnectionObject: e=Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLException: No Postgres username specified in startup packet. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
