postgresql.clj

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

(def db
  "postgresql://postgres:postgres@localhost:5432/shouter")

(sql/with-connection db
 (try (sql/drop-table :testing) (catch Exception _)))

(sql/with-connection db
 (sql/create-table :testing [:data :text]))

(sql/with-connection db
 (sql/insert-rows
   :testing
   ["Hello, world!"]
   ["Hello, PostgreSQL!"]))

(sql/with-connection db
  (sql/with-query-results results
    ["select * from testing"]
    (into [] results)))

https://devcenter.heroku.com/articles/clojure-web-application#connecting-to-postgresql-with-clojurejavajdbc

Clojure から RDBMS を操作するため、上記 URL を写経 + 一部改変。 PostgreSQL を使った例。

Apache Derby 版は https://gist.github.com/4484275

project.clj の [postgresql "9.1-901.jdbc4"] も忘れずに。