clojure.java.jdbc
A Clojure interface to SQL databases via JDBC
clojure.java.jdbc provides a simple abstraction for CRUD (create, read, update, delete) operations on a SQL database, along with basic transaction support. Basic DDL operations are also supported (create table, drop table, access to table metadata).
Maps are used to represent records, making it easy to store and retrieve data. Results can be processed using any standard sequence operations.
For most operations, Java's PreparedStatement is used so your SQL and parameters can be represented as simple vectors where the first element is the SQL string, with ? for each parameter, and the remaining elements are the parameter values to be substituted. In general, operations return the number of rows affected, except for a single record insert where any generated keys are returned (as a map).
For more documentation, see:
http://clojure-doc.org/articles/ecosystem/java_jdbc/home.html
As of release 0.3.0, the API has undergone a major overhaul and most of the original API has been deprecated in favor of a more idiomatic API. The original API has been moved to java.jdbc.deprecated for backward compatibility but it will be removed before a 1.0.0 release.
A Clojure interface to SQL databases via JDBC clojure.java.jdbc provides a simple abstraction for CRUD (create, read, update, delete) operations on a SQL database, along with basic transaction support. Basic DDL operations are also supported (create table, drop table, access to table metadata). Maps are used to represent records, making it easy to store and retrieve data. Results can be processed using any standard sequence operations. For most operations, Java's PreparedStatement is used so your SQL and parameters can be represented as simple vectors where the first element is the SQL string, with ? for each parameter, and the remaining elements are the parameter values to be substituted. In general, operations return the number of rows affected, except for a single record insert where any generated keys are returned (as a map). For more documentation, see: http://clojure-doc.org/articles/ecosystem/java_jdbc/home.html As of release 0.3.0, the API has undergone a major overhaul and most of the original API has been deprecated in favor of a more idiomatic API. The original API has been moved to java.jdbc.deprecated for backward compatibility but it will be removed before a 1.0.0 release.
- as-sql-name
- Connectable
- create-table-ddl
- db-connection
- db-do-commands
- db-do-prepared
- db-do-prepared-return-keys
- db-find-connection
- db-is-rollback-only
- db-query-with-resultset
- db-set-rollback-only!
- db-transaction
- db-transaction*
- db-unset-rollback-only!
- delete!
- drop-table-ddl
- execute!
- get-connection
- insert!
- IResultSetReadColumn
- ISQLParameter
- ISQLValue
- metadata-query
- metadata-result
- prepare-statement
- print-sql-exception
- print-sql-exception-chain
- print-update-counts
- query
- quoted
- result-set-seq
- string-array
- update!
- when-available
- with-db-connection
- with-db-metadata
- with-db-transaction
clojure.java.jdbc.deprecated
A Clojure interface to SQL databases via JDBC
This namespace contains the old API (0.2.3) which was deprecated in the 0.3.0 release and is provided for backward compatibility. This API will be removed completely before a 1.0.0 release so will need to migrate code to the new API before that release.
clojure.java.jdbc provides a simple abstraction for CRUD (create, read, update, delete) operations on a SQL database, along with basic transaction support. Basic DDL operations are also supported (create table, drop table, access to table metadata).
Maps are used to represent records, making it easy to store and retrieve data. Results can be processed using any standard sequence operations.
For most operations, Java's PreparedStatement is used so your SQL and parameters can be represented as simple vectors where the first element is the SQL string, with ? for each parameter, and the remaining elements are the parameter values to be substituted. In general, operations return the number of rows affected, except for a single record insert where any generated keys are returned (as a map).
A Clojure interface to SQL databases via JDBC This namespace contains the old API (0.2.3) which was deprecated in the 0.3.0 release and is provided for backward compatibility. This API will be removed completely before a 1.0.0 release so will need to migrate code to the new API before that release. clojure.java.jdbc provides a simple abstraction for CRUD (create, read, update, delete) operations on a SQL database, along with basic transaction support. Basic DDL operations are also supported (create table, drop table, access to table metadata). Maps are used to represent records, making it easy to store and retrieve data. Results can be processed using any standard sequence operations. For most operations, Java's PreparedStatement is used so your SQL and parameters can be represented as simple vectors where the first element is the SQL string, with ? for each parameter, and the remaining elements are the parameter values to be substituted. In general, operations return the number of rows affected, except for a single record insert where any generated keys are returned (as a map).
- as-identifier
- as-key
- as-keyword
- as-named-identifier
- as-named-keyword
- as-quoted-identifier
- as-quoted-str
- as-str
- connection
- create-table
- create-table-ddl
- delete-rows
- do-commands
- do-prepared
- do-prepared-return-keys
- drop-table
- find-connection
- insert-record
- insert-records
- insert-rows
- insert-values
- is-rollback-only
- prepare-statement
- print-sql-exception
- print-sql-exception-chain
- print-update-counts
- resultset-seq
- set-rollback-only
- transaction
- transaction*
- update-or-insert-values
- update-values
- with-connection
- with-connection*
- with-naming-strategy
- with-query-results
- with-query-results*
- with-quoted-identifiers
cljdoc is a website building & hosting documentation for Clojure/Script libraries
× close