Bad case of copy pasta?

You have am extra namespace definition:

  (ns dbns
      (:require [clojure.java.jdbc :as jdbc]
          [mysql/mysql-connector-java "5.1.38"]))

You need to remove it, and move the require clause up in your ns:

(ns jclojure.core
    (:gen-class)
    (:require [clojure.java.jdbc :as jdbc]
          [mysql/mysql-connector-java "5.1.38"]))

On Thursday, 19 October 2017 13:37:08 UTC+3, Damien Mattei wrote:
>
> hello again,
>
> i tried dozen of web example about mysql and clojure but it doen't work, 
> here is some of my code:
>
> for dependencies:
>
> (defproject jclojure "0.1.0-SNAPSHOT"
>   :description "clojure JVM source code for Sidonie web interface 
> administration"
>   :url "https://sidonie.oca.eu";
>   :license {:name "Eclipse Public License"
>   :url "http://www.eclipse.org/legal/epl-v10.html"}
>
>   :dependencies [
>   [org.clojure/clojure "1.8.0"]  
>   [mysql/mysql-connector-java "5.1.38"]
>   [org.clojure/java.jdbc "0.7.3"]
>   ]
>
>   :main ^:skip-aot jclojure.core
>   :target-path "target/%s"
>   :profiles {:uberjar {:aot :all}})
>
>
> the code (some of...):
>
> (ns jclojure.core
>     (:gen-class))
>
> (defn -main
>   "I don't do a whole lot ... yet."
>   [& args]
>   
>   ;(:require [clojure.java [jdbc :as sql]])
>
>   ;(require '[clojure.java.jdbc :as jdbc])
>
>   (ns dbns
>       (:require [clojure.java.jdbc :as jdbc]
>           [mysql/mysql-connector-java "5.1.38"]))
>   
>   ;(use 'clojure.java.jdbc)
>   
>   (println "Hello, World!")
>
>   (let [
>     db-host "localhost"
>     db-port 3306
>     db-name "sidonie"
>     ]
>     
>     (def db {
>      :classname "com.mysql.jdbc.Driver" ; must be in classpath
>      :subprotocol "mysql"
>      :subname (str "//" db-host ":" db-port "/" db-name)
>                     ; Any additional keys are passed to the driver
>                     ; as driver-specific properties.
>      :user "mattei"
>      :password "sidonie2"}))
>   
>                     ;(jdbc/query db ["SELECT * FROM Sigles"])
>
>   (jdbc/with-connection db
>             (jdbc/with-query-results rows
>                          ["select * from Sigles"]
>                          (println rows)))
>
>  
>   )
>
>
> and now the error:
>
> [mattei@moita jclojure]$ lein run
> Exception in thread "main" java.lang.RuntimeException: No such namespace: 
> jdbc, compiling:(jclojure/core.clj:37:3)
>         at clojure.lang.Compiler.analyze(Compiler.java:6688)
>         at clojure.lang.Compiler.analyze(Compiler.java:6625)
>         at clojure.lang.Compiler$InvokeExpr.parse(Compiler.java:3766)
>         at clojure.lang.Compiler.analyzeSeq(Compiler.java:6870)
>         at clojure.lang.Compiler.analyze(Compiler.java:6669)
>         at clojure.lang.Compiler.analyze(Compiler.java:6625)
>         at clojure.lang.Compiler$BodyExpr$Parser.parse(Compiler.java:6001)
>         at clojure.lang.Compiler$FnMethod.parse(Compiler.java:5380)
>         at clojure.lang.Compiler$FnExpr.parse(Compiler.java:3972)
>         at clojure.lang.Compiler.analyzeSeq(Compiler.java:6866)
>         at clojure.lang.Compiler.analyze(Compiler.java:6669)
>         at clojure.lang.Compiler.analyzeSeq(Compiler.java:6856)
>         at clojure.lang.Compiler.analyze(Compiler.java:6669)
>         at clojure.lang.Compiler.access$300(Compiler.java:38)
>         at clojure.lang.Compiler$DefExpr$Parser.parse(Compiler.java:589)
>         at clojure.lang.Compiler.analyzeSeq(Compiler.java:6868)
>         at clojure.lang.Compiler.analyze(Compiler.java:6669)
>         at clojure.lang.Compiler.analyze(Compiler.java:6625)
>         at clojure.lang.Compiler.eval(Compiler.java:6931)
>         at clojure.lang.Compiler.load(Compiler.java:7379)
>         at clojure.lang.RT.loadResourceScript(RT.java:372)
>         at clojure.lang.RT.loadResourceScript(RT.java:363)
>         at clojure.lang.RT.load(RT.java:453)
>         at clojure.lang.RT.load(RT.java:419)
>         at clojure.core$load$fn__5677.invoke(core.clj:5893)
>         at clojure.core$load.invokeStatic(core.clj:5892)
>         at clojure.core$load.doInvoke(core.clj:5876)
>         at clojure.lang.RestFn.invoke(RestFn.java:408)
>         at clojure.core$load_one.invokeStatic(core.clj:5697)
>         at clojure.core$load_one.invoke(core.clj:5692)
>         at clojure.core$load_lib$fn__5626.invoke(core.clj:5737)
>         at clojure.core$load_lib.invokeStatic(core.clj:5736)
>         at clojure.core$load_lib.doInvoke(core.clj:5717)
>         at clojure.lang.RestFn.applyTo(RestFn.java:142)
>         at clojure.core$apply.invokeStatic(core.clj:648)
>         at clojure.core$load_libs.invokeStatic(core.clj:5774)
>         at clojure.core$load_libs.doInvoke(core.clj:5758)
>         at clojure.lang.RestFn.applyTo(RestFn.java:137)
>         at clojure.core$apply.invokeStatic(core.clj:648)
>         at clojure.core$require.invokeStatic(core.clj:5796)
>         at clojure.core$require.doInvoke(core.clj:5796)
>         at clojure.lang.RestFn.invoke(RestFn.java:408)
>         at user$eval5$fn__7.invoke(form-init7437695112761150837.clj:1)
>         at user$eval5.invokeStatic(form-init7437695112761150837.clj:1)
>         at user$eval5.invoke(form-init7437695112761150837.clj:1)
>         at clojure.lang.Compiler.eval(Compiler.java:6927)
>         at clojure.lang.Compiler.eval(Compiler.java:6917)
>         at clojure.lang.Compiler.load(Compiler.java:7379)
>         at clojure.lang.Compiler.loadFile(Compiler.java:7317)
>         at clojure.main$load_script.invokeStatic(main.clj:275)
>         at clojure.main$init_opt.invokeStatic(main.clj:277)
>         at clojure.main$init_opt.invoke(main.clj:277)
>         at clojure.main$initialize.invokeStatic(main.clj:308)
>         at clojure.main$null_opt.invokeStatic(main.clj:342)
>         at clojure.main$null_opt.invoke(main.clj:339)
>         at clojure.main$main.invokeStatic(main.clj:421)
>         at clojure.main$main.doInvoke(main.clj:384)
>         at clojure.lang.RestFn.invoke(RestFn.java:421)
>         at clojure.lang.Var.invoke(Var.java:383)
>         at clojure.lang.AFn.applyToHelper(AFn.java:156)
>         at clojure.lang.Var.applyTo(Var.java:700)
>         at clojure.main.main(main.java:37)
> Caused by: java.lang.RuntimeException: No such namespace: jdbc
>         at clojure.lang.Util.runtimeException(Util.java:221)
>         at clojure.lang.Compiler.resolveIn(Compiler.java:7134)
>         at clojure.lang.Compiler.resolve(Compiler.java:7108)
>         at clojure.lang.Compiler.analyzeSymbol(Compiler.java:7069)
>         at clojure.lang.Compiler.analyze(Compiler.java:6648)
>         ... 61 more
>
>
> any idea? 
>
> note i have made already lein deps (all the .jar are well retrieved ) and 
> the database is up and running
>
> damien
>
>

-- 
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/d/optout.

Reply via email to