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..

This entry was posted in Scala. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s