You're still not answering the question of how exactly you are _running_ your Clojure code.
No one is going to be able to help you if you don't provide enough details about what _exactly_ you are doing and what error / stack trace you are getting. Please also try the command sequence I showed you and see if that works. On Sat, Dec 24, 2011 at 5:27 PM, <s...@ida.net> wrote: > C:\>set classpath > CLASSPATH=c:/opt/jars/*;c:/projects/clarity4/src > > C:\> > > ----- Original Message ----- From: "Sean Corfield" <seancorfi...@gmail.com> > To: <clojure@googlegroups.com> > Sent: Saturday, December 24, 2011 4:30 PM > Subject: Re: (:require [clojure.contrib.sql :as sql])) > > > > On Sat, Dec 24, 2011 at 1:49 PM, <s...@ida.net> wrote: >> >> I am trying to run clojure file as: >> ============================================ >> (ns mysql >> >> (:require [clojure.contrib.sql :as sql])) > > > Looks like you're missing a line here before :subprotocol...? > >> :subprotocol "mysql" >> :subname "//localhost:3306/dummy" >> :user "root" >> :password "pass"}) >> (defn create-users [] >> (sql/create-table >> :users >> [:id :integer "PRIMARY KEY" "AUTO_INCREMENT"] >> [:fname "varchar(25)"] >> [:lname "varchar(25)"])) >> >> (defn drop-users [] >> (sql/drop-table :users)) >> (sql/with-connection db >> (create-users)) >> (defn insert-user [fname lname] >> (sql/insert-values :users [:fname :lname] [fname lname])) >> >> (sql/with-connection db >> (insert-user "Sandy" "Brown")) >> (sql/with-connection db >> (sql/with-query-results rs ["select * from users"] >> (dorun (map #(println %) rs)))) >> >> =================================== >> Do I include this statement to get sql and what is the proper way?? >> >> (:require [clojure.contrib.sql :as sql])) > > > You haven't answered the questions about how you are running your > Clojure code (what's on your classpath etc). > > Did you try the process I outlined? > >> ----- Original Message ----- From: "Sean Corfield" >> <seancorfi...@gmail.com> >> The monolithic contrib (1.2.0) has been deprecated. Updated versions >> of many of the modules are available individually: >> >> http://dev.clojure.org/display/design/Where+Did+Clojure.Contrib+Go >> >> However, if you have the JAR on your classpath, that namespace should >> be available. >> >> It would help people help you if you provided more detail: >> * How are you running your Clojure code? >> * What _exact_ error message (and partial stack trace) are you seeing? >> >> Here's an example workflow that shows you can access >> clojure.contrib.sql just fine: >> >> sean@sean-netbook:~/clojure$ lein new jay >> cd Created new project in: /home/sean/clojure/jay >> Look over project.clj and start coding in jay/core.clj >> sean@sean-netbook:~/clojure$ cd jay/ >> sean@sean-netbook:~/clojure/jay$ vi project.clj >> sean@sean-netbook:~/clojure/jay$ cat project.clj >> (defproject jay "1.0.0-SNAPSHOT" >> :description "FIXME: write description" >> :dependencies [[org.clojure/clojure "1.2.1"] >> [org.clojure/clojure-contrib "1.2.0"]]) >> sean@sean-netbook:~/clojure/jay$ lein deps >> Copying 2 files to /home/sean/clojure/jay/lib >> sean@sean-netbook:~/clojure/jay$ lein repl >> REPL started; server listening on localhost port 13024 >> user=> (ns jay.test (:require [clojure.contrib.sql :as sql])) >> nil >> jay.test=> ^D >> >> Sean > -- 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