DEV Community

loading...

Database Loadtest using JMeter

Raghwendra Sonu
Automation Testing expert with diverse tools and technologies. Expertise in Web Automation, Mobile Automation, Performance Testing, API (WebServices Testing), Automation Testing Frameworks.
・1 min read

In this article we are going to see how to create a test plan in JMeter for Database testing.

Step1: Goto your JMeter, and create a new testplan, add "JDBC Connection Configuration" from Add -> Config Element.
Alt Text

Here we need to provide the details of database.
Database URL: //URL to connect to DB
JDBC driver class:

Username: root //DB Username
Password: admin //Password to login to DB
Maximum number of connections: 10
Variable Name: test

Step2: We need to add mysql-connector-java jar in JMeter lib folder, since we are testing MySQL DB. You can either download this jar from https://dev.mysql.com/downloads/connector/j/
or, if you already have MySQL installation on local system, you can get "mysql-connector-java-8.0.17.jar" from "C:\Program Files (x86)\MySQL\Connector J 8.0" folder.
Once copied, restart JMeter.

Step3: Add JDBC request, Add -> Sampler -> JDBC Request.
add, Variable Name: test // This is a way to tell JMeter that this JDBC request will use configuration named "test" in "JDBC Connection Configuration".
And in SQL Statement placeholder write our query:
Select * from TMS

Step4: To see the results, add view results in tree and table listeners.

Step5: Run and validate the results.

This is how we can do performance test on Database.

Discussion (0)

Forem Open with the Forem app