jMeter - Database Test Plan

Advertisements


In this chapter we will see how to create a simple test plan to test the database server. For our test purpose we have used the MYSQL database server. You can use any other database for testing. For installation and table creation in MYSQ please refer MYSQL Tutorial.

Once MYSQL is installed, follow the steps below to setup the database:

  • Create a database with name "tutorial".

  • Create a table tutorials_tbl.

  • Insert records into tutorials_tbl :

    mysql> use TUTORIALS;
    Database changed
    mysql> INSERT INTO tutorials_tbl 
         ->(tutorial_title, tutorial_author, submission_date)
         ->VALUES
         ->("Learn PHP", "John Poul", NOW());
    Query OK, 1 row affected (0.01 sec)
    mysql> INSERT INTO tutorials_tbl
         ->(tutorial_title, tutorial_author, submission_date)
         ->VALUES
         ->("Learn MySQL", "Abdul S", NOW());
    Query OK, 1 row affected (0.01 sec)
    mysql> INSERT INTO tutorials_tbl
         ->(tutorial_title, tutorial_author, submission_date)
         ->VALUES
         ->("JAVA Tutorial", "Sanjay", '2007-05-06');
    Query OK, 1 row affected (0.01 sec)
    mysql>
    
  • Copy the appropriate JDBC driver to /home/manisha/apache-jmeter-2.9/lib.

Create JMeter Test Plan

First let's start the JMeter from /home/manisha/apache-jmeter-2.9/bin/jmeter.sh.

Add Users

Now create a Thread group, right click on Test Plan > Add> Threads(Users)> Thread Group. Thread Group will get added under the Test Plan node. Rename this Thread Group as JDBC Users.

Thread Group Added

We will not change the default properties of the Thread Group.

Adding JDBC Requests

Now that we have defined our users, it is time to define the tasks that they will be performing. In this section, you will specify the JDBC requests to perform. Right click on the JDBC Users element, 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

The other fields on the screen can be left as the defaults as shown below:

JDBC Configuration Pool

Now add a JDBC Request which refers to the JDBC Configuration pool defined above. Select JDBC Users element, click your right mouse button to get the Add menu, and then select Add > Sampler > JDBC Request. Then, select this new element to view its Control Panel. Edit the properties as below:

  • 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: Learn

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

  • Query Type: Select statement

  • Enter the SQL Query String field.

JDBC Request

Create Listener

Now add the Listener element. This element is responsible for storing all of the results of your JDBC requests in a file and presenting a visual model of the data.

Select the JDBC Users element and add a View Results Tree listener (Add > Listener > View Results Tree).

JDBC Test Listener

Save and Execute Test Plan

Now save the above test plan as db_test.jmx. Execute this test plan using Run > Start option.

Verify Output

JDBC Test Output JDBC Test Output JDBC Test Output

In the last image you can see that 2 records are selected.



Advertisements
Advertisements