Follow

How to use Different JDBC Drivers

BlazeMeter supports testing of different Database. Please refer below section for details configuration to perform DB load testing.

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 alonf 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

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.