Mac - Clojure Denodo JDBC driver setup with Maven

0 pre-setup.sh

# Download Denodo JDBC driver from https://community.denodo.com/drivers/jdbc/32

# set JDBC_HOME:
export JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk1.(latest).jdk/Contents/Home

# Download maven from https://maven.apache.org/install.html

# unzip/untar and ls to the /bin folder & execute:

# this will install/create the Denodo driver for the self-created version number based on the jar filename.
./mvn install:install-file -DgroupId=com.denodo -DartifactId=denodojdbc -Dversion=7.0-20190312 -Dpackaging=jar -Dfile="/Users/(user)/Downloads/denodo-vdp-jdbcdriver-7.0-update-20190312.jar" -DgeneratePom=true

1 project.clj

:dependencies [[org.clojure/java.jdbc "0.7.10"]
                 [com.denodo/denodojdbc "7.0-20190312"]]

2 core.clj

(require '[clojure.java.jdbc :as j])

; ssl: turns out that if the server is not configured with SSL, turning it off results in fewer connection timeouts
; queryTimeout: this disables long running query timeouts
(def denodo-db {:dbtype "vdb"
                :dbname "dbname"
                :classname "com.denodo.vdp.jdbc.Driver",
                :host "denodohost"
                :port "9999"
                :user "username"
                :password "password"
                :ssl false
                :queryTimeout 0})

(j/query denodo-db
         ["select * from tablename limit 10"])