Top Description Methods
org.jooq

public Interface MergeValuesStep10<R extends org.jooq.Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

Known Direct Subinterfaces
org.jooq.MergeKeyStep10
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, .., field9, field10)
      .key(id)
      .values(value1, value2, value3, .., value9, value10)
      .execute();
Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull Merge<R>
select(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> 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).

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)

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)

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 Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> 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).

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)

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)

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