org.jooq
Interface InsertReturningStep<R extends Record>

All Known Subinterfaces:

InsertOnDuplicateStep<R>, InsertSetMoreStep<R>, InsertValuesStep<R>

public interface InsertReturningStep<R extends Record>

This type is used for the Insert's DSL API.

Example:

 Factory create = new Factory();

 TableRecord record =
 create.insertInto(table, field1, field2)
       .values(value1, value2)
       .returning(field1)
       .fetchOne();
 

This implemented differently for every dialect:

• Postgres has native support for INSERT .. RETURNING clauses
• HSQLDB, Oracle, and DB2 JDBC drivers allow for retrieving any table column as "generated key" in one statement
• Derby, H2, Ingres, MySQL, SQL Server only allow for retrieving IDENTITY column values as "generated key". If other fields are requested, a second statement is issued. Client code must assure transactional integrity between the two statements.
• Sybase and SQLite allow for retrieving IDENTITY values as @@identity or last_inserted_rowid() values. Those values are fetched in a separate SELECT statement. If other fields are requested, a second statement is issued. Client code must assure transactional integrity between the two statements.

Author:

Lukas Eder

Method Summary

InsertResultStep<R>	returning() Configure the INSERT statement to return all fields in R.
InsertResultStep<R>	returning(Collection<? extends Field<?>> fields) Configure the INSERT statement to return a list of fields in R.
InsertResultStep<R>	returning(Field<?>... fields) Configure the INSERT statement to return a list of fields in R.

Method Detail

returning

InsertResultStep<R> returning()

Configure the INSERT statement to return all fields in R.

See Also:

InsertResultStep

returning

InsertResultStep<R> returning(Field<?>... fields)

Configure the INSERT statement to return a list of fields in R.

Parameters:

fields - Fields to be returned

See Also:

InsertResultStep

returning

InsertResultStep<R> returning(Collection<? extends Field<?>> fields)

Configure the INSERT statement to return a list of fields in R.

Parameters:

fields - Fields to be returned

See Also:

InsertResultStep