You can translate the question and the replies:

No suitable driver exception when trying to connect using Jmeter

Hi, When I try to establish a connection in Jmeter I am getting the error exception as "Cannot create JDBC driver of class 'com.denodo.vdp.jdbc.driver for connect URL' and "SQL Exception: No suitable driver found". I have followed this document to setup the configuration https://community.denodo.com/kb/view/document/Denodo%20Load%20Testing%20with%20Apache%20JMeter?category=Performance+%26+Optimization URL: 'jdbc:vdb://denodo-cluster-*****:9999/admin' I have copied the denodo jdbc driver jar into jmeter lib directoy as well but no luck. Please can someone help me to resolve this issue? Thank you, Venkata
user
30-03-2020 10:03:58 -0400
code

3 Answers

Hi I followed the steps provided in the article [Denodo Load Testing with Apache JMeter]( https://community.denodo.com/kb/view/document/Denodo%20Load%20Testing%20with%20Apache%20JMeter?category=Performance+%26+Optimization) and connection to Denodo from JMeter worked successfully for me. I would suggest you to relaunch the JMeter once you place the Denodo JDBC driver in the folder <JMeter>/lib and also verify the specified JDBC URL. Hope this helps!
Denodo Team
31-03-2020 07:47:41 -0400
code
The reason you got this error is because you forgot to register your [java mysql](http://net-informations.com/java/pr/mysql.htm) jdbc driver with the application. Should be like this: `Class.forName("com.mysql.jdbc.Driver");` This forces the driver to register itself, so that Java knows how to handle those database connection strings. You'll have to read the manual on your specific mysql jdbc driver to find the exact string to place inside the the Class.forName("...") parameter.
user
21-06-2021 03:13:37 -0400
Hi, When I am trying to connect Virtual DataPort server using a Java class through a JDBC connection, I would define the driver class and connection URL as below: ``` Class.forName("com.denodo.vdp.jdbc.Driver"); connection = DriverManager.getConnection(<database url>,<user>,<password>); ``` In order to establish connection from *Apache Jmeter* to Virtual DataPort server, I would ensure the following: * Load Denodo JDBC driver *denodo-vdp-jdbcdriver.jar* from <DENODO_HOME>/tools/client-drivers/jdbc/ directory in the JMeter classpath <JMeter>/lib. * Specify the database URL : `jdbc:vdb://<virtual dataport server host>:<virtual dataport server port>/<database>?chunkSize =<value>` * Specify JDBC Driver class as 'com.denodo.vdp.jdbc.Driver'. Hope this helps!
Denodo Team
30-06-2021 07:30:44 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here