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, 393👍, 0💬
How to validate domain name format? In order to help your programming or testing tasks, FYIcenter.co...
How to encode a URL string? URL encoding is an Internet standard defined in RFC1738 to protect speci...
How to validate email address format? In order to help your programming or testing tasks, FYIcenter....
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
How to generate user full names? Test user names are frequently needed in testing applications that ...