Top Description Methods
org.jooq

public Interface MergeValuesStep2<R extends org.jooq.Record, T1, T2>

Known Direct Subinterfaces
org.jooq.MergeKeyStep2
Annotations
@Deprecated
forRemoval:true
since:3.14
Static Imports
org.jooq.SQLDialect.*

Deprecated

for removal since 3.14.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext#mergeInto(Table)

This type is used for the H2-specific variant of the Merge's DSL API.

Example: 


using(configuration)
      .mergeInto(table, field1, field2)
      .key(id)
      .values(field1, field2)
      .execute();
Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull Merge<R>
select(Select<? extends Record2<T1, T2>> select)

Deprecated for removal since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext#mergeInto(Table)
Use a SELECT statement as the source of values for the MERGE statement

This variant of the MERGE … SELECT statement expects a select returning exactly as many fields as specified previously in the INTO clause: DSLContext#mergeInto(Table, Field, Field).

public @NotNull Merge<R>
values(T1 value1, T2 value2)

Deprecated for removal since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext#mergeInto(Table)
Specify a VALUES clause.
public @NotNull Merge<R>
values(Field<T1> value1, Field<T2> value2)

Deprecated for removal since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext#mergeInto(Table)
Specify a VALUES clause.
public @NotNull Merge<R>
values(Collection<?> values)

Deprecated for removal since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext#mergeInto(Table)
Specify a VALUES clause.

Method Detail

selectback to summary
public @NotNull Merge<R> select(Select<? extends Record2<T1, T2>> select)

Deprecated

for removal since 3.14.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext#mergeInto(Table)

Use a SELECT statement as the source of values for the MERGE statement

This variant of the MERGE … SELECT statement expects a select returning exactly as many fields as specified previously in the INTO clause: DSLContext#mergeInto(Table, Field, Field).

Annotations
@Deprecated
forRemoval:true
since:3.14
@NotNull
@CheckReturnValue
@Support:CUBRID, FIREBIRD, H2, HSQLDB, POSTGRES
valuesback to summary
public @NotNull Merge<R> values(T1 value1, T2 value2)

Deprecated

for removal since 3.14.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext#mergeInto(Table)

Specify a VALUES clause.

Annotations
@Deprecated
forRemoval:true
since:3.14
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
valuesback to summary
public @NotNull Merge<R> values(Field<T1> value1, Field<T2> value2)

Deprecated

for removal since 3.14.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext#mergeInto(Table)

Specify a VALUES clause.

Annotations
@Deprecated
forRemoval:true
since:3.14
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB
valuesback to summary
public @NotNull Merge<R> values(Collection<?> values)

Deprecated

for removal since 3.14.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext#mergeInto(Table)

Specify a VALUES clause.

Annotations
@Deprecated
forRemoval:true
since:3.14
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB