@seancorfield I have this a go, works well 🙂

I notice you are creating a connection using the PreparedStatement, will that play nicely with using execute-batch! in a transaction?

(jdbc/with-transaction 
      [tx datasource]                       
      (prepare/execute-batch! (jdbc/prepare tx [statement] {:return-keys true})
                              rows
                              {:batch-size            100
                               :return-generated-keys true
                               :builder-fn rs/as-unqualified-maps}))

@sofra Remember that you need to close any PS you create, so use (with-open [ps (jdbc/prepare tx ...)] (prepare/execute-batch! ps ...))

"creating a connection using the PreparedStatement" -- no, calling .getConnection on a PreparedStatement simply returns the Connection it was created from, i.e., tx in your example code.

great thanks so much @seancorfield 🙏