I have working JDBC connection to data bricks server in Java code.
I'm trying to make similar connection in my JMeter project (tried with apache-jmeter-5.3 and apache-jmeter-5.4.3) using same connection details.
I put SparkJDBC42.jar in JMeter lib (downloaded from https://databricks.com/spark/jdbc-drivers-download).
To connect I've used
In Database Url using
- using UID and PWD inside Url
- using UID and PWD in Username and Password fields
- using UID and PWD in Connection Properties.
No matter what I do, I keep getting error:
"Response message:java.sql.SQLException: Cannot create JDBC driver of class 'com.simba.spark.jdbc.Driver' for connect URL ..."
I followed instructions from this post last response: https://stackoverflow.com/questions/66913893/how-can-i-connect-jmeter-with-databricks-spark-cluster
What can be the issue?