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]
