Hello Ian, > Ok, it seems that I wasn't following the example in the documentation > closely enough for .onDuplicateKeyUpdate() - it appears to be working now
Hmm, yes, the non-DSL InsertQuery.onDuplicateKeyUpdate() flag may not be self-explanatory. I'll fix the Javadoc on that method, to indicate, that an update clause should be specified, too. > (although not as speedily as I had hoped - need to play around a bit). That's what I thought. jOOQ has all the knowledge needed to decide whether to execute an insert or update statement. Letting the database check primary keys might add some additional overhead... Cheers Lukas
