>the general idiom with-some-resource means that resources will be cleared after leaving its >scope. JUst like with 'with-open' which has a try/finally in order to .close() any closable >resource upon exit. I've not used clojure.java.jdbc but I suspect the same rationale applies >for with-connection...
Thanks for that. That is good to remember. On Friday, November 9, 2012 12:56:00 PM UTC-5, Jim foo.bar wrote: > > the general idiom with-some-resource means that resources will be > cleared after leaving its scope. JUst like with 'with-open' which has a > try/finally in order to .close() any closable resource upon exit. I've not > used clojure.java.jdbc but I suspect the same rationale applies for > with-connection... > > for example in one of my GUIs I have a 'with-busy-cursor' and a > 'with-block' macros. Every time an expensive operation happens on the gui I > want a busy cursor but also I want my buttons to be non-reactive while the > busy-cursor is visible (the user can click but nothing happens). so imagine > i've got the 'with-block' called from inside the 'with-busy-cursor' and > that removes all the boilerplate code for restoring the cursor and the > reactive gui... > > hope that helps... > > Jim > > > > > > On 09/11/12 17:42, larry google groups wrote: > > > Sorry this is such an ignorant question, but I am new to Clojure and the > JVM. I am tring to find info about clojure.java.jdbc so I looked here: > > http://corfield.org/blog/post.cfm/connecting-clojure-and-mysql > > and saw this example: > > (ns mysql.core > (:require [clojure.java.jdbc :as sql])) > > (def db {:classname "com.mysql.jdbc.Driver" > :subprotocol "mysql" > :subname "//localhost:3306/dbname" > :user "dbuser" > :password "secret"}) > > (defn list-users [] > (sql/with-connection db > (sql/with-query-results rows > ["select * from user"] > (println rows)))) > > Can I assume that sql/with-connection does some magic in the background to > manage the connection? I would not want the connection to get shut down, and > then restarted, everytime I run a query. > > -- > You received this message because you are subscribed to the Google > Groups "Clojure" group. > To post to this group, send email to clo...@googlegroups.com <javascript:> > Note that posts from new members are moderated - please be patient with > your first post. > To unsubscribe from this group, send email to > clojure+u...@googlegroups.com <javascript:> > 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
