View Result of JDBC Request Sampler
How to view test result of a JMeter JDBC request? I created one to verify access to my MySQL server.
You can follow this tutorial to view test result of a JMeter JDBC request.
1. Start JMeter on your computer and open "\fyicenter\First-Load-Test-5.jmx".
2. Add a "View Result Tree" in the "tearDown Thread Group", below the "MySQL Access Test" JDBC Request sampler.
3. Save the test plan and run it.
4. Click "MySQL Access Test" in the "View Result Tree" screen. Then open the "Response Data" tab You see the query result:
You may see access denied errors, if you provided the wrong username or password:
Cannot create PoolableConnectionFactory (Access denied for user 'john'@'localhost' (using password: YES))
You may SQL syntax errors, if you made any mistakes in the query statement:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@@version' at line 1
The picture below shows you how to view test result of a JDBC request sampler:
2017-11-18, 346👍, 0💬
How to validate credit card numbers? In order to help your programming or testing tasks, FYIcenter.c...
How to generate email addresses? To help you to obtain some email addresses for testing purpose, FYI...
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
How to generate MAC addresses? To help you to obtain some MAC addresses for testing purpose, FYIcent...
How to perform regular expression pattern match with multiple occurrences? To perform a regular expr...