Re: Recipe for using two databases with contrib.sql

2010-12-09 Thread Sean Corfield
Take a look at this for connection pooling: http://bitbucket.org/kumarshantanu/clj-dbcp/src On Thu, Dec 9, 2010 at 1:39 PM, Ghadi Shayban wrote: > I'm using contrib,sql to clean rows from one DB and insert them into > another. > > I was thinking something like (pseudo-code > > (sql/with-connecti

Recipe for using two databases with contrib.sql

2010-12-09 Thread Ghadi Shayban
I'm using contrib,sql to clean rows from one DB and insert them into another. I was thinking something like (pseudo-code (sql/with-connection db1 . (doseq [x (map rs)] (insert-into-other x))) (defn insert-into-other [r] (sql/with-connection db2 ...)) But this obviously will open/close