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.
