I am trying to connect to Denodo server from Azure Databricks using spark read api for jdbc like:
url = "jdbc:vdb://%s:%s/%s" % (server, port, vdb)
remote_table = (spark.read
I am using the driver: driver = "com.denodo.vdp.jdbc.Driver" from denodo_vdp_jdbcdriver_8_0_0_20220815.jar
But getting the following error:
java.sql.SQLException: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version.
The same connection is successful when using dbdriver.connect on the same notebook.
But I want to use spark to read. Can you please help me in solving this error?