Top Description Methods
org.jooq

public Interface MergeValuesStep22<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, T22>

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

Method Summary

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

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, Field<T22> value22)

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 Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> 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, 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, T22 value22)

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, Field<T22> value22)

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