Jmeter-Database testing with jmeter

Now here we again come with new topic Jmeter database testing. Now for database testing we have download mysql-connector-java jar file and placed in lib folder of jmeter then we start with the Thread group.

threadgroup

 

Now we make a JDBC connection configuration.

jdbc-connection

 

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

jdbcconn

 

Now we add a sampler for JDBC request.

jdbcrequest

In JDBC request we define the query like if we run select query we select the select statement in query type.

jdbcreq

We can see the result in view result tree listener

jdbcviewresult

 

Also we can see the result in summary report.

jdbcsummary

 

Thanks..

Written by 

Joseph Ross is a Principal Consultant at Knoldus Inc. having more than 10 years of experience. Joseph has a passion for identifying challenges and give impactful solutions to the clients. He is a football fan and loves to watch TV series. Joseph has a cross-functional business operations and technology consulting experience. Joseph is familiar with programming languages such as Scala, C++, Java, CSS and HTML.

Leave a Reply

%d bloggers like this: