Thank you. I closed the question on SO, and ended up using the 'force static statement' approach described here: https://www.jooq.org/doc/3.9/manual/sql-building/dsl-context/custom-settings/
My typical JOOQ use case is like this (for both REST endpoint or fat desktop clients) 1. fetch record from SQL (hand written, with bindings placeholder if needed, e.g. "select * from book where book_id = ?") 2. fetch into a pojo (can be jooq-generated, can be custom) 3. manipulate the pojo 4. when saving, create a new Record (e.g. BookRecord), copy data back from pojo 5. execute insert/update accordingly, taking care of the surrogate primary key generation manually with a separate call (e.g. in master detail situation) Do you see anything that would bite me if i use the 'force static statement' setting globally? >From my limited testing everything seems to work okay. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
