search

jklingsporn / vertx-jooq

A jOOQ-CodeGenerator to create vertx-ified DAOs and POJOs.
MIT License
385 stars 53 forks source link

How do batch update? #178

Closed nkss7 closed 3 years ago

nkss7 commented 3 years ago

Hi! Thx for realy good lib, but how i can batch update? Do i should use approach like generated dao's insert(collection) method? '

jklingsporn commented 3 years ago

If you are just updating a single value per entity it might be best to craft a query using a CASE ... WHEN-statement as described here: https://stackoverflow.com/a/62879490/1033887 (paragraph Running a single bulk statement)

vertx-jooq does not support other native batch-operations from jOOQ.