Top Description Methods
org.jooq

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

Known Direct Subinterfaces
org.jooq.MergeKeyStep3
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, field3)
      .key(id)
      .values(field1, field2, field3)
      .execute();
Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull Merge<R>
select(Select<? extends Record3<T1, T2, T3>> 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, Field).

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

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, Field<T3> value3)

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 Record3<T1, T2, T3>> 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, 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, T3 value3)

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, Field<T3> value3)

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