I'm trying to use the sql contrib library to connect to a Postgres database. It's not clear to me how to specify a username and password. Here's what I'm trying.
(use 'clojure.contrib.sql) (let [db-host "localhost" db-name "ct" db-port 5432 subname (str "//" db-host ":" db-port "/" db-name)] (println "subname =" subname) (def db {:classname "org.postgresql.Driver" ; must be in classpath :subprotocol "postgresql" :subname subname :username "mvolkmann" :password ""}) (with-connection db (with-query-results rs ["select * from ElementType"] (println rs)))) The error I get is "org.postgresql.util.PSQLException: FATAL: no PostgreSQL user name specified in startup packet". I think the problem is that the username and password values in db aren't used by with-connection unless a DataSource object is specified. However, it doesn't seem like I should have to create one of those just to connect to a relational database. Any idea what I'm doing wrong? -- R. Mark Volkmann Object Computing, Inc. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/clojure?hl=en -~----------~----~----~----~------~----~------~--~---