How to execute! multiple SQL commands over a connection?

[theronic]

How can I reuse the same connection to run multiple SQL commands? When I eval my (build-schema) defined below, I get the error:

java.sql.SQLException: You can't operate on a closed Connection!!!

Here is a mock schema using SQLingvo:

(def my-schema [
    (sql (create-table :users
                  (column :id :uuid :primary-key? true)
                  (column :email :text)))
    (sql (create-table :publishers
                  (column :id :uuid :primary-key? true)
                  (column :name :text :not-null? true)))])

Here is my build-schema function that doseq's over my schema:

(defn build-schema []
  (let [conn (make-connection dbspec)]
    (tx/with-transaction conn
      (with-catch
        (doseq [[cmd] my-schema]
          (execute! conn cmd))
        (.close conn)))))

[theronic]

Ah, sorry I had to put the (.close conn) outside the tx/with-transaction:

(defn build-schema []
  (let [conn (make-connection dbspec)]
    (with-catch
    (tx/with-transaction conn
        (doseq [[cmd] my-schema]
          (execute! conn cmd)))
        (.close conn))))

[niwinz]

You also can use with-open clojure macro :D

(with-open [conn (make-connection dbspec)]
  your code here...)

You can see few options to open a connection here: http://niwibe.github.io/clojure.jdbc/#_creating_a_connection