JMETER-JDBC Request dynamic parameter settings

Important parameter Description:

　　Variable Name: The name of the database connection pool needs to be consistent with the Variable name Bound pool name of the JDBC Connection configuration

Query: Fill in the SQL statement do not add ";"

Parameter values: Parameter value

Parameter types: Parameter types

Variable names: variable name to save SQL statement return result

Result variable Name: Creates an object variable that holds all returned results

Query timeout: Queries Time out

Handle result set: Defines how to handle the results returned by the callable statements statement

Define variables and use variables in SQL query:

1. Define three variables in test plan

2. Reference in SQL query using the ${variable name}:

In SQL query, use the? "As a placeholder and pass parameter values and parameter types, such as:

1, the passed parameter value is a constant, such as passing 3 constants: 10,accountingnew YORK:

2. The parameter value passed is a variable, as in ${dname}:

JMETER-JDBC Request dynamic parameter settings