Master Multi‑Data Testing in JMeter with CSV, Functions, and JDBC Assertions

1. Multi‑Data Testing in JMeter

1.1 CSV Data Set Config

Create a CSV file that contains the test data, for example:

username,password
user1,pass1
user2,pass2

In JMeter, right‑click the Thread Group → Add → Config Element → CSV Data Set Config . Set the file path, specify variable names (e.g., username and password), and reference them in samplers with ${username} and ${password}.

1.2 Built‑in Functions

JMeter provides functions such as __StringFromFile and __FileToString that can read file contents at runtime, allowing dynamic data generation for more complex scenarios.

2. JDBC Driver Configuration and Database Connection

2.1 Obtain JDBC Driver

Download the JDBC driver that matches your database (e.g., MySQL Connector/J) and copy the JAR file to $JMETER_HOME/lib. Restart JMeter so the driver is loaded.

2.2 JDBC Connection Configuration

Add a JDBC Connection Configuration element to the Test Plan and fill in the required fields:

Variable Name (to Pool): mydb
Database URL: jdbc:mysql://localhost:3306/testdb
JDBC Driver class: com.mysql.cj.jdbc.Driver
Username: db_user
Password: db_password

3. Executing Queries and Asserting Results

3.1 JDBC Request Sampler

Add a JDBC Request sampler, select the connection variable defined above (e.g., mydb), and enter the SQL query, for example:

SELECT * FROM users WHERE id = 1;

3.2 Response Assertion

Attach a Response Assertion to the JDBC Request and configure:

Response Field to Test: Text Response
Pattern Matching Rule: Contains
Pattern: ExpectedValue

3.3 Example

To verify a specific user record, use: SELECT * FROM users WHERE username='testuser'; Then add a response assertion that checks the returned text contains the expected user information, e.g., ExpectedUserInfo.

4. Practical Scenarios

4.1 Concurrent Users with Parameterised Data

Set the Thread Group’s Number of Threads to the desired concurrency (e.g., 20) and Loop Count to 1. Use the CSV Data Set Config to feed a unique ${username} and ${password} to each virtual user.

4.2 Database Validation of API Responses

Execute an HTTP Request sampler, capture its response, then run a JDBC Request to fetch the same data directly from the database. Use a Response Assertion to compare the API response with the database result, ensuring they match.

5. Summary

By combining CSV‑driven multi‑data testing, JDBC driver setup, JDBC Request samplers, and response assertions, JMeter can simulate varied input conditions, verify that API outputs align with the underlying database state, and substantially improve test coverage and reliability.