Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Database Testing With JMeter

DZone's Guide to

Database Testing With JMeter

JMeter database testing starts with downloading a JAR file, placing it in JMeter, and then heading to the thread group. Read on for all of the details.

· Performance Zone ·
Free Resource

Sensu is an open source monitoring event pipeline. Try it today.

We're here with a new topic: JMeter database testing. For database testing, we have downloaded a mysql-connector-java JAR file and placed it in the lib folder of JMeter. Now, we start with the thread group.

threadgroup

Now, we make a JDBC connection configuration.

jdbc-connection

In the JDBC connection configuration, we will define the database URL, JDBC driver class, the MySQL username and password, etc.

jdbcconn

Now, we add a sampler for the JDBC request.

jdbcrequest

In the JDBC request, we define the query. For example, if we're running a select query, we select the select statement in Query Type.

jdbcreq

We can see the result in the View Results Tree listener:

jdbcviewresult

Also, we can see the result in the Summary Report.

jdbcsummary

That's it!

Sensu: workflow automation for monitoring. Learn more—download the whitepaper.

Topics:
jmeter ,database testing ,performance ,tutorial

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}