APOC load.jdbc - how to make it works?

[Gosforth]

I'd like to connect to MySQL using jdbc driver. Just like in this example: Load JDBC (RDBMS) - APOC 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: Neo4j JDBC driver for Neo4j 3.x and 4.x with BOLT protocol</tit 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,

[andreperez]

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.

[Gosforth]

andreperez:

dbms.security.procedures.unrestricted=apoc.*

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

[Gosforth]

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

[dana_canzano · Accepted solution]

@Gosforth

Per https://neo4j.com/labs/apoc/4.3/overview/ 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

[Gosforth]

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

Thank you very much for help!