You can translate the question and the replies:

Error in connecting to Denodo from Databricks

Hi Team, 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 .format("jdbc") .option("driver", driver) .option("url", url) .option("dbtable", table) .option("user", user) .option("password", password) .load() ) 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?
Driver databricks Azure databricks Azure Denodo vdp jdbc driver JDBC
user
27-02-2023 08:17:38 -0500
code

1 Answer

Hi, The 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 means the JDBC driver, in your case denodo_vdp_jdbcdriver_8_0_0_20220815.jar, could be incompatible with the Denodo Platform which should also be 8.0 (20220815). Additionally, I would assume that dbdriver.connect is using an ODBC, normally on port 9996, but the default port for a JDBC connection is 9999. You should confirm that you’re using the right port and it is not blocked by a firewall or used by any other application. Please refer to the [Access Through JDBC](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/access_through_jdbc/access_through_jdbc) document in the Virtual DataPort Developer Guide and the [How to connect to Denodo from Python - a starter for Data Scientists](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20Python%20-%20a%20starter%20for%20Data%20Scientists) Knowledge Base article for more information. You should refer to the previously answered community question [here](https://community.denodo.com/answers/question/details?questionId=9064u000000H9uCAAS&title=Connectivity+Issue+with+Denodo+v8+jdbc+driver+api). In case you need further assistance and if you have a valid Support Account then you can reach out to Denodo Support by raising a support case on [Denodo Support Site](https://support.denodo.com/MainPage.do) and the Support Team will assist you. Hope this helps!
Denodo Team
28-02-2023 14:25:41 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here