derby.clj

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

(def dbpath
  (jio/file (System/getProperty "user.home") "derby.example.db"))

(def db
  {:classname "org.apache.derby.jdbc.EmbeddedDriver" ; "derby" も可能
   :subprotocol "derby"
   :subname dbpath
   :create true})

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

(sql/with-connection db
  (sql/create-table
    :testing
    [:data "varchar(140)"]))

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

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

https://gist.github.com/4484208

の Apache Derby 版。

project.clj の [org.apache.derby/derby "10.8.1.2"] も忘れずに。