JMeter SQL launcher (jmeter_sql.jar)

The JMeter SQL launcher allows running load testings on MySQL and MSSQL databases.
It has been tested with JMeter v2.4.

Configuration

The jmeter_sql.xml file is just a template and must NOT be edited. It's used by the system to build dynamically the form that the user will be able to fill in from the GUI when creating a custom execution configuration.

Parameter	Description
General
Java install path	This must indicate the path to the java install. Default value is: `C:/Program Files/Java/jdk1.6.0_17`
Test root path	This must indicate where are located all the JMeter tests. This is a root path. Each test in XStudio has a canonical path that will be appended to this path. This path MUST not include an ending slash. Default value is: `C:/test_repository/tests/jmeter`
Request timeout (seconds)	This must indicate the request timeout value. Default value is: `30`
Acceptable failure rate (%)	This must indicate the acceptable failre rate. Default value is: `0`
Nb simulated users	This must indicate the number of simulated users. Default value is: `100`
Time to reach max load (seconds)	This must indicate the time to reach the max load. Default value is: `60`
Nb requests per user	This must indicate the number of request sent per user. Default value is: `3`
Nb values to compute max time	This must indicate the number of values measured to calculate the request max time. By default, the declared max time will be the average of the 3 biggest times. Default value is: `3`
JMeter
JMeter install directory	This must indicate where JMeter has been installed. Default value is: `C:/jakarta-jmeter-2.4`
Temporary folder	This must indicate the path of a folder where we are going to store temporary data. Default value is: `C:/WINDOWS/Temp`
Database
Server type	This must indicate which kind of database server we are going to test. This can take the values MySQL or MSSQL. Default value is: `MySQL`
Server name	This must indicate the server name. Default value is: `localhost`
Port	This must indicate the port used to connect to the server. Default value is: `3306`
Database name	This must indicate the database name. Default value is: `xstudio_db_previous`
User name	This must indicate the username to connect. Default value is: `xstudio`
Password	This must indicate the password to connect. Default value is: `xstuiopwd`

These values can be changed while creating the campaign session from XStudio.

Note about file path parameters:
Any parameter referring to a file or folder path (for instance Test root path) can be provided either using \ separator (if the tests are going to be executed on a Windows agent) or / separator (if the tests are going to be executed on a linux or MacOSX agent).

On windows, if you provide a path containing an OS-localizable folder such as C:\Program Files, always prefer the English version (i.e. NOT C:\Programmes if you're using a french-localized Windows) or the corresponding native environment variable (i.e. %PROGRAMFILES%).

Process

The launcher will first take care about running the JMeter server. Do NOT run the server by yourself.
The tests must be named with the extension .sql and contain simple SQL requests separated by ;.

For instance:


	SELECT * FROM table_user;

	SELECT user_id FROM table_user WHERE user_name='admin';

IMPORTANT: the JMeter launcher expects to get results in a .jtl file formatted in XML (and not CSV that is the default value but that contains less information).
You can ensure JMeter generates .jtl formatted in XML by checking in the bin/jmeter.properties file that the following property is present:
jmeter.save.saveservice.output_format=xml

The JMX tests are generated dynamically from these tests and executed by the launcher.
At the end of the test execution, a chart is generated by the launcher based on the JTL results produced by JMeter and uploaded to XStudio. All the logs are also attached to the testcase execution in XStudio. The test will be marked as passed or failed depending on the failure rate measured by JMeter.

Tutorial: Creating and executing JMeter SQL tests

In this tutorial, we will learn to run some JMeter load tests.

Prerequisites

Install JMeter in the folder C:\\jakarta-jmeter-2.4
Create a file Test2.sql in the folder C:\\test_repository\\tests\\jmeter\\folder1.
Open this file and copy the following in it:


	SELECT * FROM table_user;

	SELECT user_id FROM table_user WHERE user_name='admin';

Create a dedicated category for JMeter SQL tests and create a test

create a category JMeter SQL associated to the launcher jmeter_sql.jar
under this category, create (somewhere in the tree) a test with name Test2 and with a canonical path set to folder1.

Creating a test campaign

create a campaign including only the test Test2
create a campaign session using a configuration having all the default values.

Run a campaign session

Run the campaign session
After the session's execution is completed, you can look at the results from XStudio:

the messages indicate the failure rate and the average time to execute the queries
you can also check that all the log files (including the JMX, the JTL and the log files) are attached as well as a chart which looks like:

jmeter sql

Permissions

WARNING: if you're running your tests on Windows, it may be required to run the tests as administrator.
Having an account with Administrators permissions may even not be enough in some cases (especially if you're using Windows 10) and you may need to disable completely the UAC (User Access Control) on your computer.
To do so:

Press the Windows + R key combination
Type in regedit
Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
In the right-side pane, look for EnableLUA and set the value 0
Close the registry editor
Restart your computer

Debug

If your tests are not executed correctly or are reporting only failures, this is very likely because your configuration is incorrect or because you used a wrong naming convention for your tests and test cases.

The best way to quickly find out what's wrong is to look at the traces generated by XStudio (or XAgent).
The traces always include the detailed description of what the launcher performs (command line execution, script execution, API calling etc.) to run a test case. So, if you experiment some problems, the first thing to do is to activate the traces and look at what's happening when you run your tests.

Then, try to execute manually in a cmd box the exact same commands.
This will normally fail the same way.
At this point, you needs to figure out what has to be changed in these commands in order to have them run properly.

When you have something working, compare these commands to what's described in the Process chapter above. This will tell you exactly what you need to change.

Most of the time, this is related to:

some incorrect values in some parameters of your configuration,
the name of your tests,
the name of your test cases,
the canonical path of your tests

Launchers / Automated tests