Top Description Methods
org.jooq

public Interface MergeValuesStep21<R extends org.jooq.Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

Known Direct Subinterfaces
org.jooq.MergeKeyStep21
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, .., field20, field21)
      .key(id)
      .values(value1, value2, value3, .., value20, value21)
      .execute();
Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull Merge<R>
select(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> 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, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field).

public @NotNull Merge<R>
values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17, T18 value18, T19 value19, T20 value20, T21 value21)

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, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17, Field<T18> value18, Field<T19> value19, Field<T20> value20, Field<T21> value21)

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 Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> 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, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, 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, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17, T18 value18, T19 value19, T20 value20, T21 value21)

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, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17, Field<T18> value18, Field<T19> value19, Field<T20> value20, Field<T21> value21)

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