Anyone used prestoSQL with clojure JDBC? Doesn’t seem to be supported “out of the box”

Seems like https://github.com/clojure/java.jdbc/blob/0801bc07ce2f01984f6a6bc03504fef73ac02197/src/main/clojure/clojure/java/jdbc.clj#L149-L201 would need additional definitions

I've never heard of it -- but if you have the JDBC driver in your deps, you can just provide :classname with the JDBC driver class name.

{:dbtype "Presto" :dbname "whatever" :classname "com.presto.JDBCDriver" ...} or whatever class name it has.

Oh hello 🙂 thanks I’ll try that

I must be missing something

(j/with-db-connection [conn {:dbtype "jdbc:presto"
                                   :dbname "default"
                                   :classname "com.facebook.presto.jdbc.PrestoDriver"
                                   :user "test"
                                   :password "secret"}]
        conn)
      ;;
      ;; java.sql.SQLException: No suitable driver found for jdbc:jdbc:


      (j/get-connection {:dbtype "jdbc:presto"
                         :dbname "default"
                         :classname "com.facebook.presto.jdbc.PrestoDriver"
                         :user "test"
                         :password "secret"})

      ;; java.sql.SQLException: No suitable driver found for jdbc:jdbc:
      ;; looks like jdbc: is repeated?

(also time for 😴 for me 🙂 )

Remove jdbc: from the :dbtype.

And you made sure you added the Facebook JDBC driver to your dependencies (in project.clj or deps.edn)?

I tried removing jdbc: and still get

Unhandled java.sql.SQLException
   No suitable driver found for jdbc:jdbc:

but maybe I am targeting the wrong class

this did seem right: https://github.com/prestodb/presto/blob/master/presto-jdbc/src/main/java/com/facebook/presto/jdbc/PrestoDriver.java#L35-L36

uh oh - https://github.com/prestodb/presto/blob/master/presto-jdbc/src/main/java/com/facebook/presto/jdbc/PrestoDriver.java#L127-L131

I will try creating a connection directly from presto and pass it to clojure.java.jdbc later