How to do batch jdbc/insert! and jdbc/update! using postgresql in Clojure?

Question

I was trying to do batch insert and update in Clojure but I'm having some problems.

Libraries that I use are: clojure.java.jdbc and postgresql.

There are some examples on the internet but I could not make it working, I ended up getting exceptions like this:

CompilerException java.sql.BatchUpdateException: Batch entry 0 INSERT INTO person ( data, age ) VALUES ( 'ertu', '24' ) was aborted. Call getNextException to see the cause.

or

CompilerException clojure.lang.ArityException: Wrong number of args (6) passed to: jdbc/db-do-prepared

I'm trying to pass maps or vectors but it does not work so far.

Could you provide some concrete examples that clojure.java.jdbc/insert! and clojure.java.jdbc/update! work?

Also found this question but did not understand what (first stmts) and (rest stmts) are.

Can you share the code you've tried? It might help diagnose what's going wrong. — Alejandro C.
– Alejandro C., Commented Jun 9, 2017 at 14:24
Be sure to also see the Clojure Cookbook: github.com/clojure-cookbook/clojure-cookbook/tree/master/… — Alan Thompson
– Alan Thompson, Commented Jun 9, 2017 at 18:31

Alejandro C. · Accepted Answer · 2017-06-09 14:21:22Z

0

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

(jdbc/db-do-commands db-spec
  (ddl/create-table :fruit
    [:name "varchar(16)" "PRIMARY KEY"]
    [:appearance "varchar(32)"]
    [:cost :int "NOT NULL"]
    [:unit "varchar(16)"]
    [:grade :real]))
;; -> (0)


(jdbc/insert! db-spec :fruit
  nil ; column names omitted
  ["Red Delicious" "dark red" 20 "bushel" 8.2]
  ["Plantain" "mild spotting" 48 "stalk" 7.4]
  ["Kiwifruit" "fresh"  35 "crate" 9.1]
  ["Plum" "ripe" 12 "carton" 8.4])

answered Jun 9, 2017 at 14:21

Alejandro C.

3,80118 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ertuğrul Çetin Over a year ago

maximum number of paramaters is 5 for insert! function did you even execute the code?

Alejandro C. Over a year ago

I think we're on different versions... e.g. github.com/clojure/java.jdbc/blob/…

Alejandro C. Over a year ago

Will look at a more recent version

Collectives™ on Stack Overflow

How to do batch jdbc/insert! and jdbc/update! using postgresql in Clojure?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related