Clojure Contrib

Namespaces

clojure.contrib
- accumulators
- agent-utils
- apply-macro
- base64
- classpath
- combinatorics
- command-line
- complex-numbers
- cond
- condition
- core
- dataflow
- datalog
  - database
  - literals
  - magic
  - rules
  - softstrat
  - util
- def
- duck-streams
- error-kit
- except
- fcase
- find-namespaces
- fnmap
  - PersistentFnMap
- gen-html-docs
- generic
  - arithmetic
  - collection
  - comparison
  - functor
  - math-functions
- graph
- greatest-least
- http
  - agent
  - connection
- import-static
- io
- jar
- java-utils
- javadoc
  - browse
  - browse-ui
- jmx
  - Bean
- json
- lazy-seqs
- lazy-xml
- logging
- macro-utils
- macros
- map-utils
- math
- miglayout
  - internal
- mmap
- mock
  - test-adapter
- monadic-io-streams
- monads
- ns-utils
- pprint
  - column-writer
  - pretty-writer
  - utilities
- probabilities
  - finite-distributions
  - monte-carlo
  - random-numbers
- profile
- properties
- prxml
- reflect
- repl-ln
- repl-utils
- seq
- seq-utils
- server-socket
- set
- shell
- shell-out
- singleton
- sql
  - internal
- str-utils
- str-utils2
- stream-utils
- string
- strint
- swing-utils
- test-is
- trace
- types
- with-ns
- zip-filter
  - xml

1.2.0 permalink

1.2.0

with-connection

Evaluates body in the context of a new connection to a database then
closes the connection. db-spec is a map containing values for one of the
following parameter sets:

Factory:
:factory (required) a function of one argument, a map of params
(others) (optional) passed to the factory function in a map

DriverManager:
:classname (required) a String, the jdbc driver class name
:subprotocol (required) a String, the jdbc subprotocol
:subname (required) a String, the jdbc subname
(others) (optional) passed to the driver as properties.

DataSource:
:datasource (required) a javax.sql.DataSource
:username (optional) a String
:password (optional) a String, required if :username is supplied

JNDI:
:name (required) a String or javax.naming.Name
:environment (optional) a java.util.Map

1 Example top

link | changes
```
(with-connection {:classname "oracle.jdbc.driver.OracleDriver"
                  :subprotocol "oracle"
                  :subname (str "thin:@//" host ":1521/" db)
                  :user "joe"
                  :password "secret"}
  ...)
```
<pre> (with-connection {:classname "oracle.jdbc.driver.OracleDriver" :subprotocol "oracle" :subname (str "thin:@//" host ":1521/" db) :user "joe" :password "secret"} ...) </pre>

Source clojure/contrib/sql.clj:32 top

(defmacro with-connection
  "Evaluates body in the context of a new connection to a database then
  closes the connection. db-spec is a map containing values for one of the
  following parameter sets:

  Factory:
    :factory     (required) a function of one argument, a map of params
    (others)     (optional) passed to the factory function in a map

  DriverManager:
    :classname   (required) a String, the jdbc driver class name
    :subprotocol (required) a String, the jdbc subprotocol
    :subname     (required) a String, the jdbc subname
    (others)     (optional) passed to the driver as properties.

  DataSource:
    :datasource  (required) a javax.sql.DataSource
    :username    (optional) a String
    :password    (optional) a String, required if :username is supplied

  JNDI:
    :name        (required) a String or javax.naming.Name
    :environment (optional) a java.util.Map"
  [db-spec & body]
  `(with-connection* ~db-spec (fn [] ~@body)))

Vars in clojure.contrib.sql/with-connection: defmacro apply concat fn list seq vector

Used in 8 other vars with-connection ssh-shell with-connection ssh-exec control-loop read-loop spawn-repl-thread with-connection

Comments top

1 comment(s) for with-connection.

Brian Marick

link

This helpful example shows many of the contrib.sql functions you'd use for writing blog software.

ClojureDocs(beta)