Connect to CommitCRM via JDBC

[Lampson_sec]

I am trying to connect to the CommitCRM DB using a JDBC connection.

The Advantage JDBC driver is loading properly, because in the error message I'm getting a login failure.

When connecting via ODBC (from SQL Server for example) There is no username, as we use file share/permissions and not a username. Any idea on how to make this work?

I'm using Neo4J to connect, here's my query example:
CALL apoc.load.driver("com.extendedsystems.jdbc.advanta ge.ADSDriver")
call apoc.load.jdbc('jdbc:extendedsystems:advantage://commitcrm:6262;catalog=//CommitCRM/Db;','select * from BContracts') YIELD row
return row

And here's the error message being returned:
Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure `apoc.load.jdbc`: Caused by: com.extendedsystems.jdbc.advantage.ADSException: [iAnywhere Solutions][Advantage JDBC]Login failed.

Any help would be appreciated!

[Support Team]

Re: Connect to RangerMSP via JDBC

Thank you for posting this.
Nope, no idea here and JDBC is not something that we are familiar with, unlike ODBC.
In any case, if you can share more about the different connections settings you have maybe we will be able to detect something that isn't configured correctly. Hope this helps.