Bulking
Writing bulk queries in jOOQ is just a matter of using the jOOQ DSL API. For instance, a bulk insert SQL looks like this:
INSERT IGNORE INTO `classicmodels`.`order` ( Â Â `order_date`, `required_date`, `shipped_date`, Â Â `status`, `comments`, `customer_number`, `amount`) VALUES (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), Â Â Â Â Â Â Â (?, ?, ?, ?, ?, ?, ?)
This can be expressed in jOOQ by chaining the values() call:
ctx.insertInto(ORDER) Â Â Â .columns(ORDER.ORDER_DATE, ORDER.REQUIRED_DATE, Â Â Â Â Â Â Â Â Â Â Â Â ORDER.SHIPPED_DATE, ORDER.STATUS, Â Â Â Â Â Â Â Â Â Â Â Â ORDER.COMMENTS,ORDER.CUSTOMER_NUMBER, Â Â Â Â Â Â Â Â Â Â Â Â ORDER.AMOUNT) Â Â Â Â .values(LocalDate.of(2004,10,22), LocalDate.of(2004,10,23), Â Â Â Â LocalDate...
