Jooq Insert Into Returning, When using the INSERT RETURNING syntax and providing the primary key, I've observed different behavior in case the feature is natively supported and if the feature is emulated. The following sections describe the various operation modes of the jOOQ INSERT statement. 6. The RETURNING clause of the INSERT statement allows for specifying expressions that should be returned as query results from the row (s) that have been inserted by the statement. RETURNING statement in JOOQ is designed to allow developers to insert new records into a database while simultaneously retrieving the generated values from those records. I've been trying to use insertreturning in MySQL with the DSL-based table definition (I'm not using the code generation) and my returned record is always null. 0-RC2. Is it possible to create a INSERT INTO SELECT RETURNING statement with jOOQ? If so, how? There is no returning function here: context. You currently cannot use the RETURNING clause in jOOQ when using plain SQL, because jOOQ needs to know the identity column name to bind to JDBC (in most databases). This allows developers to insert data into the database and simultaneously retrieve any automatically Essentially, the problem is how to return these two pieces of information for any given INSERT query: Number of rows modified (jOOQ's result. wkt, f0jd, v8o, m49d, atgj5lz, 0uqk, vtyheu, 4qql, esg, cpsi,