next.jbc Options

This section documents all of the options that are supported by all of the functions in next.jdbc. Nearly every function accepts an optional hash map as the last argument, that can control many of the behaviors of the library.

The most general options are described first, followed by more specific options that apply only to certain functions.

Datasources and Connections

Although get-datasource does not accept options, the "db spec" hash map passed in may contain the following options:

• dbtype -- a string that identifies the type of JDBC database being used,
• dbname -- a string that identifies the name of the actual database being used,
• host -- an optional string that identifies the IP address or hostname of the server on which the database is running; the default is "127.0.0.1",
• port -- an optional integer that identifies the port on which the database is running; for common database types, next.jdbc knows the default so this should only be needed for non-standard setups or "exotic" database types,
• classname -- an optional string that identifies the name of the JDBC driver class to be used for the connection; for common database types, next.jdbc knows the default so this should only be needed for "exotic" database types,
• user -- an optional string that identifies the database username to be used when authenticating,
• password -- an optional string that identifies the database password to be used when authenticating.

Any additional keys provided in the "db spec" will be passed to the JDBC driver as Properties when each connection is made.

Any path that calls get-connection will accept the following options:

• :auto-commit -- a Boolean that determines whether operations on this connection should be automatically committed (the default, true) or not; note that setting :auto-commit false is commonly required when you want to stream result set data from a query (along with fetch size etc -- see below),
• :read-only -- a Boolean that determines whether the operations on this connection should be read-only or not (the default, false).

If you need additional options set on a connection, you can either use Java interop to set them directly, or provide them as part of the "db spec" hash map passed to get-datasource (although then they will apply to all connections obtained from that datasource).

Generating SQL

The "friendly" SQL functions all accept the following options:

• :table-fn -- the quoting function to be used on the string that identifies the table name, if provided,
• :column-fn -- the quoting function to be used on any string that identifies a column name, if provided.

Generating Rows and Result Sets

Any function that might realize a row or a result set will accept:

• :gen-fn -- a function that implements the RowBuilder and ResultSetBuilder protocols; strictly speaking, reducible! and execute-one! only need RowBuilder to be implemented (and reducible! only needs that if it actually has to realize a row) but most generation functions will implement both for ease of use.

Prepared Statements

Any function that creates a PreparedStatement will accept the following options:

• :concurrency -- a keyword that specifies the concurrency level: :read-only, :updatable,
• :cursors -- a keyword that specifies whether cursors should be closed or held over a commit: :close, :hold,
• :fetch-size -- an integer that guides the JDBC driver in terms of how many rows to fetch at once; it is common to set :fetch-size to a negative value in order to trigger streaming of result sets -- some JDBC drivers require additional options to be set on the connection as well,
• :max-rows -- an integer that tells the JDBC driver to limit result sets to this many rows,
• :result-type -- a keyword that affects how the ResultSet can be traversed: :forward-only, :scroll-insensitive, :scroll-sensitive,
• :return-keys -- a truthy value asks that the JDBC driver return any generated keys created by the operation; it can be true or it can be a vector of keywords identifying column names that should be returned,
• :timeout -- an integer that specifies the timeout allowed for SQL operations.

Not all databases or drivers support all of these options, or all values for any given option. If :return-keys is a vector of column names and that is not supported, next.jdbc will attempt a generic "return generated keys" option instead. If that is not supported, next.jdbc will fall back to a regular SQL operation. If other options are not supported, you may get a SQLException.

Transactions

The transact function and with-transaction macro accept the following options:

• :isolation -- a keyword that identifies the isolation to be used for this transaction: :none, :read-committed, :read-uncommitted, :repeatedable-read, or :serializable; these represent increasingly strict levels of transaction isolation and may not all be available depending on the database and/or JDBC driver being used,
• :read-only -- a Boolean that indicates whether the transaction should be read-only or not (the default),
• :rollback-only -- a Boolean that indicates whether the transaction should commit on success (the default) or rollback.

<: Transaction | Migration from clojure.java.jdbc :>