next.jdbc.prepare — com.github.seancorfield/next.jdbc 1.3.909

Mostly an implementation namespace for how PreparedStatement objects are created by the next generation java.jdbc library.

set-parameters is public and may be useful if you have a PreparedStatement that you wish to reuse and (re)set the parameters on it.

Defines the SettableParameter protocol for converting Clojure values to database-specific values.

See also https://cljdoc.org/d/com.github.seancorfield/next.jdbc/CURRENT/api/next.jdbc.date-time for implementations of SettableParameter that provide automatic conversion of Java Time objects to SQL data types.

See also https://cljdoc.org/d/com.github.seancorfield/next.jdbc/CURRENT/api/next.jdbc.types for as-xxx functions that provide per-instance implementations of SettableParameter for each of the standard java.sql.Types values.

create clj

(create con
        sql
        params
        {:keys [return-keys result-type concurrency cursors fetch-size max-rows
                timeout]
         :as opts})

This is an implementation detail -- use next.jdbc/prepare instead.

Given a Connection, a SQL string, some parameters, and some options, return a PreparedStatement representing that.

set-parameters clj

(set-parameters ps params)

Given a PreparedStatement and a vector of parameter values, update the PreparedStatement with those parameters and return it.

SettableParameter clj protocol

Protocol for setting SQL parameters in statement objects, which can convert from Clojure values. The default implementation just calls .setObject on the parameter value. It can be extended to use other methods of PreparedStatement to convert and set parameter values. Extension via metadata is supported.

set-parameter clj

(set-parameter val stmt ix)

Convert a Clojure value into a SQL value and store it as the ix'th parameter in the given SQL statement object.

statement clj

(statement con)

(statement con
           {:keys [result-type concurrency cursors fetch-size max-rows timeout]
            :as opts})

Given a Connection and some options, return a Statement.