I'm doing some load test on an MS SQL Database using JMeter. I'm able to connect and read a specific record using a JDBC Request. I would like to insert in my Table 100 records having the same fields data taken from this specific record but changing only one field (the primary key).


You can use Variable Names or Result Variable Name parameters of the JDBC Request sampler to store your query result into JMeter Variables

enter image description here

Once done you should be able to replace the "old" primary key value with a new one using JSR223 Test Elements and Groovy language and construct the request back.

We are not able to provide comprehensive instructions/code without seeing your SQL query output, in the meantime check out Debugging JDBC Sampler Results in JMeter article to get initial understanding on working with the JDBC-originated variables and results sets.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.