Hi!
Can't use this function because it's missing
Do I have to install additional drivers? Which one should I use and how?
The official site has an example of connecting to MySQL, but I didn't get the whole image
Thank u for any info!
The APOC JDBC procedures have been moved to APOC Extended, which is packaged separately from APOC Core. Be sure you've installed APOC Extended to use the APOC JDBC procedures: Installation - APOC Extended Documentation
Thank you for your reply!
But I still don't get everything
I don't see anything about MySQL, that is given as an example
And my aim is Clickhouse. Is there a solution for ClickHouse at all?
Right now I'm trying to download "extended" for a given DB Movies (in my case its version Version 5.3.0)
And this table showing compatibility, seems to be out of date
I tried to download the last version (5.1.0), but adding this .jar to /plugins is throwing an error "DBMS failed to start"
Ow sorry may fault - there was a newer extended jar - 5.3
I got now load.driver and "apoc.load.jdbc" - Hooray!)
But next question is still on
On the official page they use this:
CALL apoc.load.driver("com.mysql.jdbc.Driver");
Where do they get this - com.mysql.jdbc.Driver
And the driver itself
For example, if we consider Clickhouse again, what should I do now?
Really apologize if questions are dumb, but that's taking too much time and no results in my case
For Clickhouse you'll want to use the Clickhouse JDBC driver, looks like this is the official one: GitHub - ClickHouse/clickhouse-java: Java client and JDBC driver for ClickHouse
Then loading the JDBC driver in apoc would be:
CALL apoc.load.driver("com.clickhouse.jdbc.ClickHouseDriver")
(per the Clickhouse docs here)
Thank you again very much!)
That worked for me
1 Like