Insert aggregate jtl result in database after execution of jmeter script on slaves is completed

Question

I am running jmeter in master-slave mode and getting the result in jtl file. I can get aggregate jtl result using command "java -jar CMDRunner.jar --tool Reporter --generate-csv test.csv \ --input-jtl results.jtl --plugin-type ResponseTimesOverTime" and then can write custom script to insert this data in the database.

Can all these activities happen in one jmeter script?

Answer 1

You can add tearDown Thread Group containing:

• OS Process Sampler - to execute this CMDRunner.jar
• JDBC Request Sampler or PostProcessor to insert the file into the database.

You may have to add jmeter.save.saveservice.autoflush=true line to user.properties file of your JMeter installation as JMeter doesn't write results in the real time. Or add a Timer to sleep for a while till results are written to .jtl file.