Trying to load query from jdbc:sqlserver with apoc

Drivers & Stacks
1

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

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

3

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

trustServerCertificate=true

1 Like