RE: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-05 Thread Sean Corfield
wood From: Luke Burton Sent: Wednesday, July 5, 2017 11:12 AM To: Clojure Cc: Java.JDBC Mailing List Subject: Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1 I've been meaning to chime in here … My take is that clojure.java.jdbc should not be responsible for providing o

RE: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-05 Thread Sean Corfield
"If you're not annoying somebody, you're not really alive." -- Margaret Atwood From: Ralf Schmitt Sent: Wednesday, July 5, 2017 2:57 PM To: Sean Corfield; Clojure Mailing List Subject: Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1 Sean Corfield writes:

RE: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-05 Thread Sean Corfield
Margaret Atwood From: Luke Burton Sent: Wednesday, July 5, 2017 11:12 AM To: Clojure Cc: Java.JDBC Mailing List Subject: Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1 I've been meaning to chime in here … My take is that clojure.java.jdbc should not be responsible for pr

Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-06 Thread Ralf Schmitt
Sean Corfield writes: > The :auto-commit? option is supported in 0.7.0-beta5 which should hit > Maven Central by tomorrow (or maybe late tonight). Please let me know > if it solves the streaming problem. yes, it does work. Thanks. -- Cheers Ralf -- You received this message because you are s

Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-06 Thread Ralf Schmitt
Ralf Schmitt writes: > Sean Corfield writes: > >> The :auto-commit? option is supported in 0.7.0-beta5 which should hit >> Maven Central by tomorrow (or maybe late tonight). Please let me know >> if it solves the streaming problem. > > yes, it does work. Thanks. Sorry, but that's not entirely t

RE: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-06 Thread Sean Corfield
alive." -- Margaret Atwood From: Ralf Schmitt Sent: Thursday, July 6, 2017 5:19 AM To: Sean Corfield; Clojure Mailing List Subject: Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1 Ralf Schmitt writes: > Sean Corfield writes: > >> The :auto-commit? option is

Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-06 Thread Ralf Schmitt
Sean Corfield writes: > You said: > > But when the database is already connected like in > > (jdbc/with-db-connection [db db] > (jdbc/query db > query > {:result-set-fn (fn [coll] (doall (take 2 coll))) > :fetch-size 100 > :a

RE: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-06 Thread Sean Corfield
hursday, July 6, 2017 2:12 PM To: Sean Corfield; Clojure Mailing List Subject: Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1 Sean Corfield writes: > You said: > > But when the database is already connected like in > > (jdbc/with-db-c

Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-06 Thread Ralf Schmitt
Sean Corfield writes: >> The fact that the code currently sets the flag when opening the >> connection is an implementation detail. It should not leak into the API > > On the contrary – it is important to identify the scope of the connection and > the scope of when auto-commit is on/off. But wh

Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-07 Thread Ralf Schmitt
Ralf Schmitt writes: >> (into [] (take 2) (jdbc/query db query {:fetch-size 500 :auto-commit? >> false})) > > Sorry, this one works. will test with reducible-query tomorrow. reducible-query also works (and it also ignores the :auto-commit? parameter when wrapped inside a with-db-connection). -

RE: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-07 Thread Sean Corfield
(970) FOR-SEAN -- (904) 302-SEAN An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood From: Ralf Schmitt Sent: Friday, July 7, 2017 2:37 AM To: Clojure Mailing List Cc: Sean Corfield Subject: Re:

Re: JDBC Connection auto-commit?: [ANN] clojure.java.jdbc 0.7.0 Beta1

2017-07-07 Thread Ralf Schmitt
Sean Corfield writes: > Of course. The :auto-commit? parameter has to be passed to > with-db-connection so that connections and their state are properly > scoped, so that connections don’t “randomly” change their behavior > half way through a with-db-connection block because a _query_ > (somethin