APOC load.jdbc - how to make it works?

Neo4j Graph Platform
1

I'd like to connect to MySQL using jdbc driver. Just like in this example: Load JDBC (RDBMS) - APOC Extended Documentation

  1. I move apoc apoc-4.3.0.0-core.jar file to 'plugins'
  2. I put jdbc connector GitHub - neo4j-contrib/neo4j-jdbc: JDBC driver for Neo4j or MySQL official one in 'plugins'.
  3. I run 'CALL apoc.load.driver("com.mysql.jdbc.Driver");'
    The result is "There is no procedure with the name apoc.load.driver registered for this database instance. Please ensure you've spelled the procedure name correctly and that the procedure is properly deployed."

Executing 'call apoc.help("jdbc")' returns nothing.

So, what should I do? I followed exactly instruction.
Regards,

2

Hi Gosforth, check if the apoc library is listed as unrestricted or whitelisted on your config file (I'd recommend to also insert gds.* library to avoid future errors like this in case you use GDS library):

dbms.security.procedures.unrestricted=apoc.*

This link will provide more information.

3

Thank you. But I have it already in my config.

4

Anyone? JDBC is working here or that was the past?

5

@Gosforth

Per Procedures & Functions - APOC Extended Documentation apoc.load.jdbc is part of APOC Full and not APOC Core, whereby Core is a subset of Full. If you install the apoc.4.3.0.0-all.jar Release 4.3.0.0 · neo4j-contrib/neo4j-apoc-procedures · GitHub then you should then see apoc.load.jdbc

6

Yes, way better now :slight_smile:
Now evident but before I did not spot that APOC that comes with installation is 'core'.

Thank you very much for help!