Search code examples
jmeterautomated-testsperformance-testingload-testingdatabase-testing

How to capture the file upload, import timing and database performance testing in JMeter

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

Solution

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