Issue on Performance testing of H2 database using Jmeter JDBC requests

0
votes

Facing some issue while running the performance testing of H2 database for a corda project.

JDBC requests in Jmeter is used for this testing . some screenshots of Jmeter is given.

jdbc connection issue

jdbc reruest

result

1
jdbcjmeterperformance-testingh2corda
I hope you're not planning to go to production with H2; this database is just for development and local testing; you can instead use PostgreSQL with Corda Open Source. – Adel Rustum
docs.corda.net/docs/corda-os/4.4/node-database.html – Adel Rustum

1 Answers

1
votes

Your question doesn't provide any error details therefore we cannot come up with the comprehensive solution, going forward make sure to include the screenshot or text of the "Sampler Result" tab of the View Results Tree listener and at least the relevant part(s) of the jmeter.log file into your question.

The most possible reason is using the wrong validation query, what you supplied is for Oracle DB, for H2 you should be using just Select 1

Also make sure to put the H2 JDBC Driver to JMeter Classpath and restart JMeter to pick up the .jar

Check out The Real Secret to Building a Database Test Plan With JMeter article for more information on the database load testing using JMeter.

P.S. Be informed that having JMeter and the application under test on the same machine is some form of a performance-testing anti-pattern as both are very resource intensive and in case of CPU/RAM/whatever lack you won't get reliable results.