sql - Adding a single query result into JMeter report -

i have jmeter plan starts single jdbc sampler query captures session id teradata database (select session;). same plan has large number of jdbc samplers complicated queries producing large output don't want include in report.

if configure summary report , tick save response data (xml) output all sampler queries saved

how add first query result (it's single integer) test summary report , ignore results other queries? example there way set responsedata = false after first query output captured?

maybe sample_variables property can help?

1. define in "variable names" section of jdbc request, i.e. put session reference name there like:

   

2. add next line user.properties file (lives in jmeter's "bin" folder)

   sample_variables=session_1 

   or alternatively pass via -j command-line argument like:

   jmeter -jsample_variables=session_1 -n -t /path/to/testplan.jmx -l /path/to/results.csv 

   you need use session_1 not session. per jdbc request sampler documentation:

   if variable names list provided, each row returned select statement, variables set value of corresponding column (if variable name provided), , count of rows set up. example, if select statement returns 2 rows of 3 columns, , variable list a,,c, following variables set up:

   a_#=2 (number of rows)

   a_1=column 1, row 1

   a_2=column 1, row 2

   c_#=2 (number of rows)

   c_1=column 3, row 1

   c_2=column 3, row 2

   so given query returns 1 row containing 1 integer - live in session_1 jmeter variable. see debugging jdbc sampler results in jmeter article comprehensive information on working database query results in jmeter.

3. when test completes you'll see column in .jtl results file holding "session" value: