Apoc.load.jdbc problem querying advantage database

apoc

(Paul Drangeid) #1

Problem is LIKELY the quite old implementation that SAP is using in their jdbc driver, but unfortunately I think I'm stuck with it.

Using Advantage JDBC Driver 11.1

driver loads ok, and I am querying the database, but I suspect APOC is using a much newer JAVA method than this old JDBC driver supports. Following is my query attempt and the resulting error message:

CALL apoc.load.driver("com.extendedsystems.jdbc.advantage.ADSDriver")
call apoc.load.jdbc('jdbc:extendedsystems:advantage://commitcrm:6262;catalog=//commitcrm.mysite.com/CommitCRM/Db','SELECT source FROM Tickets WHERE source is not null') YIELD row
return row

Neo.ClientError.Procedure.ProcedureCallFailed

Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure apoc.load.jdbc: Caused by: java.lang.AbstractMethodError: Method com/extendedsystems/jdbc/advantage/ADSResultSet.isClosed()Z is abstract

Any suggestions, or am I stuck because of this legacy JDBC driver?


(Michael Hunger) #2

Hmm seems this JDBC driver doesn't implement some APIs.
A little bit hard to fix but I can have a look.

Can you test this one? https://www.dropbox.com/s/ebyuwwn3dhesufq/apoc-3.4.0.3-test-jdbc.jar?dl=0


(Paul Drangeid) #3

That did the trick!

I can do some further testing... This will allow me to do realtime queries to that platform without waiting for our nightly exports into our SQL database.

Thank you.