(defn inse []
(sql/with-connection db
(sql/transaction
(insert-rows :r [[1 2 "date '2008-12-03'" 3]])))
nil)
I have tried all kinds of variations. it works perfectly with another
table, like (int,int,int,int) and passing [1,2,3,4]
so it is the type of column 3 that is the problem.
"2008-12-03"
"'2008-12-03'"
"date 2008-12-03"
etc
tried all combos.
java.lang.Exception: transaction rolled back: Batch entry 0 insert
into reviews values (1488844,1,2005-09-06,3) was aborted. Call
getNextException to see the cause. (parsing.clj:0)
user=> java.lang.Exception: transaction rolled back: Batch entry 0
insert into reviews values (1,2,2008-12-02,3) was aborted. Call
getNextException to see the cause. (pg.clj:0)
user=> java.lang.Exception: transaction rolled back: Batch entry 0
insert into reviews values (1,2,2008-12-02,3) was aborted. Call
getNextException to see the cause. (pg.clj:0)
user=> (.getNextException)
java.lang.IllegalArgumentException: Malformed member expression,
expecting (.member target ...) (NO_SOURCE_FILE:50)
user=> (.getNextException 1)
java.lang.IllegalArgumentException: No matching field found:
getNextException for class java.lang.Integer (NO_SOURCE_FILE:0)
user=> (.getNextException java.lang.Exception)
java.lang.IllegalArgumentException: No matching field found:
getNextException for class java.lang.Class (NO_SOURCE_FILE:0)
user=> (.getNextException e)
java.lang.Exception: Unable to resolve symbol: e in this context
(NO_SOURCE_FILE:53)
user=> (printStackTrace)
java.lang.Exception: Unable to resolve symbol: printStackTrace in this
context (NO_SOURCE_FILE:54)
user=> (.printStackTrace)
java.lang.IllegalArgumentException: Malformed member expression,
expecting (.member target ...) (NO_SOURCE_FILE:55)
user=> .printStackTrace
java.lang.Exception: Unable to resolve symbol: .printStackTrace in
this context (NO_SOURCE_FILE:0)
user=> (System/getProperty "java.vm.version")
"10.0-b22"
user=> java.lang.Exception: transaction rolled back: Batch entry 0
insert into r values (1,2,2008-12-02,3) was aborted. Call
getNextException to see the cause. (pg.clj:0)
user=> ("2008-12")
java.lang.ClassCastException: java.lang.String cannot be cast to
clojure.lang.IFn (NO_SOURCE_FILE:0)
user=> java.lang.Exception: transaction rolled back: Batch entry 0
insert into r values (1,2,"2008-12-02",3) was aborted. Call
getNextException to see the cause. (pg.clj:0)
user=> java.lang.Exception: Unsupported escape character: \' (pg.clj:
59)
user=> java.lang.NumberFormatException: Invalid number: 2008-12-02
(pg.clj:59)
user=> java.lang.Exception: transaction rolled back: Batch entry 0
insert into r values (1,2,'2008-12-02',3) was aborted. Call
getNextException to see the cause. (pg.clj:0)
user=> (System/getNextException)
java.lang.NoSuchFieldException: getNextException (NO_SOURCE_FILE:65)
user=> java.lang.Exception: transaction rolled back: Batch entry 0
insert into r values (1,2,2008-12-02,3) was aborted. Call
getNextException to see the cause. (pg.clj:0)
user=> (System/getNextException)
java.lang.NoSuchFieldException: getNextException (NO_SOURCE_FILE:67)
user=> (System/getNextException)
java.lang.NoSuchFieldException: getNextException (NO_SOURCE_FILE:68)
user=> (System/getNextException)
java.lang.NoSuchFieldException: getNextException (NO_SOURCE_FILE:69)
user=> (System/getNextException)
java.lang.NoSuchFieldException: getNextException (NO_SOURCE_FILE:70)
user=> nil
user=> nil
user=> java.lang.Exception: transaction rolled back: Batch entry 0
insert into r values (1,2,NULL,3) was aborted. Call getNextException
to see the cause. (pg.clj:0)
user=> java.lang.Exception: Unsupported escape character: \' (pg.clj:
59)
user=> (.replace '2008-12-025' "5" "")
java.lang.NumberFormatException: Invalid number: 2008-12-025
user=> "5"
user=> ""
user=> java.lang.Exception: Unmatched delimiter: )
user=> (.replace "2008-12-025" "5" "")
"2008-12-02"
user=> java.lang.Exception: transaction rolled back: Batch entry 0
insert into r values (1,2,'2008-12-03',3) was aborted. Call
getNextException to see the cause. (pg.clj:0)
user=> java.lang.Exception: transaction rolled back: Batch entry 0
insert into r values (1,2,date '2008-12-03',3) was aborted. Call
getNextException to see the cause. (pg.clj:0)
user=>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To post to this group, send email to clojure@googlegroups.com
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
-~----------~----~----~----~------~----~------~--~---
