The JDBC Request sampler

Sometimes, it's necessary to test durability and I/O operations against the database directly. How fast are inserts, updates, and selects on the tables in question? For such tests, JMeter provides a JDBC Request sampler to help issue SQL queries against the database. However, to use it, we need to set up a JDBC Connection Configuration component. Setting up this component requires us to point to a database. So let's go ahead and set up the database. Normally, this will already be set up for you to test against, but for illustrative purposes, we are going to assume none has been set up. We will be using H2, an open source pure Java SQL database. It is lightweight and relatively easy to set up.

Setting up an H2 database

1. Download a distribution at .

2. Extract the archive to a location of your choosing. We will refer to this as H2_HOME.

3. From the command line, go to the H2_HOME/bin folder.

4. Start the H2 database server by issuing either of these commands.

   • On Unix:

     ./h2.sh
     

   • On Windows...