Jmeter: JDBC Test Plan

1) Create a Thread group, Right click on Test Plan > Add> Threads(Users)> Thread Group.

2) Right click on the Test Plan, select Add > Config Element > JDBC Connection Configuration.

Set up the following fields (we are using MySQL database called tutorial):

Variable name bound to pool. This needs to uniquely identify the configuration. It is used by the JDBC Sampler to identify the configuration to be used. We have named it as test

    Database URL: jdbc:mysql://localhost:3306/tutorial

    JDBC Driver class: com.mysql.jdbc.Driver

    Username: root

    Password: password for root


3) Right click on the Test Plan, Select Add > Sampler > JDBC Request.

Variable name bound to pool. This needs to uniquely identify the configuration. It is used by the JDBC Sampler to identify the configuration to be used. We have named it as test

    Name: JDBC Request

    Enter the Pool Name: test (same as in the configuration element)

    Query Type: Select statement

    Enter the SQL Query String field.




4) Right click on the Test Plan,Add > Listener > View Results Tree.

5) Enter any query in the JDBC request and check the response time taken by query.