-1

I am trying to achieve two scenarios using JMeter. But I am facing some issues. Details are as follows. Scenario 1 : I want to test the timings of text file upload and file import in my web application Scenario 2 : Need to verify the database performance. Here I am using MySQL database (SQL Workbench)

Issues : How to capture the time taken by the application for file upload and data importing in my web application The structure of test plan for scenario 1

enter image description here

**Issues : After adding the .jar for driver its still giving an error as

Response message:java.sql.SQLException: Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver'

On selecting another driver class it is not returning anything in report.** The structure of test plan for scenario 2.

enter image description here

enter image description here

enter image description here

enter image description here

enter image description here

Amaze_Rock
  • 163
  • 3
  • 16

1 Answers1

0

You're using the wrong driver:

So you need to:

  1. Download MySQL Connector/J and drop it to JMeter Classpath
  2. Restart JMeter to pick up the .jar
  3. Change your JDBC Driver Class to com.mysql.cj.jdbc.Driver
  4. Change "Validation Query" to select 1
  5. Add an appropriate Select statement checking the file import progress

See How to Test MySQL Connection article for more information if needed.

Dmitri T
  • 159,985
  • 5
  • 83
  • 133
  • Hi, thanks set up is working but I want to test the time taken by the data of my imported file to get into database ? – Amaze_Rock Jul 08 '22 at 06:06