Clojure Postgresql Drivers not found

Question

I'm at that point where frustration just makes you incapable of seeing the solution...

My project.clj

:dependencies [[org.clojure/clojure "1.8.0"]                                                                                                                                                           
               [org.clojure/java.jdbc "0.4.2"]                                                                                                                                                         
               [org.postgresql/postgresql "9.4.1208"]]

Run lein deps (all is okay)
Run my query:

(db/query "postgresql://user:secret@host"
["select * from table limit 1"])

I get the following error:

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

...Please. Any ideas?

just including the libraries in your dependency doesn't configure your connection to the database. you have to specify that specifically, typically in the :classname value of the connection map. — Mark Fisher
– Mark Fisher, Commented Mar 1, 2016 at 10:58

Nicolas Modrzyk · Accepted Answer · 2016-03-01 09:21:16Z

2

Probably need to specify the java driver to use and the other parameters in the db descriptor.

I usually use something similar to:

(use 'clojure.java.jdbc)

(let [db { :classname "org.postgresql.Driver"
           :subprotocol "postgresql"
           :subname "//192.168.99.100:5432/postgres"
           :user "postgres"
           :password "mysecretpassword"}]
       (query db ["select count(*) from example" ]) )

 ; ({:count 6005247})

edited Mar 1, 2016 at 9:21

answered Mar 1, 2016 at 9:15

Nicolas Modrzyk

14.2k2 gold badges39 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

number23_cn · Accepted Answer · 2016-03-02 02:08:06Z

0

maybe your db spec is wrong, I use postgresql spec:

postgres://user:password@host:5432/mydb

answered Mar 2, 2016 at 2:08

number23_cn

4,64929 silver badges31 bronze badges

Collectives™ on Stack Overflow

Clojure Postgresql Drivers not found

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related