Have a look at dbcon.clj and db.clj in my https://github.com/Bost/ufo
It's a rather minimal example of clojure/clojurescript + mysql
2017-10-19 15:10 GMT+02:00 Damien Mattei <damien.mat...@gmail.com>:
> Thank Lubomir,
> it works, i'm new to Clojure and did not use the name space the right way, i
> had to remove [mysql/mysql-connector-java "5.1.38"] also , do not know
> why...
>
> here is the working code and result:
>
> (ns jclojure.core
> (:gen-class)
> (:require [clojure.java.jdbc :as jdbc] )
> )
>
> ;(ns jclojure.core
> ; (:gen-class)
> ; (:require [clojure.java.jdbc :as jdbc]
> ; [mysql/mysql-connector-java "5.1.38"]))
>
>
> (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/query db
> ["select * from Sigles"]
> {:row-fn println} )
>
> ;(jdbc/with-connection db
> ; (jdbc/with-query-results rows
> ; ["select * from Sigles"]
> ; (println rows)))
>
>
> )
>
> [mattei@moita jclojure]$ lein run
> Hello, World!
> {:sigle ApJ, :intitulé AstroPhysical Journal}
> {:sigle ApJS, :intitulé AstroPhysical Journal - supplement}
> {:sigle A&A, :intitulé Astronomy and Astrophysics}
> {:sigle A&AS, :intitulé Astronomy and Astrophysics - supplement series}
> {:sigle A.A.W., :intitulé Acta Astronomica Warszawa}
> {:sigle ABO, :intitulé Annals Bosscha Observatory}
> {:sigle ABS, :intitulé Annals Bosscha Sterrenwacht}
> {:sigle ADONU, :intitulé Annals Dearborn Observatory - Northwestern
> University}
> {:sigle AJ, :intitulé Astronomical Journal}
> {:sigle AJS, :intitulé Astronomical Journal - supplement}
> {:sigle AN, :intitulé Astronomische Nachrichten}
> {:sigle AORB, :intitulé Annales de l'Observatoire Royal de Belgique}
> {:sigle AOS, :intitulé Annales de l'Observatoire
>
> ...
>
>
> Damien
>
>
>
> On Thursday, October 19, 2017 at 12:49:31 PM UTC+2, Lubomir Konstantinov
> wrote:
>>
>> 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.
--
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.
