Setup

Setup

First Setup an ODBC application server in MarkLogic.

Then Download:

MarkLogic JDBC 4.2 Driver, 42.1.4

https://github.com/marklogic-community/ml-jdbc-driver/blob/master/jar/mljdbc-42.1.4.jar

or

PostgreSQL JDBC 4.2 Driver, 42.1.4

https://jdbc.postgresql.org/download/postgresql-42.1.4.jar

Be sure to use the specific driver version. Be sure to include the jar in your classpath.

Next Configure the connection driver name (aka Class.forName) and the connection string URL: jdbc:<vendor>://<host>:<port>/

Driver Name: "com.marklogic.Driver"
Driver URL: "jdbc:marklogic://localhost:8077/"

or

Driver Name: "org.postgresql.Driver"
Driver URL: "jdbc:postgresql://localhost:8077/?preferQueryMode=simple"