Hello Lukas, Thanks. BTW when do you expect to release 2.3?
Kind regards ----- Original Message ----- From: "Lukas Eder" <[email protected]> To: [email protected] Cc: "abel birya" <[email protected]> Sent: Tuesday, May 1, 2012 11:10:59 AM Subject: Re: JOOQ INSERT IGNORE #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
