Rather than doing something that requires a dependency on specific JDBC driver
classes, it seems that if an :auto-commit option in the db-spec were honored by
get-connection you would get what you needed:
(into [] (take 2) (jdbc/reducible-query (assoc config/db :auto-commit
false) query {:fetch-size 500}))
You can already pass additional options into the DriverManager/getConnection
call as properties (from the db-spec) but autocommit does not appear to be
supported in that format.
Actually, it would be cleaner if get-connection had a 2-arity accepting db-spec
and opts, and then everything could pass opts into get-connection and you could
do:
(into [] (take 2) (jdbc/reducible-query config/db query {:fetch-size
500 :auto-commit false }))
Are there other settings that folks would find worthwhile to support here?
Feedback / comments: https://dev.clojure.org/jira/browse/JDBC-153
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: Wednesday, July 5, 2017 5:42 AM
To: Sean Corfield; Clojure Mailing List
Subject: Re: [ANN] clojure.java.jdbc 0.7.0 Beta 1
Sean Corfield <s...@corfield.org> writes:
>> The required steps to setup streaming are different from database to
>> database and I guess they may change with the driver version being used.
>
> This is really the crux of the problem here – I’m not sure what java.jdbc can
> do generically to make this much easier.
Please take a look at the attachment or
https://gist.github.com/schmir/6e03b3d649950d0108a06bf6fd653dec
This is using the robert.hooke library to hook into prepare-statement.
That hook calls into a protocol function if streaming is required. This
protocol function can be defined by users for the database they are
using.
I think it would be really nice for clojure.java.jdbc to provide this
functionality.
--
Cheers
Ralf
--
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
Note that posts from new members are moderated - please be patient with your
first post.
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
---
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to clojure+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
