Minimal JDBC abstraction.
project.clj:
:dependencies [[io.github.cl-journeyor/jnorlib-db "0.1.0"]]
Your project must depend on a JDBC driver.
The following snippet adds the PostgreSQL JDBC driver at project.clj:
:dependencies [[org.postgresql/postgresql "42.7.11"]]
Your program must have access to an instance implementing javax.sql.DataSource. You can easily create data sources with the com.zaxxer.hikari.HikariDataSource class from the HikariCP project:
(def data-source (doto (com.zaxxer.hikari.HikariDataSource.)
(.setJdbcUrl "my-connection-string")
(.setUsername "my-user")
(.setPassword "my-pass")))
Require the core namespace:
(require '[jnorlib-db.core :as db])
Fetch data from the database:
(with-open [mng (db/manager data-source)]
(db/exec-query! mng "select * from my_table"))
2026 CL journeyor
This program and the accompanying materials are made available under the terms of the Eclipse Public License 2.0 which is available at http://www.eclipse.org/legal/epl-2.0.
This Source Code may also be made available under the following Secondary Licenses when the conditions for such availability set forth in the Eclipse Public License, v. 2.0 are satisfied: GNU General Public License as published by the Free Software Foundation, either version 2 of the License, or (at your option) any later version, with the GNU Classpath Exception which is available at https://www.gnu.org/software/classpath/license.html.
Can you improve this documentation?Edit on GitHub
cljdoc builds & hosts documentation for Clojure/Script libraries
| Ctrl+k | Jump to recent docs |
| ← | Move to previous article |
| → | Move to next article |
| Ctrl+/ | Jump to the search field |