Hi, I need to connect to the clickhouse database. I looked in the web and community that I need to add the driver in the database and use db connector node. I have downloaded couple of drivers (0.8.1 & 0.8.2
) from maven. After I added this in the database driver page when I click on the find driver class, the driver is not recognized. Not sure what to do. Please advise
Here is the link: Central Repository: com/clickhouse/clickhouse-jdbc/0.8.1
takbb
March 29, 2025, 4:37pm
2
Hi @Braveen ,
Have you seen these two posts on the forum, especially the first one which discusses the problem you have, I think.
Hi @Chaosprinzip
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.
[image]
So I then removed that jar again from the dialog, and added the folder using Add directory, and then clicked Find driver classes…
[image]
Does that get you any further?
Actually, I found it in a maven repository. I downloaded the jar using the following maven command line into a local repository created for the purpose: “c:\maven-down\download”
mvn -Dmaven.repo.local=c:/maven-down/download dependency:get -DremoteRepositories=http://repo1.maven.org/maven2/ -DgroupId=com.github.housepower -DartifactId=clickhouse-native-jdbc -Dversion=2.4.3
Once that was done, I searched in my c:\maven-down\download folder for “clickhouse” and found the driver jar file here:
C…
If you read around those, and the other parts on those threads it will hopefully assist.
2 Likes
