#1295 is implemented on GitHub: https://sourceforge.net/apps/trac/jooq/ticket/1295
I finally decided not to add several overloaded Factory.insertIgnoreInto() methods, but added the possibility to specify an .onDuplicateKeyIgnore() clause, similar to the pre-existing .onDuplicateKeyUpdate() clause - the two mutually excluding each other. This keeps the public API a bit more concise, while at the same time being more consistent with pre-existing functionality, both in the INSERT syntax, as well as in the Loader API. This "synthetic" ON DUPLICATE KEY IGNORE clause will render the following: MySQL: INSERT IGNORE INTO... CUBRID: INSERT INTO .. ON DUPLICATE KEY UPDATE [any-field] = [any-field] DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere: MERGE INTO .. dst USING (SELECT 1) src ON [dst.key] = [src.key] WHEN NOT MATCHED THEN INSERT .. This will be integration tested and released with jOOQ 2.3.0 Cheers Lukas
