Jooq batch insert/delete returning number of rows affected?

Question

I am trying to batch insert and batch delete a large list of objects using JOOQ and Postgres, and get the number of rows inserted/deleted. I see there are insert(Collection

objects) and delete(Collection

objects) provided in JOOQ, however they don't return anything. From searching online I see there's also batchStore that might return the number of inserted rows, which I am going to try. But what about delete?

Thanks!

user_521799 · Answer

I'm assuming that you meant these methods that don't return anything?

And by batchStore you mean DSLContext.batchStore(). So, would your answer just be to use DSLContext.batchDelete()?

Jooq batch insert/delete returning number of rows affected?

1 Answers