Hi Josh,
I would opt for using Tomcat 7 Pool API -
http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html
The following code wraps the pool api and provides reading a config file
(ns foo
(:require [clojure.java.io :as io])
(:import [java.io PushbackReader])
(:gen-class))
(defn conf [file]
"Reads a config file containing the connection params (url, driver)"
(binding [*read-eval* false]
(with-open [r (io/reader file)]
(read (PushbackReader. r)))))
(defn datasource [file]
"creates a pooled data source"
(let
[config (conf file) ds (new org.apache.tomcat.jdbc.pool.DataSource) pp
(new org.apache.tomcat.jdbc.pool.PoolProperties)]
(do
(.setDriverClassName pp (:classname config))
(.setUrl pp (:subname config))
(.setUsername pp (:user config))
(.setPassword pp (:password config))
(.setTestOnBorrow pp true)
(.setValidationQuery pp "SELECT 1")
(.setMaxActive pp 5)
(.setInitialSize pp 1)
(.setMaxWait pp 10000)
(.setPoolProperties ds pp)
(identity ds))))
create a file dbconnection.ini with you jdbc connection params as per the
following example (uses derby in-memory db)
{
:classname "org.apache.derby.jdbc.EmbeddedDriver"
:subprotocol "memory"
:subname "jdbc:derby:memory:myDB;create=true"
:user ""
:password ""
}
now you can load the config and create a pooled connection as wished
(def ds (datasource (clojure.java.io/as-file "db.properties")))
you can obtain a connection using
{:datasource ds}
Cheers
Christian
Am Freitag, 13. September 2013 12:22:47 UTC+2 schrieb Josh Kamau:
>
> Hello there ;
>
> I am in desparate need of a clojure.jdbc with a connection pool example.
>
> I have googled and the link to github example is broken.
>
> Please help.
>
> Thanks.
> Josh
>
--
--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to [email protected]
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
