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:
â‡‘â‡‘ Apache JMeter Tutorials
2017-10-11, 1881👍, 0💬
How to generate date and time test values? Timestamp values are frequently needed in testing almost ...
How to validate credit card numbers? In order to help your programming or testing tasks, FYIcenter.c...
Where to find tutorials on Apache JMeter test tool? I want to know how to use Apache JMeter. Here is...
How to perform regular expression pattern match with multiple occurrences? To perform a regular expr...
How to generate currency test values? Currency test values are frequently needed in testing date and...