marklogic-community / ml-jdbc-driver

Making JDBC connections to MarkLogic SQL/ODBC Server
Other
3 stars 4 forks source link

How to connect using prestoDB/Trino #30

Open baddev89 opened 10 months ago

baddev89 commented 10 months ago

The readme indicates a successful connect can be made to MarkLogic using Trino/PrestoDB query engine.

Can an example catalog properties file be provide to demonstrate how to connect from Trino/Presto to MarkLogic?

With this properties file: connector.name=postgresql connection-url=jdbc:postgresql://marklogic:8077/ connection-user=admin connection-password=admin

get this error: Query 20240109_055918_00000_cg8q3 failed: org.postgresql.util.PSQLException: The connection attempt failed.

I also get the same error using Squirrel and the linked postgres driver. With the MarkLogic driver, Squirrel works. I don't see a way to set the driver class for PrestoDB/Trino connector.

Thank you.