> For the complete documentation index, see [llms.txt](https://wiki.dewaka.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://wiki.dewaka.com/programming-languages/java/libraries/jooq.md).

# JOOQ

## JOOQ Usage

* `fetchOne` - this is a pretty useful method to get a single result also making sure that there is only one result from the constructed query.
  * Difference between `fetchOne` and `fetchMany` - <https://stackoverflow.com/questions/30307448/jooq-difference-between-fetchany-and-fetchone>
* Ignore duplicates on inserts - <https://www.jooq.org/doc/3.12/manual/sql-building/sql-statements/insert-statement/insert-on-duplicate-key/#N5454E>
* Update on duplicates - <https://www.jooq.org/doc/3.12/manual/sql-building/sql-statements/insert-statement/insert-on-duplicate-key/>