this finally worked:

(let [url  "jdbc:"
        stmt (-> (DriverManager/getConnection url)
                 (.createStatement)
                 (.executeQuery "select * from users"))]
    (while (.next stmt)
      (println (.getString stmt "name"))))

[org.postgresql/postgresql "42.0.0.jre7"]
[org.clojure/java.jdbc "0.4.2" :exclusions [org.postgresql]]

Are you really using 0.4.2 of java.jdbc??? That's ancient!

And it shouldn't pull in any JDBC drivers so you should not need an exclusion.

The current version is [org.clojure/java.jdbc "0.7.5"] @inbox

🙈

this is my first clojure project and now I see is a legacy one 😄

I'll see if I can update it and test again 🙂

The java.jdbc API has changed pretty radically since 0.4.2...

"Release 0.4.2 on 2015-09-15" <--

haha ok

oh crap, yeah that is old 😄

No wonder some of what I was suggesting you try didn't actually work 🙂

BTW @inbox I'm surprised your :exclusions does anything if it's written as you showed -- org.postgresql isn't an artifact ID (maybe that excludes every artifact in that group? Seems unlikely).

@seancorfield yeah, isn't doing anything, because I just tried this code:

(jdbc/with-db-connection [con-spec {:dbtype "postgresql"
                                      :dbname "roc_test"
                                      :user "roc"
                                      :password "roc"
                                      :currentSchema "ns1"}]
    (jdbc/query con-spec ["SELECT * FROM users"]))

[org.postgresql/postgresql "42.0.0.jre7"]
[org.clojure/java.jdbc "0.7.5"]

my project also has this dependency: https://github.com/juxt/modular/blob/master/modules/postgres/project.clj#L9 that might bes the driver I'm using by default that doesn't support the currentSchema

java.jdbc deliberately does not pull in any JDBC drivers -- you have to do that yourself (so you have full control over which one(s) you use).

Per https://github.com/clojure/java.jdbc/blob/master/project.clj#L27-L28 those are just the driver versions I test against locally.

oh, ok, that I was looking at, hence my idea of the driver dep

(the impossibl driver was a fairly recent addition in the test matrix)

For Contrib projects, project.clj is not relevant -- it doesn't affect how the project is built.

If you look in pom.xml (which is how Contrib projects are built) https://github.com/clojure/java.jdbc/blob/master/pom.xml#L90 you'll see all the drivers are marked a test scope...

awesome, well, running lein deps :tree I see the driver hanging from modular.postgres so that must be the one I believe I should exclude

I may well replace project.clj with deps.edn instead since it's only useful for testing...

understood, well, thanks a lot for the help! I don't bother you anymore 🙂

Feel free to bother me any time I'm around 🙂

Which is general 9am Pacific to about 11pm Pacific 🙂

awesome, thanks a lot! 🙌