PreparedStatement and a vector containing parameter groups,
i.e., a vector of vector of parameters, use
.addBatch to add each group
of parameters to the prepared statement (via
set-parameters) and then
.executeBatch. A vector of update counts is returned.
An options hash map may also be provided, containing
determines how to partition the parameter groups for submission to the
database. If omitted, all groups will be submitted as a single command.
If you expect the update counts to be larger than
you can specify
:large true and
.executeLargeBatch will be called
Returns a Clojure vector of update counts.
java.sql.BatchUpdateException if any part of the batch fails.
You may be able to call
.getUpdateCounts on that exception object to
get more information about which parts succeeded and which failed.
For additional caveats and database-specific options you may need, see:
Not all databases support batch execution.