sql

All things SQL and JDBC...
2020-07-23T06:10:05.315800Z

@seancorfield I have this a go, works well 🙂

2020-07-23T06:12:13.316Z

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

2020-07-23T06:12:27.316200Z

(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}))