All I can suggest is to try running the tests with only one thread. S. On 4/12/05, Andre Dittmar <[EMAIL PROTECTED]> wrote: > Hello sebb, > > > That seems to be saying: > > Unknown database "wzf" > > Does that database exist? > > Thanks for your quick response. This was my fault, I mixed different > logfile-results in the hurry :-/ Here again the lastest testcases. This time, > everything should be fine. This tests were started on my local machine, trying > to connect on localhost which also running as a WAMP-server. Still using a > JDBC-Request with the mysql_connector-JAR-file > > TEST_1 > JDBC URL: jdbc:mysql://127.0.0.1:3306/wzm2004 > Driver Class: com.mysql.jdbc.Driver > User:mysql > Password:***** (same like the user, at local machine) > > Using a Query like: SELECT * FROM `be_users` WHERE email LIKE > '%werkzeugforum%', > which will return some data for sure > > Response Asseration using the pattern werkzeugforum, which should be found for > sure I guess? > > RESULT_1 > 1. Graph result stays empty > > 2. Assertion result stays empty > In both cases there is nothing particular in the files: > <?xml version="1.0" encoding="UTF-8"?> > <testResults> > </testResults> > > 3. Logfile seems allright: > 2005/04/12 14:32:44 INFO - jmeter.engine.StandardJMeterEngine: Running the > test! > 2005/04/12 14:32:44 INFO - jmeter.engine.StandardJMeterEngine: About to call > test listeners > 2005/04/12 14:32:44 INFO - jmeter.engine.StandardJMeterEngine: Notifying test > listener: org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler > 2005/04/12 14:32:44 INFO - jmeter.engine.StandardJMeterEngine: Notifying test > listener: org.apache.jmeter.reporters.ResultCollector > 2005/04/12 14:32:44 INFO - jmeter.engine.StandardJMeterEngine: Notifying test > listener: org.apache.jmeter.reporters.ResultCollector > 2005/04/12 14:32:44 INFO - jmeter.engine.StandardJMeterEngine: Notifying test > listener: org.apache.jmeter.protocol.http.control.CookieManager > 2005/04/12 14:32:44 INFO - jmeter.engine.StandardJMeterEngine: Notifying test > listener: org.apache.jmeter.gui.MainFrame > 2005/04/12 14:32:44 INFO - jmeter.gui.util.JMeterMenuBar: > setRunning(true,local) > 2005/04/12 14:32:44 INFO - jmeter.engine.StandardJMeterEngine: Starting 10 > threads for group JDBC Users. Ramp up = 2. > 2005/04/12 14:32:44 INFO - jmeter.engine.StandardJMeterEngine: Continue on > error > 2005/04/12 14:32:44 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-1 > started > 2005/04/12 14:32:44 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-1 > is done > 2005/04/12 14:32:44 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-2 > started > 2005/04/12 14:32:44 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-2 > is done > 2005/04/12 14:32:44 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-3 > started > 2005/04/12 14:32:44 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-3 > is done > 2005/04/12 14:32:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-4 > started > 2005/04/12 14:32:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-4 > is done > 2005/04/12 14:32:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-5 > started > 2005/04/12 14:32:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-5 > is done > 2005/04/12 14:32:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-6 > started > 2005/04/12 14:32:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-6 > is done > 2005/04/12 14:32:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-7 > started > 2005/04/12 14:32:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-7 > is done > 2005/04/12 14:32:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-8 > started > 2005/04/12 14:32:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-8 > is done > 2005/04/12 14:32:46 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-9 > started > 2005/04/12 14:32:46 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-9 > is done > 2005/04/12 14:32:46 INFO - jmeter.threads.JMeterThread: Thread JDBC Users > 1-10 > started > 2005/04/12 14:32:46 INFO - jmeter.threads.JMeterThread: Thread JDBC Users > 1-10 > is done > 2005/04/12 14:32:46 INFO - jmeter.engine.StandardJMeterEngine: Notifying > listeners of end of test > 2005/04/12 14:32:46 INFO - jmeter.engine.StandardJMeterEngine: Notifying test > listener: org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler > 2005/04/12 14:32:46 INFO - jmeter.engine.StandardJMeterEngine: Notifying test > listener: org.apache.jmeter.reporters.ResultCollector > 2005/04/12 14:32:46 INFO - jmeter.engine.StandardJMeterEngine: Notifying test > listener: org.apache.jmeter.reporters.ResultCollector > 2005/04/12 14:32:46 INFO - jmeter.engine.StandardJMeterEngine: Notifying test > listener: org.apache.jmeter.protocol.http.control.CookieManager > 2005/04/12 14:32:46 INFO - jmeter.engine.StandardJMeterEngine: Notifying test > listener: org.apache.jmeter.gui.MainFrame > 2005/04/12 14:32:46 INFO - jmeter.gui.util.JMeterMenuBar: > setRunning(false,local) > 2005/04/12 14:32:46 INFO - jmeter.engine.StandardJMeterEngine: Test has ended > > TEST_2 > JDBC URL: jdbc:mysql://127.0.0.1:3306/wzm2004?user=mysql&password=mysql > Driver Class: com.mysql.jdbc.Driver > User: > Password: > This time I leave User & Password still empty, extend the JDBC URL with > parameters according to the mysql-connector manual. > > Same Query and Response Asseration like in TEST_1 > > RESULT_2 > 1. Graph result starts painting some lines and curves > > 2. Asseration result return rows like: > ... > jdbc:mysql://127.0.0.1:3306/wzm2004?user=mysql&password=mysql, user: > SELECT * FROM `be_users` WHERE email LIKE '%werkzeugforum%' > Response (or URL) was null > ... > 3. Logfile says: > ... > 2005/04/12 14:41:45 INFO - jmeter.threads.JMeterThread: Thread JDBC Users 1-1 > started > 2005/04/12 14:41:45 ERROR - jmeter.protocol.jdbc.util.JMeter19ConnectionPool: > Couldn't get connection to database java.sql.SQLException: Keine > Zugriffsberechtigung f�r Benutzer: '@localhost' f�r Datenbank > 'wzm2004'. > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:750) > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1205) > at com.mysql.jdbc.Connection.createNewIO(Connection.java:1768) > at com.mysql.jdbc.Connection.<init>(Connection.java:430) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268) > at java.sql.DriverManager.getConnection(Unknown Source) > at java.sql.DriverManager.getConnection(Unknown Source) > at > org.apache.jmeter.protocol.jdbc.util.JMeter19ConnectionPool.validateMaxConnections(JMeter19ConnectionPool.java:88) > at > org.apache.jmeter.protocol.jdbc.util.JMeter19ConnectionPool.<init>(JMeter19ConnectionPool.java:64) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown > Source) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown > Source) > at java.lang.reflect.Constructor.newInstance(Unknown Source) > at > org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.createConnectionPool(DBConnectionManager.java:132) > at > org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.getKey(DBConnectionManager.java:104) > at > org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.getKey(JDBCSampler.java:185) > at > org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:102) > at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:281) > at java.lang.Thread.run(Unknown Source) > > 2005/04/12 14:41:45 WARN - jmeter.protocol.jdbc.util.DBConnectionManager: > Exception getting database connection from pool > org.apache.jmeter.protocol.jdbc.util.NoConnectionsAvailableException > ... > Error written in german which means in english something like: 'No access > authorization' for '@localhost' for database 'wzm2004'. Why the program try to > access the database with @localhost? Probably caused by the empty > user/password > field? Why doesn't the program recognize the JDBC URL with the user/password > as > parameters. Did I somewhere an syntaxerror? > > TEST_3: Mixing TEST_1 and TEST_2, means using the JDBC URL with parameters and > aditionally filling out the user/password-fields. > Result is exactly the same like TEST_1... > > Any more help is more than appreciated! > Thanks & regards, > Andre > > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
