BlazeMeter supports testing of different Database. Please refer below section for details configuration to perform DB load testing.
IMPORTANT: While Blazemeter supports uploading your JDBC driver to a test, it does not support uploading the driver to a shared folder at this time. To ensure the driver/JAR is picked up, upload it to the main test configuration, not a shared folder.
Using Oracle JDBC Driver
If you want to use BlazeMeter to test an Oracle database, you will probably need to have a JAR file that includes the required drivers (e.g. ojdbc14.jar). To use this JAR file in BlazeMeter you should simply upload it to your test storage folder along with the JMX. This JAR file will be moved to $(JMETER-HOME)/lib/ directory before the test starts.
Keep in mind that if you forget to upload this file, you will see exceptions such as:
WARN - jmeter.protocol.jdbc.config.DataSourceElement: Could not load driver: oracle.jdbc.driver.OracleDriver java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver.
Another thing to keep in mind is that any JAR file that doesn't have the ojdbc*.jar template will be considered as a JMeter plugin and will be moved to the $(JMETER-HOME)/lib/ext/ folder instead
Additional information can be found here.
Using MSSQL JDBC Driver
If you want to use BlazeMeter to test an MSSQL database, you will probably need to have a JAR file that includes the required drivers (e.g. sqljdbc*.jar or jtds-*.jar). To use this JAR file in BlazeMeter you should simply upload it to your test storage place using the Files tab. This JAR file will be moved to $(JMETER-HOME)/lib/ directory before the test starts.
If you forgot to upload this file, you will see this type of exceptions:
WARN - jmeter.protocol.jdbc.config.DataSourceElement: Could not load driver: oracle.jdbc.driver.OracleDriver java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver.
Another thing to keep in mind is that any JAR file that doesn't have the sqljdbc*.jar or jtds*.jar template will be considered as a JMeter plugin and will be moved to the $(JMETER-HOME)/lib/ext/ folder instead.
Additional information can be found on the official Apache JMeter site.
Using MySQL JDBC Driver
BlazeMeter supports MySql as the relevant JDBC drivers are already installed in$(JMETER-HOME)/lib/.
You can directly upload database test plan, configure and execute it.
Additional information can be found here.
Want to learn more? Read our blog post, Debugging JDBC Sampler Results in JMeter
0 Comments