If specified for SELECT statements, it holds the values from the relevant result set columns.
The purpose of this interaction is to check the correct record of specific data in the database or to prepare test data for the tests by adding specific records to the database.
All SQL queries in this article are made against Chinook Database version 1.4, which is a sample database representing an online music and media store.
If you want to replicate them, download and import that sample database to your server.
In such a case, we will get an empty response, but JMeter won't report it as an error.
It will look like this: To check if the response was correct, we can take the next steps: Add the Bean Shell Assertion element as a child element to the JDBC Request element: Add the code as shown in the picture: Now, when getting an empty response, all further acts or requests in the Thread Group will be stopped and the correct error message will appear: Sometimes, there are cases when the connection to the database is temporarily unavailable, the IP address has been changed, or some other reasons have arisen, as a result of which there was no response from the database.