Yeah, you probably shouldn't rely on this but I think it will still work. I have done something similar before when reading from 3 databases simultaneously (3 nested with-connection and with-query-result calls) and I believe (connection) is only called once when creating the prepared statement.
On Tue, Oct 9, 2012 at 9:24 PM, Sean Corfield <seancorfi...@gmail.com> wrote: > No, the inner with-connection binds *db* to db1 so db2 is no longer > accessible. > > This is why c.j.jdbc is getting an API overall that will expose functions > that accept the connection or the db-spec directly (and the old API will be > rewritten in terms of the new one for compatibility). > > Sean > > > On Tue, Oct 9, 2012 at 2:44 PM, gaz jones <gareth.e.jo...@gmail.com> wrote: >> >> Can you not simply: >> >> (jdbc/with-connection db2 >> (jdbc/with-query-results results >> query >> {:result-type :forward-only >> :fetch-size 1000} >> (jdbc/with-connection db1 >> ;; read and write? >> ))) >> >> ? > > > > -- > 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 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