I am looking here:

http://clojure.github.com/java.jdbc/

I notice this:

do-commands

Usage: (do-commands & commands)

Executes SQL commands on the open database connection.



This seems flexible, but how does it know what the open database connection 
is? I have to switch between 2 databases. 



On Friday, November 9, 2012 12:53:56 PM UTC-5, Sean Corfield wrote:
>
> On Fri, Nov 9, 2012 at 9:42 AM, larry google groups 
> <lawrenc...@gmail.com <javascript:>> wrote: 
> > 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. 
>
> Use a connection pool. There's an example of c3p0 in the java.jdbc 
> documentation: 
>
> http://clojure.github.com/java.jdbc/ 
>
> Specifically: 
>
>
> http://clojure.github.com/java.jdbc/doc/clojure/java/jdbc/ConnectionPooling.html
>  
> -- 
> Sean A Corfield -- (904) 302-SEAN 
> An Architect's View -- http://corfield.org/ 
> World Singles, LLC. -- http://worldsingles.com/ 
>
> "Perfection is the enemy of the good." 
> -- Gustave Flaubert, French realist novelist (1821-1880) 
>

-- 
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

Reply via email to