Feel free to submit PRs to improve the documentation at: http://clojure-doc.org/articles/ecosystem/java_jdbc/home.html
On Mon, Jul 8, 2013 at 9:22 AM, Colin Yates <colin.ya...@gmail.com> wrote: > Found it - typically - messed around for hours, then post, the find it. > > The answer is to use something like 'mem:XYZ' for the subname. > > The clue was checking in > https://github.com/clojure/java.jdbc/blob/dd3c05b940b9a9c7a739247e2508ea6a5d55df65/src/main/clojure/clojure/java/jdbc.clj#L416 > and seeing how it actually constructs the URL then checking the expected URL > in http://hsqldb.org/doc/guide/ch01.html#N101CA. > > To be explicit, clojure java.jdbc wasn't doing anything wrong it was my > mistake in thinking 'mem' was enough for hsqldb. > > Sorry for the noise and hopes this help the next clueless newb :) > > > On Monday, 8 July 2013 15:16:44 UTC+1, Colin Yates wrote: >> >> Hi, >> >> I am using clojure.java.jdbc with HSQLDB, but I cannot figure out how to >> create an in-memory database. Whatever I try defaults to a file based >> instance, so: >> >> (def hsql-db {:classname "org.hsqldb.jdbcDriver" :subprotocol "hsqldb" >> :subname "memory"}) creates a file called memory.log etc. in my current >> working directory. Whatever I put in the :subname is used as the filename. >> I have tried "mem" with the same effect. >> >> Any pointers? Google and the java.jdbc documentation aren't helping... >> >> Thanks, >> >> Col > > -- > -- > 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/groups/opt_out. > > -- 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 --- 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/groups/opt_out.
