Configure the JMeter JDBC PreProcessor pre processors: properties, defaults, and practical usage notes for building reliable load tests.
Part of the Pre Processors category. Also documented in context in the full Component Reference.
The JDBC PreProcessor enables you to run some SQL statement just before a sample runs. This can be useful if your JDBC Sample requires some data to be in DataBase and you cannot compute this in a setup Thread group. For details, see JDBC Request.
See the following Test plan:
In the linked test plan, “Create Price Cut-Off” JDBC PreProcessor calls a stored procedure to create a Price Cut-Off in Database,
this one will be used by “Calculate Price cut off”.
Create Price Cut-Off Preprocessor