Thanks but I am not getting anything with it. Here's what I have. Does it
seem correct?
(ns cljstudent.sqlite
(:require [clojure.contrib.sql :as sql]))
;; need this to load the sqlite3 driver (as a side effect of evaluating the
expression)
;;(Class/forName "org.sqlite.JDBC")
(def db-path "/home/melipone/cljstudent/places.sqlite")
(def db-specs {:classname "org.sqlite.JDBC",
:subprotocol "sqlite",
:subname db-path})
(def db-query "select * from moz_places where visit_count > 100")
(defn get-data []
(sql/with-connection db-specs
(sql/with-query-results results [db-query]
(doall results))))
On , willyh <wheine...@gmail.com> wrote:
I'm using the sqlite-jdbc jar from a maven repository. I use this in
my leiningen project to fetch it:
[org.xerial/sqlite-jdbc "3.7.2"]
I haven't had any issues with it, but that doesn't mean you won't.
On Nov 9, 12:50 pm, labwor...@gmail.com wrote:
> sqlite3 had some problems but a later version (3.7.9) seems to work. Now
> the sqlitejdbc jar on clojars version 0.5.6 has the same problems as the
> old sqlite3 command line. Basically, I get this error below when reading
> certain .sqlite files. Is there a latest version of the sqlitejdcb
driver
> for clojure?
> cljstudent.sqlite=> (get-data)
> java.sql.SQLException: file is encrypted or is not a database
> (NO_SOURCE_FILE:0
--
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 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
