Clojure JDBC-此结果集已关闭

SELECT 使用 java.jdbc UPDATE INSERT

我正在使用这些依赖项

[org.clojure/java.jdbc "0.7.8"]
[postgresql "9.3-1102.jdbc41"]

这是我的工作代码 选择 -从一个名为 public."user"

(ns knp-api.model.user
  (:require [clojure.java.jdbc :as sql]))


(def db "jdbc:postgresql://ampersanda@localhost:5432/idjoesoft_klinik")

(defn get-count [q]
  "Get count key from query
   It takes jdbc.query as parameter"
  (:count (first (into [] q))))

(defn is-user-email-available? [e]
  "Returns boolean when email is available.
   Take one parameter, it's email"
  (let [q "SELECT COUNT(*) FROM public.\"user\" t WHERE user_email = ?"]
    (sql/query db [q e] {:result-set-fn #(= 1 (get-count %))})))

这不是我的代码,它会出现异常

(defn set-user-timestamp-and-token [email token timestamp]
  "update user current token and last login time inside database.
   Takes email, token, and current timestamp as parameter"
  (sql/update! db 
               "public.\"user\"" 
               {:user_last_login (str "to_timestamp(" timestamp ")") 
                :user_token token}  
               ["user_email = ?" email]))

更新

我还尝试使用REPL创建表,也得到了相同的结果。

knp-api.handler=> (require '[clojure.java.jdbc :as sql])
nil
knp-api.handler=> (sql/db-do-commands "jdbc:postgresql://ampersanda@localhost:5432/idjoesoft_klinik" (sql/create-table-ddl :testing [[:data :text]]))

PSQLException This ResultSet is closed.  org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed (AbstractJdbc2ResultSet.java:2852)