I’m currently trying to set up the Database connection between our Clickhouse DB and KNIME but I am unfortunately not able to register the driver via KNIME.
I’ve downloaded the JAR and when registering the driver I can’t click on OK as it’s greyed out.
I am also not able to select a driver class or use the “find the driver class” as it shows as empty.
I’ve not used it, but I did try download clickhouse jdbc 0.3.1 to test this. It was packaged up in a jar_files.zip file. I extracted the files to a folder which I left as “jar_files”.
I then proceeded to do the same as you and try to add the jdbc jar file. Same result as you.
I don’t know the answer to this, but I’ve seen mentions for other databases of adding to the end of the database url, the following, or maybe Clickhouse has something similar:
?useSSL=true&requireSSL=true
(the intial ? might be an & instead, if there are already other parameters on the url).
Thanks @ipazin ! That worked.
Unfortunately now I am receiving the next error : Error 159 (Read Timeout) for the DB - is there a way I can increase the timeout time ?
Assuming that you can get some queries to work without timing out, I’d probably use a working query to test it. Find something that takes maybe 5 seconds to return, and set the value to something really low (zero maybe) and see if it then fails. At least this might give a clue if the parameter is having any effect. If it does, then try setting it really high so that your failing query starts to work.
I’m guessing at the parameter name (based on the stack overflow comment)
By the way, the defaults mentioned on Stack Overflow are according to some 30 seconds, and according to others 300 seconds. I assume the setting is in milliseconds, so the screenshot would set to 300 seconds, or 5 minutes.
I’m getting the timeout after probably 15-30 seconds. To be honest I didn’t really stop the time till now
The connection per se is definitely working as there are indeed smaller tables that are accessible to me. So I hope setting up the timeout works. (It worked in DBeaver at least)
Thanks for your help again! And let’s hope this is going to work. I have to say - I really don’t like Clickhouse haha.
Any custom JDBC connection parameter can be defined under above mentioned JDBC Parameters tab. You just need to write correct parameter name and value which depends on database and driver version you are using. From experience it’s best to have driver documentation close by