
Set Loop count to the number of times the provided test should be executed sequentially by each user.
Set Number of Threads (users) to the number of users which should test the database concurrently.
Thread Group: used for defining the workload for each user. Set Username to sa and let the Password empty Other connection string options can be found in the official H2 documentation. For using a not in-memory database, use file instead of mem (example: jdbc:h2:file:~/.h2/fwd.h2 ). For using private databases for each user, omit the name of the database (example: jdbc:h2:mem: ). In order to change to the MVStore engine, set the mv_store flag to true. Set the Database URL to the connection string used by FWD (example: jdbc:h2:mem:_temp db_close_delay=-1 mv_store=false query_cache_size=1024 ). Set the Auto Commit and Transaction Isolation to the reflect testcase's approach JDBC Connection Configuration: used for defining the connection parameters. This will generate a test plan containing: In order to create an appropriate test plan, a default template can be used ( File > Templates. For the examples below, the 5.3 version was used. Also recommended is to increase the Java memory limit by editing apache-jmeter-*/bin/jmeter. Apache jmeter ojdbc jar driver#
A H2 JAR should be added to apache-jmeter-*/lib/ in order to be able to use an org.h2.Driver JDBC Driver class. By default, JMeter does not contain any H2 driver. Performance Testing the H2 Database ¶ Apache JMeter for H2 profiling ¶Īpache JMeter is a powerful tool for profiling any database through a JDBC connection ( ).