cancel
Showing results for 
Search instead for 
Did you mean: 

trying to load query from jdbc:sqlserver with apoc

eylenth
Node

Dear

I'm trying to execute the following query in the neo4j prompt with the apoc jdbc driver

CALL apoc.load.jdbc('jdbc:sqlserver://FQDN;databaseName=PRISMDB_Q_SNAPSHOT;user=ruser;password=notvisible',
'select distinct ped_id PED_ID, c_uid UID
from SEED_TRANSFER where 1=2') YIELD row create (n:TransferBook {PrismID:row.PED_ID, UID:row.UID})

 But I'm getting the following error message:

Failed to invoke procedure `apoc.load.jdbc`: Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
 
could this a a SSL certification issue on the target server? or is there something misconfigured on client side on the neo4j server?
 
2 REPLIES 2

Do you use custom ssl certificates for the server? If so you might need to import them into the ssl keystore for the neo4j JVM.

https://www.baeldung.com/java-import-cer-certificate-into-keystore

It is working with the following paramater in the oracle query:

trustServerCertificate=true

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.