I am new to jmeter load testing. I am doing tests for a web based application. Will the load testing actions can be seen from the DB BE? for ex: If I am doing load testing for ordering items from amazon for 100 threads, can I see the load from Back end like 100 people ordered from amazon is recorded in DB?
JMeter is a tool to manage interactions with services, e.g. manage HTTP requests. It does not affect how your services will deal with the interactions.
So, to answer if your interactions will change the state of a DB, then: Not necessarily.
It will depend on what service you are hitting.
You may have a service that is running locally configured to use a stubbed DB, returning always some specific value. You may have a repository in the file system. You may... because databases are details.
So, if you want to see the results of your interactions in a DB, you have to hit a service that will change the DB state based on the interactions you are doing.
answered Sep 14 '20 at 15:08
Yes you can, JMeter provides the following test elements for working with databases:
- JDBC Connection Configuration - where you can put your database URL, credentials, etc.
- JDBC Request sampler - where you can place your SQL queries to verify presence of certain entities in the database
See How to Retrieve Database Data for API Testing with JMeter for example JMeter configuration for database communication.
Remember that you'll need to download the appropriate JDBC driver for your database and put it into JMeter Classpath as JMeter is not shipped with any database driver libraries
