org.jooq.impl

Class DefaultDSLContext

java.lang.Object

org.jooq.impl.DefaultDSLContext

All Implemented Interfaces:

Serializable, DSLContext

public class DefaultDSLContext
extends Object
implements DSLContext, Serializable

Author:

Lukas Eder

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
DefaultDSLContext(Configuration configuration)
DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect)
DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings)
DefaultDSLContext(Connection connection, SQLDialect dialect)
DefaultDSLContext(Connection connection, SQLDialect dialect, Settings settings)
DefaultDSLContext(DataSource datasource, SQLDialect dialect)
DefaultDSLContext(DataSource datasource, SQLDialect dialect, Settings settings)
DefaultDSLContext(SQLDialect dialect)
DefaultDSLContext(SQLDialect dialect, Settings settings)

Method Summary

Methods

Modifier and Type	Method and Description
void	attach(Attachable... attachables) Attach this DSLContext's underlying DSLContext.configuration() to some attachables.
void	attach(Collection<? extends Attachable> attachables) Attach this DSLContext's underlying DSLContext.configuration() to some attachables.
Batch	batch(Collection<? extends Query> queries) Execute a set of queries in batch mode (without bind values).
Batch	batch(Query... queries) Execute a set of queries in batch mode (without bind values).
BatchBindStep	batch(Query query) Execute a set of queries in batch mode (with bind values).
Batch	batch(Query query, Object[]... bindings) Execute a set of queries in batch mode (with bind values).
Batch	batch(String... queries) Execute a set of queries in batch mode (without bind values).
BatchBindStep	batch(String sql) Execute a set of queries in batch mode (with bind values).
Batch	batch(String sql, Object[]... bindings) Execute a set of queries in batch mode (with bind values).
Batch	batchDelete(Collection<? extends UpdatableRecord<?>> records) Execute a set of DELETE in batch mode (with bind values).
Batch	batchDelete(UpdatableRecord<?>... records) Execute a set of DELETE queries in batch mode (with bind values).
Batch	batchInsert(Collection<? extends UpdatableRecord<?>> records) Execute a set of INSERT queries in batch mode (with bind values).
Batch	batchInsert(UpdatableRecord<?>... records) Execute a set of INSERT queries in batch mode (with bind values).
Batch	batchStore(Collection<? extends UpdatableRecord<?>> records) Execute a set of INSERT and UPDATE queries in batch mode (with bind values).
Batch	batchStore(UpdatableRecord<?>... records) Execute a set of INSERT and UPDATE queries in batch mode (with bind values).
Batch	batchUpdate(Collection<? extends UpdatableRecord<?>> records) Execute a set of UPDATE queries in batch mode (with bind values).
Batch	batchUpdate(UpdatableRecord<?>... records) Execute a set of UPDATE queries in batch mode (with bind values).
int	bind(QueryPart part, PreparedStatement stmt) Get a new BindContext for the context of this executor.
BindContext	bindContext(PreparedStatement stmt) Get a new BindContext for the context of this executor.
Configuration	configuration() The Configuration referenced from this DSLContext.
<T extends Number> T	currval(Sequence<T> sequence) Convenience method to fetch the CURRVAL for a sequence directly from this DSLContext's underlying JDBC Connection
<R extends Record> DeleteWhereStep<R>	delete(Table<R> table) Create a new DSL delete statement.
<R extends Record> DeleteQuery<R>	deleteQuery(Table<R> table) Create a new DeleteQuery
int	execute(Query query) Execute a Query in the context of this executor.
int	execute(String sql) Execute a query holding plain SQL.
int	execute(String sql, Object... bindings) Execute a new query holding plain SQL.
int	execute(String sql, QueryPart... parts) Execute a new query holding plain SQL.
<R extends UpdatableRecord<R>> int	executeDelete(R record) Delete a record from a table.
<R extends TableRecord<R>,T> int	executeDelete(R record, Condition condition) Delete a record from a table.
<R extends TableRecord<R>> int	executeInsert(R record) Insert one record.
<R extends UpdatableRecord<R>> int	executeUpdate(R record) Update a table.
<R extends TableRecord<R>,T> int	executeUpdate(R record, Condition condition) Update a table.
List<Object>	extractBindValues(QueryPart part) Retrieve the bind values that will be bound by a given QueryPart.
Param<?>	extractParam(QueryPart part, String name) Get a named parameter from a QueryPart, provided its name.
Map<String,Param<?>>	extractParams(QueryPart part) Get a Map of named parameters.
<R extends Record> Result<R>	fetch(ResultQuery<R> query) Execute a ResultQuery in the context of this executor and return results.
Result<Record>	fetch(ResultSet rs) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Result<Record>	fetch(ResultSet rs, Class<?>... types) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Result<Record>	fetch(ResultSet rs, DataType<?>... types) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Result<Record>	fetch(ResultSet rs, Field<?>... fields) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Result<Record>	fetch(String sql) Execute a new query holding plain SQL.
Result<Record>	fetch(String sql, Object... bindings) Execute a new query holding plain SQL.
Result<Record>	fetch(String sql, QueryPart... parts) Execute a new query holding plain SQL.
<R extends Record> Result<R>	fetch(Table<R> table) Execute and return all records for SELECT * FROM [table].
<R extends Record> Result<R>	fetch(Table<R> table, Condition condition) Execute and return all records for SELECT * FROM [table] WHERE [condition] .
<R extends Record> R	fetchAny(Table<R> table) Execute and return zero or one record for SELECT * FROM [table] LIMIT 1.
<R extends Record> R	fetchAny(Table<R> table, Condition condition) Execute and return zero or one record for SELECT * FROM [table] WHERE [condition] LIMIT 1.
int	fetchCount(Select<?> query) Execute a Select query in the context of this executor and return a COUNT(*) value.
Result<Record>	fetchFromCSV(String string) Fetch all data from a CSV string.
Result<Record>	fetchFromCSV(String string, char delimiter) Fetch all data from a CSV string.
Result<Record>	fetchFromStringData(List<String[]> data) Fetch all data from a list of strings.
Result<Record>	fetchFromStringData(String[]... data) Fetch all data from a list of strings.
Result<Record>	fetchFromTXT(String string) Fetch all data from a formatted string.
Result<Record>	fetchFromTXT(String string, String nullLiteral) Fetch all data from a formatted string.
<R extends Record> Cursor<R>	fetchLazy(ResultQuery<R> query) Execute a ResultQuery in the context of this executor and return a cursor.
Cursor<Record>	fetchLazy(ResultSet rs) Wrap a JDBC ResultSet into a jOOQ Cursor.
Cursor<Record>	fetchLazy(ResultSet rs, Class<?>... types) Wrap a JDBC ResultSet into a jOOQ Cursor.
Cursor<Record>	fetchLazy(ResultSet rs, DataType<?>... types) Wrap a JDBC ResultSet into a jOOQ Cursor.
Cursor<Record>	fetchLazy(ResultSet rs, Field<?>... fields) Wrap a JDBC ResultSet into a jOOQ Cursor.
Cursor<Record>	fetchLazy(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.
Cursor<Record>	fetchLazy(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.
Cursor<Record>	fetchLazy(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.
<R extends Record> Cursor<R>	fetchLazy(Table<R> table) Execute and return all records lazily for SELECT * FROM [table].
<R extends Record> Cursor<R>	fetchLazy(Table<R> table, Condition condition) Execute and return all records lazily for SELECT * FROM [table] WHERE [condition] .
<R extends Record> List<Result<Record>>	fetchMany(ResultQuery<R> query) Execute a ResultQuery in the context of this executor and return a cursor.
List<Result<Record>>	fetchMany(String sql) Execute a new query holding plain SQL, possibly returning several result sets.
List<Result<Record>>	fetchMany(String sql, Object... bindings) Execute a new query holding plain SQL, possibly returning several result sets.
List<Result<Record>>	fetchMany(String sql, QueryPart... parts) Execute a new query holding plain SQL, possibly returning several result sets.
<R extends Record> R	fetchOne(ResultQuery<R> query) Execute a ResultQuery in the context of this executor and return a record.
Record	fetchOne(ResultSet rs) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	fetchOne(ResultSet rs, Class<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	fetchOne(ResultSet rs, DataType<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	fetchOne(ResultSet rs, Field<?>... fields) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	fetchOne(String sql) Execute a new query holding plain SQL.
Record	fetchOne(String sql, Object... bindings) Execute a new query holding plain SQL.
Record	fetchOne(String sql, QueryPart... parts) Execute a new query holding plain SQL.
<R extends Record> R	fetchOne(Table<R> table) Execute and return zero or one record for SELECT * FROM [table].
<R extends Record> R	fetchOne(Table<R> table, Condition condition) Execute and return zero or one record for SELECT * FROM [table] WHERE [condition] .
<R extends Record> InsertSetStep<R>	insertInto(Table<R> into) Create a new DSL insert statement.
<R extends Record> InsertValuesStepN<R>	insertInto(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.
<R extends Record> InsertValuesStepN<R>	insertInto(Table<R> into, Field<?>... fields) Create a new DSL insert statement.
<R extends Record,T1> InsertValuesStep1<R,T1>	insertInto(Table<R> into, Field<T1> field1) Create a new DSL insert statement.
<R extends Record,T1,T2> InsertValuesStep2<R,T1,T2>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2) Create a new DSL insert statement.
<R extends Record,T1,T2,T3> InsertValuesStep3<R,T1,T2,T3>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4> InsertValuesStep4<R,T1,T2,T3,T4>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5> InsertValuesStep5<R,T1,T2,T3,T4,T5>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6> InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7> InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Create a new DSL insert statement.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new DSL insert statement.
<R extends Record> InsertQuery<R>	insertQuery(Table<R> into) Create a new InsertQuery
BigInteger	lastID() Retrieve the last inserted ID.
<R extends TableRecord<R>> LoaderOptionsStep<R>	loadInto(Table<R> table) Create a new Loader object to load data from a CSV or XML source.
Schema	map(Schema schema) Map a schema to another one.
<R extends Record> Table<R>	map(Table<R> table) Map a table to another one.
<R extends Record> MergeUsingStep<R>	mergeInto(Table<R> table) Create a new DSL SQL standard MERGE statement.
<R extends Record> MergeKeyStepN<R>	mergeInto(Table<R> table, Collection<? extends Field<?>> fields) Create a new DSL merge statement (H2-specific syntax)
<R extends Record> MergeKeyStepN<R>	mergeInto(Table<R> table, Field<?>... fields) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1> MergeKeyStep1<R,T1>	mergeInto(Table<R> table, Field<T1> field1) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2> MergeKeyStep2<R,T1,T2>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3> MergeKeyStep3<R,T1,T2,T3>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4> MergeKeyStep4<R,T1,T2,T3,T4>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5> MergeKeyStep5<R,T1,T2,T3,T4,T5>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6> MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7> MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
Meta	meta() Access the database meta data.
<R extends Record> R	newRecord(Table<R> table) Create a new Record that can be inserted into the corresponding table.
<R extends Record> R	newRecord(Table<R> table, Object source) Create a new pre-filled Record that can be inserted into the corresponding table.
<R extends UDTRecord<R>> R	newRecord(UDT<R> type) Create a new UDTRecord.
<R extends Record> Result<R>	newResult(Table<R> table) Create a new empty Result.
<T extends Number> T	nextval(Sequence<T> sequence) Convenience method to fetch the NEXTVAL for a sequence directly from this DSLContext's underlying JDBC Connection
Query	query(String sql) Create a new query holding plain SQL.
Query	query(String sql, Object... bindings) Create a new query holding plain SQL.
Query	query(String sql, QueryPart... parts) Create a new query holding plain SQL.
String	render(QueryPart part) Render a QueryPart in the context of this executor.
RenderContext	renderContext() Get a new RenderContext for the context of this executor.
String	renderInlined(QueryPart part) Render a QueryPart in the context of this executor, inlining all bind variables.
String	renderNamedParams(QueryPart part) Render a QueryPart in the context of this executor, rendering bind variables as named parameters.
ResultQuery<Record>	resultQuery(String sql) Create a new query holding plain SQL.
ResultQuery<Record>	resultQuery(String sql, Object... bindings) Create a new query holding plain SQL.
ResultQuery<Record>	resultQuery(String sql, QueryPart... parts) Create a new query holding plain SQL.
SelectSelectStep<Record>	select(Collection<? extends Field<?>> fields) Create a new DSL select statement.
SelectSelectStep<Record>	select(Field<?>... fields) Create a new DSL select statement.
<T1> SelectSelectStep<Record1<T1>>	select(Field<T1> field1) Create a new DSL select statement.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	select(Field<T1> field1, Field<T2> field2) Create a new DSL select statement.
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL select statement.
<T1,T2,T3,T4> SelectSelectStep<Record4<T1,T2,T3,T4>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL select statement.
<T1,T2,T3,T4,T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6> SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7> SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> SelectSelectStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new DSL select statement.
SelectSelectStep<Record1<Integer>>	selectCount() Create a new DSL select statement for COUNT(*) This creates an attached, renderable and executable SELECT statement from this DSLContext.
SelectSelectStep<Record>	selectDistinct(Collection<? extends Field<?>> fields) Create a new DSL select statement.
SelectSelectStep<Record>	selectDistinct(Field<?>... fields) Create a new DSL select statement.
<T1> SelectSelectStep<Record1<T1>>	selectDistinct(Field<T1> field1) Create a new DSL select statement.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	selectDistinct(Field<T1> field1, Field<T2> field2) Create a new DSL select statement.
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL select statement.
<T1,T2,T3,T4> SelectSelectStep<Record4<T1,T2,T3,T4>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL select statement.
<T1,T2,T3,T4,T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6> SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7> SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> SelectSelectStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Create a new DSL select statement.
<R extends Record> SelectWhereStep<R>	selectFrom(Table<R> table) Create a new DSL select statement.
SelectSelectStep<Record1<Integer>>	selectOne() Create a new DSL select statement for constant 1 literal This creates an attached, renderable and executable SELECT statement from this DSLContext.
SelectQuery<Record>	selectQuery() Create a new SelectQuery
<R extends Record> SelectQuery<R>	selectQuery(TableLike<R> table) Create a new SelectQuery
SelectSelectStep<Record1<Integer>>	selectZero() Create a new DSL select statement for constant 0 literal This creates an attached, renderable and executable SELECT statement from this DSLContext.
String	toString()
<R extends Record> TruncateIdentityStep<R>	truncate(Table<R> table) Create a new DSL truncate statement.
<R extends Record> UpdateSetFirstStep<R>	update(Table<R> table) Create a new DSL update statement.
<R extends Record> UpdateQuery<R>	updateQuery(Table<R> table) Create a new UpdateQuery

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

DefaultDSLContext

public DefaultDSLContext(SQLDialect dialect)

DefaultDSLContext

public DefaultDSLContext(SQLDialect dialect,
                 Settings settings)

DefaultDSLContext

public DefaultDSLContext(Connection connection,
                 SQLDialect dialect)

DefaultDSLContext

public DefaultDSLContext(Connection connection,
                 SQLDialect dialect,
                 Settings settings)

DefaultDSLContext

public DefaultDSLContext(DataSource datasource,
                 SQLDialect dialect)

DefaultDSLContext

public DefaultDSLContext(DataSource datasource,
                 SQLDialect dialect,
                 Settings settings)

DefaultDSLContext

public DefaultDSLContext(ConnectionProvider connectionProvider,
                 SQLDialect dialect)

DefaultDSLContext

public DefaultDSLContext(ConnectionProvider connectionProvider,
                 SQLDialect dialect,
                 Settings settings)

DefaultDSLContext

public DefaultDSLContext(Configuration configuration)

Method Detail

configuration

public Configuration configuration()

Description copied from interface: DSLContext

The Configuration referenced from this DSLContext.

Specified by:

configuration in interface DSLContext

map

public Schema map(Schema schema)

Description copied from interface: DSLContext

Map a schema to another one.

This will map a schema onto another one, depending on configured schema mapping in this DSLContext. If no applicable schema mapping can be found, the schema itself is returned.

Specified by:

map in interface DSLContext

Parameters:

schema - A schema

Returns:

The mapped schema

map

public <R extends Record> Table<R> map(Table<R> table)

Description copied from interface: DSLContext

Map a table to another one.

This will map a table onto another one, depending on configured table mapping in this DSLContext. If no applicable table mapping can be found, the table itself is returned.

Specified by:

map in interface DSLContext

Parameters:

table - A table

Returns:

The mapped table

meta

public Meta meta()

Description copied from interface: DSLContext

Access the database meta data.

This method returns a wrapper type that gives access to your JDBC connection's database meta data.

Specified by:

meta in interface DSLContext

renderContext

public RenderContext renderContext()

Description copied from interface: DSLContext

Get a new RenderContext for the context of this executor.

This will return an initialised render context as such:

• RenderContext.castMode() == DEFAULT
• Context.declareFields() == false
• Context.declareTables() == false
• RenderContext.format() == false
• RenderContext.paramType() == ParamType.INDEXED
• RenderContext.qualify() == true
• Context.subquery() == false

Specified by:

renderContext in interface DSLContext

render

public String render(QueryPart part)

Description copied from interface: DSLContext

Render a QueryPart in the context of this executor.

This is the same as calling renderContext().render(part)

Specified by:

render in interface DSLContext

Parameters:

part - The QueryPart to be rendered

Returns:

The rendered SQL

renderNamedParams

public String renderNamedParams(QueryPart part)

Description copied from interface: DSLContext

Render a QueryPart in the context of this executor, rendering bind variables as named parameters.

This is the same as calling renderContext().namedParams(true).render(part)

Specified by:

renderNamedParams in interface DSLContext

Parameters:

part - The QueryPart to be rendered

Returns:

The rendered SQL

renderInlined

public String renderInlined(QueryPart part)

Description copied from interface: DSLContext

Render a QueryPart in the context of this executor, inlining all bind variables.

This is the same as calling renderContext().inline(true).render(part)

Specified by:

renderInlined in interface DSLContext

Parameters:

part - The QueryPart to be rendered

Returns:

The rendered SQL

extractBindValues

public List<Object> extractBindValues(QueryPart part)

Description copied from interface: DSLContext

Retrieve the bind values that will be bound by a given QueryPart.

The returned List is immutable. To modify bind values, use DSLContext.extractParams(QueryPart) instead.

Specified by:

extractBindValues in interface DSLContext

extractParams

public Map<String,Param<?>> extractParams(QueryPart part)

Description copied from interface: DSLContext

Get a Map of named parameters.

The Map itself is immutable, but the Param elements allow for modifying bind values on an existing Query (or any other QueryPart).

Bind values created with DSL.val(Object) will have their bind index as name.

Specified by:

extractParams in interface DSLContext

See Also:

Param, DSL.param(String, Object)

extractParam

public Param<?> extractParam(QueryPart part,
                    String name)

Description copied from interface: DSLContext

Get a named parameter from a QueryPart, provided its name.

Bind values created with DSL.val(Object) will have their bind index as name.

Specified by:

extractParam in interface DSLContext

See Also:

Param, DSL.param(String, Object)

bindContext

public BindContext bindContext(PreparedStatement stmt)

Description copied from interface: DSLContext

Get a new BindContext for the context of this executor.

This will return an initialised bind context as such:

• Context.declareFields() == false
• Context.declareTables() == false

RenderContext for JOOQ INTERNAL USE only. Avoid referencing it directly

Specified by:

bindContext in interface DSLContext

bind

public int bind(QueryPart part,
       PreparedStatement stmt)

Description copied from interface: DSLContext

Get a new BindContext for the context of this executor.

This will return an initialised bind context as such:

• Context.declareFields() == false
• Context.declareTables() == false

RenderContext for JOOQ INTERNAL USE only. Avoid referencing it directly

Specified by:

bind in interface DSLContext

attach

public void attach(Attachable... attachables)

Description copied from interface: DSLContext

Attach this DSLContext's underlying DSLContext.configuration() to some attachables.

Specified by:

attach in interface DSLContext

attach

public void attach(Collection<? extends Attachable> attachables)

Description copied from interface: DSLContext

Attach this DSLContext's underlying DSLContext.configuration() to some attachables.

Specified by:

attach in interface DSLContext

loadInto

public <R extends TableRecord<R>> LoaderOptionsStep<R> loadInto(Table<R> table)

Description copied from interface: DSLContext

Create a new Loader object to load data from a CSV or XML source.

Specified by:

loadInto in interface DSLContext

query

public Query query(String sql)

Description copied from interface: DSLContext

Create a new query holding plain SQL. There must not be any binding variables contained in the SQL.

Example:

 String sql = "SET SCHEMA 'abc'";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

query in interface DSLContext

Parameters:

sql - The SQL

Returns:

A query wrapping the plain SQL

query

public Query query(String sql,
          Object... bindings)

Description copied from interface: DSLContext

Create a new query holding plain SQL. There must be as many bind variables contained in the SQL, as passed in the bindings parameter.

Example:

 String sql = "SET SCHEMA 'abc'";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

query in interface DSLContext

Parameters:

sql - The SQL

bindings - The bindings

Returns:

A query wrapping the plain SQL

query

public Query query(String sql,
          QueryPart... parts)

Description copied from interface: DSLContext

Create a new query holding plain SQL.

Unlike DSLContext.query(String, Object...), the SQL passed to this method should not contain any bind variables. Instead, you can pass QueryPart objects to the method which will be rendered at indexed locations of your SQL string as such:

 // The following query
 query("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));

 // Will render this SQL on an Oracle database with RenderNameStyle.QUOTED:
 select ?, 'test' from "DUAL"
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! One way to escape literals is to use DSL.name(String...) and similar methods

Specified by:

query in interface DSLContext

Parameters:

sql - The SQL clause, containing {numbered placeholders} where query parts can be injected

parts - The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:

A query wrapping the plain SQL

fetch

public Result<Record> fetch(String sql)
                     throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL.

Example (Postgres):

 String sql = "FETCH ALL IN \"\"";

Example (SQLite):

 String sql = "pragma table_info('my_table')";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fetch in interface DSLContext

Parameters:

sql - The SQL

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet

Throws:

DataAccessException - if something went wrong executing the query

fetch

public Result<Record> fetch(String sql,
                   Object... bindings)
                     throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL.

There must be as many bind variables contained in the SQL, as passed in the bindings parameter

Example (Postgres):

 String sql = "FETCH ALL IN \"\"";

Example (SQLite):

 String sql = "pragma table_info('my_table')";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fetch in interface DSLContext

Parameters:

sql - The SQL

bindings - The bindings

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet

Throws:

DataAccessException - if something went wrong executing the query

fetch

public Result<Record> fetch(String sql,
                   QueryPart... parts)
                     throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL.

Unlike DSLContext.fetch(String, Object...), the SQL passed to this method should not contain any bind variables. Instead, you can pass QueryPart objects to the method which will be rendered at indexed locations of your SQL string as such:

 // The following query
 fetch("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));

 // Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
 select ?, 'test' from "DUAL"
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! One way to escape literals is to use DSL.name(String...) and similar methods

Specified by:

fetch in interface DSLContext

Parameters:

sql - The SQL clause, containing {numbered placeholders} where query parts can be injected

parts - The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:

The results from the executed query

Throws:

DataAccessException - if something went wrong executing the query

fetchLazy

public Cursor<Record> fetchLazy(String sql)
                         throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL and "lazily" return the generated result.

The returned Cursor holds a reference to the executed PreparedStatement and the associated ResultSet. Data can be fetched (or iterated over) lazily, fetching records from the ResultSet one by one.

Example (Postgres):

 String sql = "FETCH ALL IN \"\"";

Example (SQLite):

 String sql = "pragma table_info('my_table')";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fetchLazy in interface DSLContext

Parameters:

sql - The SQL

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet

Throws:

DataAccessException - if something went wrong executing the query

fetchLazy

public Cursor<Record> fetchLazy(String sql,
                       Object... bindings)
                         throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL and "lazily" return the generated result.

There must be as many bind variables contained in the SQL, as passed in the bindings parameter

The returned Cursor holds a reference to the executed PreparedStatement and the associated ResultSet. Data can be fetched (or iterated over) lazily, fetching records from the ResultSet one by one.

Example (Postgres):

 String sql = "FETCH ALL IN \"\"";

Example (SQLite):

 String sql = "pragma table_info('my_table')";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fetchLazy in interface DSLContext

Parameters:

sql - The SQL

bindings - The bindings

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet

Throws:

DataAccessException - if something went wrong executing the query

fetchLazy

public Cursor<Record> fetchLazy(String sql,
                       QueryPart... parts)
                         throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL and "lazily" return the generated result.

The returned Cursor holds a reference to the executed PreparedStatement and the associated ResultSet. Data can be fetched (or iterated over) lazily, fetching records from the ResultSet one by one.

Unlike DSLContext.fetchLazy(String, Object...), the SQL passed to this method should not contain any bind variables. Instead, you can pass QueryPart objects to the method which will be rendered at indexed locations of your SQL string as such:

 // The following query
 fetchLazy("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));

 // Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
 select ?, 'test' from "DUAL"
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! One way to escape literals is to use DSL.name(String...) and similar methods

Specified by:

fetchLazy in interface DSLContext

Parameters:

sql - The SQL clause, containing {numbered placeholders} where query parts can be injected

parts - The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:

The results from the executed query

Throws:

DataAccessException - if something went wrong executing the query

fetchMany

public List<Result<Record>> fetchMany(String sql)
                               throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL, possibly returning several result sets.

Example (Sybase ASE):

 String sql = "sp_help 'my_table'";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fetchMany in interface DSLContext

Parameters:

sql - The SQL

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet

Throws:

DataAccessException - if something went wrong executing the query

fetchMany

public List<Result<Record>> fetchMany(String sql,
                             Object... bindings)
                               throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL, possibly returning several result sets.

There must be as many bind variables contained in the SQL, as passed in the bindings parameter

Example (Sybase ASE):

 String sql = "sp_help 'my_table'";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fetchMany in interface DSLContext

Parameters:

sql - The SQL

bindings - The bindings

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet

Throws:

DataAccessException - if something went wrong executing the query

fetchMany

public List<Result<Record>> fetchMany(String sql,
                             QueryPart... parts)
                               throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL, possibly returning several result sets.

Unlike DSLContext.fetchMany(String, Object...), the SQL passed to this method should not contain any bind variables. Instead, you can pass QueryPart objects to the method which will be rendered at indexed locations of your SQL string as such:

 // The following query
 fetchMany("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));

 // Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
 select ?, 'test' from "DUAL"
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! One way to escape literals is to use DSL.name(String...) and similar methods

Specified by:

fetchMany in interface DSLContext

Parameters:

sql - The SQL clause, containing {numbered placeholders} where query parts can be injected

parts - The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:

The results from the executed query

Throws:

DataAccessException - if something went wrong executing the query

fetchOne

public Record fetchOne(String sql)
                throws DataAccessException,
                       InvalidResultException

Description copied from interface: DSLContext

Execute a new query holding plain SQL.

Example (Postgres):

 String sql = "FETCH ALL IN \"\"";

Example (SQLite):

 String sql = "pragma table_info('my_table')";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fetchOne in interface DSLContext

Parameters:

sql - The SQL

Returns:

The results from the executed query. This is never null, even if the database returns no ResultSet

Throws:

DataAccessException - if something went wrong executing the query

InvalidResultException - if the query returned more than one record

fetchOne

public Record fetchOne(String sql,
              Object... bindings)
                throws DataAccessException,
                       InvalidResultException

Description copied from interface: DSLContext

Execute a new query holding plain SQL.

There must be as many bind variables contained in the SQL, as passed in the bindings parameter

Example (Postgres):

 String sql = "FETCH ALL IN \"\"";

Example (SQLite):

 String sql = "pragma table_info('my_table')";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fetchOne in interface DSLContext

Parameters:

sql - The SQL

bindings - The bindings

Returns:

The results from the executed query. This may be null if the database returned no records

Throws:

DataAccessException - if something went wrong executing the query

InvalidResultException - if the query returned more than one record

fetchOne

public Record fetchOne(String sql,
              QueryPart... parts)
                throws DataAccessException,
                       InvalidResultException

Description copied from interface: DSLContext

Execute a new query holding plain SQL.

Unlike DSLContext.fetchOne(String, Object...), the SQL passed to this method should not contain any bind variables. Instead, you can pass QueryPart objects to the method which will be rendered at indexed locations of your SQL string as such:

 // The following query
 fetchOne("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));

 // Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
 select ?, 'test' from "DUAL"
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! One way to escape literals is to use DSL.name(String...) and similar methods

Specified by:

fetchOne in interface DSLContext

Parameters:

sql - The SQL clause, containing {numbered placeholders} where query parts can be injected

parts - The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:

The results from the executed query. This may be null if the database returned no records

Throws:

DataAccessException - if something went wrong executing the query

InvalidResultException - if the query returned more than one record

execute

public int execute(String sql)
            throws DataAccessException

Description copied from interface: DSLContext

Execute a query holding plain SQL.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

execute in interface DSLContext

Parameters:

sql - The SQL

Returns:

The results from the executed query

Throws:

DataAccessException - if something went wrong executing the query

execute

public int execute(String sql,
          Object... bindings)
            throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL.

There must be as many bind variables contained in the SQL, as passed in the bindings parameter

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

execute in interface DSLContext

Parameters:

sql - The SQL

bindings - The bindings

Returns:

The results from the executed query

Throws:

DataAccessException - if something went wrong executing the query

execute

public int execute(String sql,
          QueryPart... parts)
            throws DataAccessException

Description copied from interface: DSLContext

Execute a new query holding plain SQL.

Unlike DSLContext.execute(String, Object...), the SQL passed to this method should not contain any bind variables. Instead, you can pass QueryPart objects to the method which will be rendered at indexed locations of your SQL string as such:

 // The following query
 execute("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));

 // Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
 select ?, 'test' from "DUAL"
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! One way to escape literals is to use DSL.name(String...) and similar methods

Specified by:

execute in interface DSLContext

Parameters:

sql - The SQL clause, containing {numbered placeholders} where query parts can be injected

parts - The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:

The results from the executed query

Throws:

DataAccessException - if something went wrong executing the query

resultQuery

public ResultQuery<Record> resultQuery(String sql)

Description copied from interface: DSLContext

Create a new query holding plain SQL.

There must not be any binding variables contained in the SQL

Use this method, when you want to take advantage of the many ways to fetch results in jOOQ, using ResultQuery. Some examples:

ResultQuery.fetchLazy()	Open a cursor and fetch records one by one
ResultQuery.fetchInto(Class)	Fetch records into a custom POJO (optionally annotated with JPA annotations)
ResultQuery.fetchInto(RecordHandler)	Fetch records into a custom callback (similar to Spring's RowMapper)
ResultQuery.fetchLater()	Fetch records of a long-running query asynchronously

Example (Postgres):

 String sql = "FETCH ALL IN \"\"";

Example (SQLite):

 String sql = "pragma table_info('my_table')";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

resultQuery in interface DSLContext

Parameters:

sql - The SQL

Returns:

An executable query

resultQuery

public ResultQuery<Record> resultQuery(String sql,
                              Object... bindings)

Description copied from interface: DSLContext

Create a new query holding plain SQL.

There must be as many bind variables contained in the SQL, as passed in the bindings parameter

Use this method, when you want to take advantage of the many ways to fetch results in jOOQ, using ResultQuery. Some examples:

ResultQuery.fetchLazy()	Open a cursor and fetch records one by one
ResultQuery.fetchInto(Class)	Fetch records into a custom POJO (optionally annotated with JPA annotations)
ResultQuery.fetchInto(RecordHandler)	Fetch records into a custom callback (similar to Spring's RowMapper)
ResultQuery.fetchLater()	Fetch records of a long-running query asynchronously

Example (Postgres):

 String sql = "FETCH ALL IN \"\"";

Example (SQLite):

 String sql = "pragma table_info('my_table')";

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

resultQuery in interface DSLContext

Parameters:

sql - The SQL

bindings - The bindings

Returns:

A query wrapping the plain SQL

resultQuery

public ResultQuery<Record> resultQuery(String sql,
                              QueryPart... parts)

Description copied from interface: DSLContext

Create a new query holding plain SQL.

Unlike DSLContext.resultQuery(String, Object...), the SQL passed to this method should not contain any bind variables. Instead, you can pass QueryPart objects to the method which will be rendered at indexed locations of your SQL string as such:

 // The following query
 resultQuery("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));

 // Will render this SQL on an Oracle database with RenderNameStyle.QUOTED:
 select ?, 'test' from "DUAL"
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! One way to escape literals is to use DSL.name(String...) and similar methods

Specified by:

resultQuery in interface DSLContext

Parameters:

sql - The SQL clause, containing {numbered placeholders} where query parts can be injected

parts - The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:

A query wrapping the plain SQL

fetch

public Result<Record> fetch(ResultSet rs)
                     throws DataAccessException

Description copied from interface: DSLContext

Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.

After fetching all data, the JDBC ResultSet will be closed.

Use DSLContext.fetchLazy(ResultSet), to fetch one Record at a time, instead of load the entire ResultSet into a jOOQ Result at once.

Specified by:

fetch in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

Returns:

The resulting jOOQ Result

Throws:

DataAccessException - if something went wrong executing the query

fetch

public Result<Record> fetch(ResultSet rs,
                   Field<?>... fields)
                     throws DataAccessException

Description copied from interface: DSLContext

Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.

After fetching all data, the JDBC ResultSet will be closed.

Use DSLContext.fetchLazy(ResultSet), to fetch one Record at a time, instead of load the entire ResultSet into a jOOQ Result at once.

The additional fields argument is used by jOOQ to coerce field names and data types to the desired output

Specified by:

fetch in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

fields - The fields to use in the desired output

Returns:

The resulting jOOQ Result

Throws:

DataAccessException - if something went wrong executing the query

fetch

public Result<Record> fetch(ResultSet rs,
                   DataType<?>... types)
                     throws DataAccessException

Description copied from interface: DSLContext

Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.

After fetching all data, the JDBC ResultSet will be closed.

Use DSLContext.fetchLazy(ResultSet), to fetch one Record at a time, instead of load the entire ResultSet into a jOOQ Result at once.

The additional types argument is used by jOOQ to coerce data types to the desired output

Specified by:

fetch in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

types - The data types to use in the desired output

Returns:

The resulting jOOQ Result

Throws:

DataAccessException - if something went wrong executing the query

fetch

public Result<Record> fetch(ResultSet rs,
                   Class<?>... types)
                     throws DataAccessException

Description copied from interface: DSLContext

Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.

After fetching all data, the JDBC ResultSet will be closed.

Use DSLContext.fetchLazy(ResultSet), to fetch one Record at a time, instead of load the entire ResultSet into a jOOQ Result at once.

The additional types argument is used by jOOQ to coerce data types to the desired output

Specified by:

fetch in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

types - The data types to use in the desired output

Returns:

The resulting jOOQ Result

Throws:

DataAccessException - if something went wrong executing the query

fetchOne

public Record fetchOne(ResultSet rs)
                throws DataAccessException,
                       InvalidResultException

Description copied from interface: DSLContext

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

This will internally fetch all records and throw an exception if there was more than one resulting record.

Specified by:

fetchOne in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

Returns:

The resulting jOOQ record

Throws:

DataAccessException - if something went wrong executing the query

InvalidResultException - if the query returned more than one record

fetchOne

public Record fetchOne(ResultSet rs,
              Field<?>... fields)
                throws DataAccessException,
                       InvalidResultException

Description copied from interface: DSLContext

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

This will internally fetch all records and throw an exception if there was more than one resulting record.

The additional fields argument is used by jOOQ to coerce field names and data types to the desired output

Specified by:

fetchOne in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

fields - The fields to use in the desired output

Returns:

The resulting jOOQ record

Throws:

DataAccessException - if something went wrong executing the query

InvalidResultException - if the query returned more than one record

fetchOne

public Record fetchOne(ResultSet rs,
              DataType<?>... types)
                throws DataAccessException,
                       InvalidResultException

Description copied from interface: DSLContext

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

This will internally fetch all records and throw an exception if there was more than one resulting record.

The additional types argument is used by jOOQ to coerce data types to the desired output

Specified by:

fetchOne in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

types - The data types to use in the desired output

Returns:

The resulting jOOQ record

Throws:

DataAccessException - if something went wrong executing the query

InvalidResultException - if the query returned more than one record

fetchOne

public Record fetchOne(ResultSet rs,
              Class<?>... types)
                throws DataAccessException,
                       InvalidResultException

Description copied from interface: DSLContext

Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.

This will internally fetch all records and throw an exception if there was more than one resulting record.

The additional types argument is used by jOOQ to coerce data types to the desired output

Specified by:

fetchOne in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

types - The data types to use in the desired output

Returns:

The resulting jOOQ record

Throws:

DataAccessException - if something went wrong executing the query

InvalidResultException - if the query returned more than one record

fetchLazy

public Cursor<Record> fetchLazy(ResultSet rs)
                         throws DataAccessException

Description copied from interface: DSLContext

Wrap a JDBC ResultSet into a jOOQ Cursor.

Use DSLContext.fetch(ResultSet), to load the entire ResultSet into a jOOQ Result at once.

Specified by:

fetchLazy in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

Returns:

The resulting jOOQ Result

Throws:

DataAccessException - if something went wrong executing the query

fetchLazy

public Cursor<Record> fetchLazy(ResultSet rs,
                       Field<?>... fields)
                         throws DataAccessException

Description copied from interface: DSLContext

Wrap a JDBC ResultSet into a jOOQ Cursor.

Use DSLContext.fetch(ResultSet), to load the entire ResultSet into a jOOQ Result at once.

The additional fields argument is used by jOOQ to coerce field names and data types to the desired output

Specified by:

fetchLazy in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

fields - The fields to use in the desired output

Returns:

The resulting jOOQ Result

Throws:

DataAccessException - if something went wrong executing the query

fetchLazy

public Cursor<Record> fetchLazy(ResultSet rs,
                       DataType<?>... types)
                         throws DataAccessException

Description copied from interface: DSLContext

Wrap a JDBC ResultSet into a jOOQ Cursor.

Use DSLContext.fetch(ResultSet), to load the entire ResultSet into a jOOQ Result at once.

The additional types argument is used by jOOQ to coerce data types to the desired output

Specified by:

fetchLazy in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

types - The data types to use in the desired output

Returns:

The resulting jOOQ Result

Throws:

DataAccessException - if something went wrong executing the query

fetchLazy

public Cursor<Record> fetchLazy(ResultSet rs,
                       Class<?>... types)
                         throws DataAccessException

Description copied from interface: DSLContext

Wrap a JDBC ResultSet into a jOOQ Cursor.

Use DSLContext.fetch(ResultSet), to load the entire ResultSet into a jOOQ Result at once.

The additional types argument is used by jOOQ to coerce data types to the desired output

Specified by:

fetchLazy in interface DSLContext

Parameters:

rs - The JDBC ResultSet to fetch data from

types - The data types to use in the desired output

Returns:

The resulting jOOQ Result

Throws:

DataAccessException - if something went wrong executing the query

fetchFromTXT

public Result<Record> fetchFromTXT(String string)
                            throws DataAccessException

Description copied from interface: DSLContext

Fetch all data from a formatted string.

The supplied string is supposed to be formatted in a human-readable way. This is the same as calling fetchFromTXT(string, "{null}")

Specified by:

fetchFromTXT in interface DSLContext

Parameters:

string - The formatted string

Returns:

The transformed result

Throws:

DataAccessException - If the supplied string does not adhere to the above format rules.

See Also:

DSLContext.fetchFromTXT(String, String)

fetchFromTXT

public Result<Record> fetchFromTXT(String string,
                          String nullLiteral)
                            throws DataAccessException

Description copied from interface: DSLContext

Fetch all data from a formatted string.

This method supports parsing results from two types of human-readable formats:

The jOOQ Result.format()

This format is recognised by the fact that the first line starts with a "plus" sign:

 +-----+-----+--------------------------+
 |COL1 |COL2 |COL3 containing whitespace|
 +-----+-----+--------------------------+
 |val1 |1    |some text                 |
 |val2 | 2   | more text                |
 +-----+-----+--------------------------+
 

This method will decode the above formatted string according to the following rules:

• The number of columns is defined by the number of dash groups in the first line. Groups are separated by exactly one "plus" sign
• The column types are VARCHAR(N) where N = number of dashes per dash group
• The column names are defined by the trimmed text contained in the second row
• The data is defined by the trimmed text contained in the subsequent rows

The H2 database test data format

The supplied string is supposed to be formatted in the following, human-readable way:

 COL1  COL2   COL3 containing whitespace
 ----- ----   --------------------------
 val1  1      some text
 val2   2      more text
 

This method will decode the above formatted string according to the following rules:

• The number of columns is defined by the number of dash groups in the second line. Groups are separated by space(s)
• The column types are VARCHAR(N) where N = number of dashes per dash group
• The column names are defined by the trimmed text contained in the first row
• The data is defined by the trimmed text contained in the subsequent rows

Both parsing methods

Both parsing methods make no assumption about the resulting data types. Instead, all data is string-based.

Specified by:

fetchFromTXT in interface DSLContext

Parameters:

string - The formatted string

nullLiteral - The string literal to be used as null value.

Returns:

The transformed result

Throws:

DataAccessException - If the supplied string does not adhere to the above format rules.

fetchFromCSV

public Result<Record> fetchFromCSV(String string)
                            throws DataAccessException

Description copied from interface: DSLContext

Fetch all data from a CSV string.

This is the same as calling fetchFromCSV(string, ',') and the inverse of calling Result.formatCSV(). The first row of the CSV data is required to hold field name information. Subsequent rows may contain data, which is interpreted as String. Use the various conversion methods to retrieve other data types from the Result:

• Result.getValues(Field, Class)
• Result.getValues(int, Class)
• Result.getValues(String, Class)
• Result.getValues(Field, Converter)
• Result.getValues(int, Converter)
• Result.getValues(String, Converter)

Missing values result in null. Empty values result in empty Strings

Specified by:

fetchFromCSV in interface DSLContext

Parameters:

string - The CSV string

Returns:

The transformed result

Throws:

DataAccessException - If anything went wrong parsing the CSV file

See Also:

DSLContext.fetchFromCSV(String, char)

fetchFromCSV

public Result<Record> fetchFromCSV(String string,
                          char delimiter)
                            throws DataAccessException

Description copied from interface: DSLContext

Fetch all data from a CSV string.

This is inverse of calling Result.formatCSV(char). The first row of the CSV data is required to hold field name information. Subsequent rows may contain data, which is interpreted as String. Use the various conversion methods to retrieve other data types from the Result:

• Result.getValues(Field, Class)
• Result.getValues(int, Class)
• Result.getValues(String, Class)
• Result.getValues(Field, Converter)
• Result.getValues(int, Converter)
• Result.getValues(String, Converter)

Missing values result in null. Empty values result in empty Strings

Specified by:

fetchFromCSV in interface DSLContext

Parameters:

string - The CSV string

delimiter - The delimiter to expect between records

Returns:

The transformed result

Throws:

DataAccessException - If anything went wrong parsing the CSV file

See Also:

DSLContext.fetchFromCSV(String), DSLContext.fetchFromStringData(List)

fetchFromStringData

public Result<Record> fetchFromStringData(String[]... data)

Description copied from interface: DSLContext

Fetch all data from a list of strings.

This is used by methods such as

• DSLContext.fetchFromCSV(String)
• DSLContext.fetchFromTXT(String)

The first element of the argument list should contain column names. Subsequent elements contain actual data. The degree of all arrays contained in the argument should be the same, although this is not a requirement. jOOQ will ignore excess data, and fill missing data with null.

Specified by:

fetchFromStringData in interface DSLContext

Parameters:

data - The data to be transformed into a Result

Returns:

The transformed result

See Also:

DSLContext.fetchFromStringData(List)

fetchFromStringData

public Result<Record> fetchFromStringData(List<String[]> data)

Description copied from interface: DSLContext

Fetch all data from a list of strings.

This is used by methods such as

• DSLContext.fetchFromCSV(String)
• DSLContext.fetchFromTXT(String)

The first element of the argument list should contain column names. Subsequent elements contain actual data. The degree of all arrays contained in the argument should be the same, although this is not a requirement. jOOQ will ignore excess data, and fill missing data with null.

Specified by:

fetchFromStringData in interface DSLContext

Parameters:

data - The data to be transformed into a Result

Returns:

The transformed result

selectFrom

public <R extends Record> SelectWhereStep<R> selectFrom(Table<R> table)

Description copied from interface: DSLContext

Create a new DSL select statement.

Example:

 SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
 

Specified by:

selectFrom in interface DSLContext

select

public SelectSelectStep<Record> select(Collection<? extends Field<?>> fields)

Description copied from interface: DSLContext

Create a new DSL select statement.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Collection) instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.select(fields)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.select(Collection)

select

public SelectSelectStep<Record> select(Field<?>... fields)

Description copied from interface: DSLContext

Create a new DSL select statement.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field...) instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.select(field1, field2)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2)
       .execute();
 

Specified by:

select in interface DSLContext

See Also:

DSL.select(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1> SelectSelectStep<Record1<T1>> select(Field<T1> field1)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Field.in(Select), Field.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field) instead.

Example:

 using(configuration)
       .select(field1)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2> SelectSelectStep<Record2<T1,T2>> select(Field<T1> field1,
                                                             Field<T2> field2)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row2.in(Select), Row2.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> select(Field<T1> field1,
                                                                   Field<T2> field2,
                                                                   Field<T3> field3)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row3.in(Select), Row3.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4> SelectSelectStep<Record4<T1,T2,T3,T4>> select(Field<T1> field1,
                                                                         Field<T2> field2,
                                                                         Field<T3> field3,
                                                                         Field<T4> field4)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row4.in(Select), Row4.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, field4)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>> select(Field<T1> field1,
                                                                               Field<T2> field2,
                                                                               Field<T3> field3,
                                                                               Field<T4> field4,
                                                                               Field<T5> field5)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row5.in(Select), Row5.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, field4, field5)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6> SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>> select(Field<T1> field1,
                                                                                     Field<T2> field2,
                                                                                     Field<T3> field3,
                                                                                     Field<T4> field4,
                                                                                     Field<T5> field5,
                                                                                     Field<T6> field6)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row6.in(Select), Row6.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field5, field6)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7> SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>> select(Field<T1> field1,
                                                                                           Field<T2> field2,
                                                                                           Field<T3> field3,
                                                                                           Field<T4> field4,
                                                                                           Field<T5> field5,
                                                                                           Field<T6> field6,
                                                                                           Field<T7> field7)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row7.in(Select), Row7.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field6, field7)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select(Field<T1> field1,
                                                                                                 Field<T2> field2,
                                                                                                 Field<T3> field3,
                                                                                                 Field<T4> field4,
                                                                                                 Field<T5> field5,
                                                                                                 Field<T6> field6,
                                                                                                 Field<T7> field7,
                                                                                                 Field<T8> field8)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row8.in(Select), Row8.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field7, field8)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select(Field<T1> field1,
                                                                                                       Field<T2> field2,
                                                                                                       Field<T3> field3,
                                                                                                       Field<T4> field4,
                                                                                                       Field<T5> field5,
                                                                                                       Field<T6> field6,
                                                                                                       Field<T7> field7,
                                                                                                       Field<T8> field8,
                                                                                                       Field<T9> field9)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row9.in(Select), Row9.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field8, field9)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select(Field<T1> field1,
                                                                                                                Field<T2> field2,
                                                                                                                Field<T3> field3,
                                                                                                                Field<T4> field4,
                                                                                                                Field<T5> field5,
                                                                                                                Field<T6> field6,
                                                                                                                Field<T7> field7,
                                                                                                                Field<T8> field8,
                                                                                                                Field<T9> field9,
                                                                                                                Field<T10> field10)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row10.in(Select), Row10.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field9, field10)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select(Field<T1> field1,
                                                                                                                        Field<T2> field2,
                                                                                                                        Field<T3> field3,
                                                                                                                        Field<T4> field4,
                                                                                                                        Field<T5> field5,
                                                                                                                        Field<T6> field6,
                                                                                                                        Field<T7> field7,
                                                                                                                        Field<T8> field8,
                                                                                                                        Field<T9> field9,
                                                                                                                        Field<T10> field10,
                                                                                                                        Field<T11> field11)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row11.in(Select), Row11.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field10, field11)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select(Field<T1> field1,
                                                                                                                                Field<T2> field2,
                                                                                                                                Field<T3> field3,
                                                                                                                                Field<T4> field4,
                                                                                                                                Field<T5> field5,
                                                                                                                                Field<T6> field6,
                                                                                                                                Field<T7> field7,
                                                                                                                                Field<T8> field8,
                                                                                                                                Field<T9> field9,
                                                                                                                                Field<T10> field10,
                                                                                                                                Field<T11> field11,
                                                                                                                                Field<T12> field12)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row12.in(Select), Row12.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field11, field12)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select(Field<T1> field1,
                                                                                                                                        Field<T2> field2,
                                                                                                                                        Field<T3> field3,
                                                                                                                                        Field<T4> field4,
                                                                                                                                        Field<T5> field5,
                                                                                                                                        Field<T6> field6,
                                                                                                                                        Field<T7> field7,
                                                                                                                                        Field<T8> field8,
                                                                                                                                        Field<T9> field9,
                                                                                                                                        Field<T10> field10,
                                                                                                                                        Field<T11> field11,
                                                                                                                                        Field<T12> field12,
                                                                                                                                        Field<T13> field13)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row13.in(Select), Row13.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field12, field13)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select(Field<T1> field1,
                                                                                                                                                Field<T2> field2,
                                                                                                                                                Field<T3> field3,
                                                                                                                                                Field<T4> field4,
                                                                                                                                                Field<T5> field5,
                                                                                                                                                Field<T6> field6,
                                                                                                                                                Field<T7> field7,
                                                                                                                                                Field<T8> field8,
                                                                                                                                                Field<T9> field9,
                                                                                                                                                Field<T10> field10,
                                                                                                                                                Field<T11> field11,
                                                                                                                                                Field<T12> field12,
                                                                                                                                                Field<T13> field13,
                                                                                                                                                Field<T14> field14)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row14.in(Select), Row14.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field13, field14)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select(Field<T1> field1,
                                                                                                                                                        Field<T2> field2,
                                                                                                                                                        Field<T3> field3,
                                                                                                                                                        Field<T4> field4,
                                                                                                                                                        Field<T5> field5,
                                                                                                                                                        Field<T6> field6,
                                                                                                                                                        Field<T7> field7,
                                                                                                                                                        Field<T8> field8,
                                                                                                                                                        Field<T9> field9,
                                                                                                                                                        Field<T10> field10,
                                                                                                                                                        Field<T11> field11,
                                                                                                                                                        Field<T12> field12,
                                                                                                                                                        Field<T13> field13,
                                                                                                                                                        Field<T14> field14,
                                                                                                                                                        Field<T15> field15)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row15.in(Select), Row15.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field14, field15)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select(Field<T1> field1,
                                                                                                                                                                Field<T2> field2,
                                                                                                                                                                Field<T3> field3,
                                                                                                                                                                Field<T4> field4,
                                                                                                                                                                Field<T5> field5,
                                                                                                                                                                Field<T6> field6,
                                                                                                                                                                Field<T7> field7,
                                                                                                                                                                Field<T8> field8,
                                                                                                                                                                Field<T9> field9,
                                                                                                                                                                Field<T10> field10,
                                                                                                                                                                Field<T11> field11,
                                                                                                                                                                Field<T12> field12,
                                                                                                                                                                Field<T13> field13,
                                                                                                                                                                Field<T14> field14,
                                                                                                                                                                Field<T15> field15,
                                                                                                                                                                Field<T16> field16)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row16.in(Select), Row16.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field15, field16)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select(Field<T1> field1,
                                                                                                                                                                        Field<T2> field2,
                                                                                                                                                                        Field<T3> field3,
                                                                                                                                                                        Field<T4> field4,
                                                                                                                                                                        Field<T5> field5,
                                                                                                                                                                        Field<T6> field6,
                                                                                                                                                                        Field<T7> field7,
                                                                                                                                                                        Field<T8> field8,
                                                                                                                                                                        Field<T9> field9,
                                                                                                                                                                        Field<T10> field10,
                                                                                                                                                                        Field<T11> field11,
                                                                                                                                                                        Field<T12> field12,
                                                                                                                                                                        Field<T13> field13,
                                                                                                                                                                        Field<T14> field14,
                                                                                                                                                                        Field<T15> field15,
                                                                                                                                                                        Field<T16> field16,
                                                                                                                                                                        Field<T17> field17)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row17.in(Select), Row17.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field16, field17)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select(Field<T1> field1,
                                                                                                                                                                                Field<T2> field2,
                                                                                                                                                                                Field<T3> field3,
                                                                                                                                                                                Field<T4> field4,
                                                                                                                                                                                Field<T5> field5,
                                                                                                                                                                                Field<T6> field6,
                                                                                                                                                                                Field<T7> field7,
                                                                                                                                                                                Field<T8> field8,
                                                                                                                                                                                Field<T9> field9,
                                                                                                                                                                                Field<T10> field10,
                                                                                                                                                                                Field<T11> field11,
                                                                                                                                                                                Field<T12> field12,
                                                                                                                                                                                Field<T13> field13,
                                                                                                                                                                                Field<T14> field14,
                                                                                                                                                                                Field<T15> field15,
                                                                                                                                                                                Field<T16> field16,
                                                                                                                                                                                Field<T17> field17,
                                                                                                                                                                                Field<T18> field18)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row18.in(Select), Row18.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field17, field18)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select(Field<T1> field1,
                                                                                                                                                                                        Field<T2> field2,
                                                                                                                                                                                        Field<T3> field3,
                                                                                                                                                                                        Field<T4> field4,
                                                                                                                                                                                        Field<T5> field5,
                                                                                                                                                                                        Field<T6> field6,
                                                                                                                                                                                        Field<T7> field7,
                                                                                                                                                                                        Field<T8> field8,
                                                                                                                                                                                        Field<T9> field9,
                                                                                                                                                                                        Field<T10> field10,
                                                                                                                                                                                        Field<T11> field11,
                                                                                                                                                                                        Field<T12> field12,
                                                                                                                                                                                        Field<T13> field13,
                                                                                                                                                                                        Field<T14> field14,
                                                                                                                                                                                        Field<T15> field15,
                                                                                                                                                                                        Field<T16> field16,
                                                                                                                                                                                        Field<T17> field17,
                                                                                                                                                                                        Field<T18> field18,
                                                                                                                                                                                        Field<T19> field19)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row19.in(Select), Row19.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field18, field19)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select(Field<T1> field1,
                                                                                                                                                                                                Field<T2> field2,
                                                                                                                                                                                                Field<T3> field3,
                                                                                                                                                                                                Field<T4> field4,
                                                                                                                                                                                                Field<T5> field5,
                                                                                                                                                                                                Field<T6> field6,
                                                                                                                                                                                                Field<T7> field7,
                                                                                                                                                                                                Field<T8> field8,
                                                                                                                                                                                                Field<T9> field9,
                                                                                                                                                                                                Field<T10> field10,
                                                                                                                                                                                                Field<T11> field11,
                                                                                                                                                                                                Field<T12> field12,
                                                                                                                                                                                                Field<T13> field13,
                                                                                                                                                                                                Field<T14> field14,
                                                                                                                                                                                                Field<T15> field15,
                                                                                                                                                                                                Field<T16> field16,
                                                                                                                                                                                                Field<T17> field17,
                                                                                                                                                                                                Field<T18> field18,
                                                                                                                                                                                                Field<T19> field19,
                                                                                                                                                                                                Field<T20> field20)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row20.in(Select), Row20.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field19, field20)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select(Field<T1> field1,
                                                                                                                                                                                                        Field<T2> field2,
                                                                                                                                                                                                        Field<T3> field3,
                                                                                                                                                                                                        Field<T4> field4,
                                                                                                                                                                                                        Field<T5> field5,
                                                                                                                                                                                                        Field<T6> field6,
                                                                                                                                                                                                        Field<T7> field7,
                                                                                                                                                                                                        Field<T8> field8,
                                                                                                                                                                                                        Field<T9> field9,
                                                                                                                                                                                                        Field<T10> field10,
                                                                                                                                                                                                        Field<T11> field11,
                                                                                                                                                                                                        Field<T12> field12,
                                                                                                                                                                                                        Field<T13> field13,
                                                                                                                                                                                                        Field<T14> field14,
                                                                                                                                                                                                        Field<T15> field15,
                                                                                                                                                                                                        Field<T16> field16,
                                                                                                                                                                                                        Field<T17> field17,
                                                                                                                                                                                                        Field<T18> field18,
                                                                                                                                                                                                        Field<T19> field19,
                                                                                                                                                                                                        Field<T20> field20,
                                                                                                                                                                                                        Field<T21> field21)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row21.in(Select), Row21.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field20, field21)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> SelectSelectStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select(Field<T1> field1,
                                                                                                                                                                                                                Field<T2> field2,
                                                                                                                                                                                                                Field<T3> field3,
                                                                                                                                                                                                                Field<T4> field4,
                                                                                                                                                                                                                Field<T5> field5,
                                                                                                                                                                                                                Field<T6> field6,
                                                                                                                                                                                                                Field<T7> field7,
                                                                                                                                                                                                                Field<T8> field8,
                                                                                                                                                                                                                Field<T9> field9,
                                                                                                                                                                                                                Field<T10> field10,
                                                                                                                                                                                                                Field<T11> field11,
                                                                                                                                                                                                                Field<T12> field12,
                                                                                                                                                                                                                Field<T13> field13,
                                                                                                                                                                                                                Field<T14> field14,
                                                                                                                                                                                                                Field<T15> field15,
                                                                                                                                                                                                                Field<T16> field16,
                                                                                                                                                                                                                Field<T17> field17,
                                                                                                                                                                                                                Field<T18> field18,
                                                                                                                                                                                                                Field<T19> field19,
                                                                                                                                                                                                                Field<T20> field20,
                                                                                                                                                                                                                Field<T21> field21,
                                                                                                                                                                                                                Field<T22> field22)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.select(Field...), except that it declares additional record-level typesafety, which is needed by Row22.in(Select), Row22.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .select(field1, field2, field3, .., field21, field22)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

select in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

public SelectSelectStep<Record> selectDistinct(Collection<? extends Field<?>> fields)

Description copied from interface: DSLContext

Create a new DSL select statement.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Collection) instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.selectDistinct(fields)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Collection)

selectDistinct

public SelectSelectStep<Record> selectDistinct(Field<?>... fields)

Description copied from interface: DSLContext

Create a new DSL select statement.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field...) instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.selectDistinct(field1, field2)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1> SelectSelectStep<Record1<T1>> selectDistinct(Field<T1> field1)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Field.in(Select), Field.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2> SelectSelectStep<Record2<T1,T2>> selectDistinct(Field<T1> field1,
                                                                     Field<T2> field2)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row2.in(Select), Row2.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> selectDistinct(Field<T1> field1,
                                                                           Field<T2> field2,
                                                                           Field<T3> field3)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row3.in(Select), Row3.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4> SelectSelectStep<Record4<T1,T2,T3,T4>> selectDistinct(Field<T1> field1,
                                                                                 Field<T2> field2,
                                                                                 Field<T3> field3,
                                                                                 Field<T4> field4)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row4.in(Select), Row4.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, field4)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>> selectDistinct(Field<T1> field1,
                                                                                       Field<T2> field2,
                                                                                       Field<T3> field3,
                                                                                       Field<T4> field4,
                                                                                       Field<T5> field5)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row5.in(Select), Row5.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, field4, field5)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6> SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>> selectDistinct(Field<T1> field1,
                                                                                             Field<T2> field2,
                                                                                             Field<T3> field3,
                                                                                             Field<T4> field4,
                                                                                             Field<T5> field5,
                                                                                             Field<T6> field6)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row6.in(Select), Row6.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field5, field6)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7> SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>> selectDistinct(Field<T1> field1,
                                                                                                   Field<T2> field2,
                                                                                                   Field<T3> field3,
                                                                                                   Field<T4> field4,
                                                                                                   Field<T5> field5,
                                                                                                   Field<T6> field6,
                                                                                                   Field<T7> field7)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row7.in(Select), Row7.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field6, field7)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>> selectDistinct(Field<T1> field1,
                                                                                                         Field<T2> field2,
                                                                                                         Field<T3> field3,
                                                                                                         Field<T4> field4,
                                                                                                         Field<T5> field5,
                                                                                                         Field<T6> field6,
                                                                                                         Field<T7> field7,
                                                                                                         Field<T8> field8)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row8.in(Select), Row8.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field7, field8)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> selectDistinct(Field<T1> field1,
                                                                                                               Field<T2> field2,
                                                                                                               Field<T3> field3,
                                                                                                               Field<T4> field4,
                                                                                                               Field<T5> field5,
                                                                                                               Field<T6> field6,
                                                                                                               Field<T7> field7,
                                                                                                               Field<T8> field8,
                                                                                                               Field<T9> field9)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row9.in(Select), Row9.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field8, field9)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> selectDistinct(Field<T1> field1,
                                                                                                                        Field<T2> field2,
                                                                                                                        Field<T3> field3,
                                                                                                                        Field<T4> field4,
                                                                                                                        Field<T5> field5,
                                                                                                                        Field<T6> field6,
                                                                                                                        Field<T7> field7,
                                                                                                                        Field<T8> field8,
                                                                                                                        Field<T9> field9,
                                                                                                                        Field<T10> field10)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row10.in(Select), Row10.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field9, field10)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> selectDistinct(Field<T1> field1,
                                                                                                                                Field<T2> field2,
                                                                                                                                Field<T3> field3,
                                                                                                                                Field<T4> field4,
                                                                                                                                Field<T5> field5,
                                                                                                                                Field<T6> field6,
                                                                                                                                Field<T7> field7,
                                                                                                                                Field<T8> field8,
                                                                                                                                Field<T9> field9,
                                                                                                                                Field<T10> field10,
                                                                                                                                Field<T11> field11)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row11.in(Select), Row11.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field10, field11)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> selectDistinct(Field<T1> field1,
                                                                                                                                        Field<T2> field2,
                                                                                                                                        Field<T3> field3,
                                                                                                                                        Field<T4> field4,
                                                                                                                                        Field<T5> field5,
                                                                                                                                        Field<T6> field6,
                                                                                                                                        Field<T7> field7,
                                                                                                                                        Field<T8> field8,
                                                                                                                                        Field<T9> field9,
                                                                                                                                        Field<T10> field10,
                                                                                                                                        Field<T11> field11,
                                                                                                                                        Field<T12> field12)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row12.in(Select), Row12.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field11, field12)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> selectDistinct(Field<T1> field1,
                                                                                                                                                Field<T2> field2,
                                                                                                                                                Field<T3> field3,
                                                                                                                                                Field<T4> field4,
                                                                                                                                                Field<T5> field5,
                                                                                                                                                Field<T6> field6,
                                                                                                                                                Field<T7> field7,
                                                                                                                                                Field<T8> field8,
                                                                                                                                                Field<T9> field9,
                                                                                                                                                Field<T10> field10,
                                                                                                                                                Field<T11> field11,
                                                                                                                                                Field<T12> field12,
                                                                                                                                                Field<T13> field13)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row13.in(Select), Row13.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field12, field13)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> selectDistinct(Field<T1> field1,
                                                                                                                                                        Field<T2> field2,
                                                                                                                                                        Field<T3> field3,
                                                                                                                                                        Field<T4> field4,
                                                                                                                                                        Field<T5> field5,
                                                                                                                                                        Field<T6> field6,
                                                                                                                                                        Field<T7> field7,
                                                                                                                                                        Field<T8> field8,
                                                                                                                                                        Field<T9> field9,
                                                                                                                                                        Field<T10> field10,
                                                                                                                                                        Field<T11> field11,
                                                                                                                                                        Field<T12> field12,
                                                                                                                                                        Field<T13> field13,
                                                                                                                                                        Field<T14> field14)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row14.in(Select), Row14.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field13, field14)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> selectDistinct(Field<T1> field1,
                                                                                                                                                                Field<T2> field2,
                                                                                                                                                                Field<T3> field3,
                                                                                                                                                                Field<T4> field4,
                                                                                                                                                                Field<T5> field5,
                                                                                                                                                                Field<T6> field6,
                                                                                                                                                                Field<T7> field7,
                                                                                                                                                                Field<T8> field8,
                                                                                                                                                                Field<T9> field9,
                                                                                                                                                                Field<T10> field10,
                                                                                                                                                                Field<T11> field11,
                                                                                                                                                                Field<T12> field12,
                                                                                                                                                                Field<T13> field13,
                                                                                                                                                                Field<T14> field14,
                                                                                                                                                                Field<T15> field15)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row15.in(Select), Row15.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field14, field15)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> selectDistinct(Field<T1> field1,
                                                                                                                                                                        Field<T2> field2,
                                                                                                                                                                        Field<T3> field3,
                                                                                                                                                                        Field<T4> field4,
                                                                                                                                                                        Field<T5> field5,
                                                                                                                                                                        Field<T6> field6,
                                                                                                                                                                        Field<T7> field7,
                                                                                                                                                                        Field<T8> field8,
                                                                                                                                                                        Field<T9> field9,
                                                                                                                                                                        Field<T10> field10,
                                                                                                                                                                        Field<T11> field11,
                                                                                                                                                                        Field<T12> field12,
                                                                                                                                                                        Field<T13> field13,
                                                                                                                                                                        Field<T14> field14,
                                                                                                                                                                        Field<T15> field15,
                                                                                                                                                                        Field<T16> field16)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row16.in(Select), Row16.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field15, field16)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> selectDistinct(Field<T1> field1,
                                                                                                                                                                                Field<T2> field2,
                                                                                                                                                                                Field<T3> field3,
                                                                                                                                                                                Field<T4> field4,
                                                                                                                                                                                Field<T5> field5,
                                                                                                                                                                                Field<T6> field6,
                                                                                                                                                                                Field<T7> field7,
                                                                                                                                                                                Field<T8> field8,
                                                                                                                                                                                Field<T9> field9,
                                                                                                                                                                                Field<T10> field10,
                                                                                                                                                                                Field<T11> field11,
                                                                                                                                                                                Field<T12> field12,
                                                                                                                                                                                Field<T13> field13,
                                                                                                                                                                                Field<T14> field14,
                                                                                                                                                                                Field<T15> field15,
                                                                                                                                                                                Field<T16> field16,
                                                                                                                                                                                Field<T17> field17)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row17.in(Select), Row17.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field16, field17)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> selectDistinct(Field<T1> field1,
                                                                                                                                                                                        Field<T2> field2,
                                                                                                                                                                                        Field<T3> field3,
                                                                                                                                                                                        Field<T4> field4,
                                                                                                                                                                                        Field<T5> field5,
                                                                                                                                                                                        Field<T6> field6,
                                                                                                                                                                                        Field<T7> field7,
                                                                                                                                                                                        Field<T8> field8,
                                                                                                                                                                                        Field<T9> field9,
                                                                                                                                                                                        Field<T10> field10,
                                                                                                                                                                                        Field<T11> field11,
                                                                                                                                                                                        Field<T12> field12,
                                                                                                                                                                                        Field<T13> field13,
                                                                                                                                                                                        Field<T14> field14,
                                                                                                                                                                                        Field<T15> field15,
                                                                                                                                                                                        Field<T16> field16,
                                                                                                                                                                                        Field<T17> field17,
                                                                                                                                                                                        Field<T18> field18)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row18.in(Select), Row18.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field17, field18)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> selectDistinct(Field<T1> field1,
                                                                                                                                                                                                Field<T2> field2,
                                                                                                                                                                                                Field<T3> field3,
                                                                                                                                                                                                Field<T4> field4,
                                                                                                                                                                                                Field<T5> field5,
                                                                                                                                                                                                Field<T6> field6,
                                                                                                                                                                                                Field<T7> field7,
                                                                                                                                                                                                Field<T8> field8,
                                                                                                                                                                                                Field<T9> field9,
                                                                                                                                                                                                Field<T10> field10,
                                                                                                                                                                                                Field<T11> field11,
                                                                                                                                                                                                Field<T12> field12,
                                                                                                                                                                                                Field<T13> field13,
                                                                                                                                                                                                Field<T14> field14,
                                                                                                                                                                                                Field<T15> field15,
                                                                                                                                                                                                Field<T16> field16,
                                                                                                                                                                                                Field<T17> field17,
                                                                                                                                                                                                Field<T18> field18,
                                                                                                                                                                                                Field<T19> field19)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row19.in(Select), Row19.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field18, field19)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> selectDistinct(Field<T1> field1,
                                                                                                                                                                                                        Field<T2> field2,
                                                                                                                                                                                                        Field<T3> field3,
                                                                                                                                                                                                        Field<T4> field4,
                                                                                                                                                                                                        Field<T5> field5,
                                                                                                                                                                                                        Field<T6> field6,
                                                                                                                                                                                                        Field<T7> field7,
                                                                                                                                                                                                        Field<T8> field8,
                                                                                                                                                                                                        Field<T9> field9,
                                                                                                                                                                                                        Field<T10> field10,
                                                                                                                                                                                                        Field<T11> field11,
                                                                                                                                                                                                        Field<T12> field12,
                                                                                                                                                                                                        Field<T13> field13,
                                                                                                                                                                                                        Field<T14> field14,
                                                                                                                                                                                                        Field<T15> field15,
                                                                                                                                                                                                        Field<T16> field16,
                                                                                                                                                                                                        Field<T17> field17,
                                                                                                                                                                                                        Field<T18> field18,
                                                                                                                                                                                                        Field<T19> field19,
                                                                                                                                                                                                        Field<T20> field20)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row20.in(Select), Row20.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field19, field20)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> selectDistinct(Field<T1> field1,
                                                                                                                                                                                                                Field<T2> field2,
                                                                                                                                                                                                                Field<T3> field3,
                                                                                                                                                                                                                Field<T4> field4,
                                                                                                                                                                                                                Field<T5> field5,
                                                                                                                                                                                                                Field<T6> field6,
                                                                                                                                                                                                                Field<T7> field7,
                                                                                                                                                                                                                Field<T8> field8,
                                                                                                                                                                                                                Field<T9> field9,
                                                                                                                                                                                                                Field<T10> field10,
                                                                                                                                                                                                                Field<T11> field11,
                                                                                                                                                                                                                Field<T12> field12,
                                                                                                                                                                                                                Field<T13> field13,
                                                                                                                                                                                                                Field<T14> field14,
                                                                                                                                                                                                                Field<T15> field15,
                                                                                                                                                                                                                Field<T16> field16,
                                                                                                                                                                                                                Field<T17> field17,
                                                                                                                                                                                                                Field<T18> field18,
                                                                                                                                                                                                                Field<T19> field19,
                                                                                                                                                                                                                Field<T20> field20,
                                                                                                                                                                                                                Field<T21> field21)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row21.in(Select), Row21.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field20, field21)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
public <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> SelectSelectStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> selectDistinct(Field<T1> field1,
                                                                                                                                                                                                                        Field<T2> field2,
                                                                                                                                                                                                                        Field<T3> field3,
                                                                                                                                                                                                                        Field<T4> field4,
                                                                                                                                                                                                                        Field<T5> field5,
                                                                                                                                                                                                                        Field<T6> field6,
                                                                                                                                                                                                                        Field<T7> field7,
                                                                                                                                                                                                                        Field<T8> field8,
                                                                                                                                                                                                                        Field<T9> field9,
                                                                                                                                                                                                                        Field<T10> field10,
                                                                                                                                                                                                                        Field<T11> field11,
                                                                                                                                                                                                                        Field<T12> field12,
                                                                                                                                                                                                                        Field<T13> field13,
                                                                                                                                                                                                                        Field<T14> field14,
                                                                                                                                                                                                                        Field<T15> field15,
                                                                                                                                                                                                                        Field<T16> field16,
                                                                                                                                                                                                                        Field<T17> field17,
                                                                                                                                                                                                                        Field<T18> field18,
                                                                                                                                                                                                                        Field<T19> field19,
                                                                                                                                                                                                                        Field<T20> field20,
                                                                                                                                                                                                                        Field<T21> field21,
                                                                                                                                                                                                                        Field<T22> field22)

Description copied from interface: DSLContext

Create a new DSL select statement.

This is the same as DSLContext.selectDistinct(Field...), except that it declares additional record-level typesafety, which is needed by Row22.in(Select), Row22.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) instead.

Example:

 using(configuration)
       .selectDistinct(field1, field2, field3, .., field21, field22)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectDistinct in interface DSLContext

See Also:

DSL.selectDistinct(Field...), DSLContext.selectDistinct(Field...)

selectZero

public SelectSelectStep<Record1<Integer>> selectZero()

Description copied from interface: DSLContext

Create a new DSL select statement for constant 0 literal

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectZero() instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.selectZero()
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectZero in interface DSLContext

See Also:

DSL.zero(), DSL.selectZero()

selectOne

public SelectSelectStep<Record1<Integer>> selectOne()

Description copied from interface: DSLContext

Create a new DSL select statement for constant 1 literal

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectOne() instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.selectOne()
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectOne in interface DSLContext

See Also:

DSL.one(), DSL.selectOne()

selectCount

public SelectSelectStep<Record1<Integer>> selectCount()

Description copied from interface: DSLContext

Create a new DSL select statement for COUNT(*)

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectCount() instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.selectCount()
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

Specified by:

selectCount in interface DSLContext

See Also:

DSL.selectCount()

selectQuery

public SelectQuery<Record> selectQuery()

Description copied from interface: DSLContext

Create a new SelectQuery

Specified by:

selectQuery in interface DSLContext

selectQuery

public <R extends Record> SelectQuery<R> selectQuery(TableLike<R> table)

Description copied from interface: DSLContext

Create a new SelectQuery

Specified by:

selectQuery in interface DSLContext

Parameters:

table - The table to select data from

Returns:

The new SelectQuery

insertQuery

public <R extends Record> InsertQuery<R> insertQuery(Table<R> into)

Description copied from interface: DSLContext

Create a new InsertQuery

Specified by:

insertQuery in interface DSLContext

Parameters:

into - The table to insert data into

Returns:

The new InsertQuery

insertInto

public <R extends Record> InsertSetStep<R> insertInto(Table<R> into)

Description copied from interface: DSLContext

Create a new DSL insert statement. This type of insert may feel more convenient to some users, as it uses the UPDATE statement's SET a = b syntax.

Example:

 DSLContext create = DSL.using(configuration);

 create.insertInto(table)
       .set(field1, value1)
       .set(field2, value2)
       .newRecord()
       .set(field1, value3)
       .set(field2, value4)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1> InsertValuesStep1<R,T1> insertInto(Table<R> into,
                                                                      Field<T1> field1)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1)
       .values(field1)
       .values(field1)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2> InsertValuesStep2<R,T1,T2> insertInto(Table<R> into,
                                                                            Field<T1> field1,
                                                                            Field<T2> field2)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2)
       .values(field1, field2)
       .values(field1, field2)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3> InsertValuesStep3<R,T1,T2,T3> insertInto(Table<R> into,
                                                                                  Field<T1> field1,
                                                                                  Field<T2> field2,
                                                                                  Field<T3> field3)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3)
       .values(field1, field2, field3)
       .values(field1, field2, field3)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4> InsertValuesStep4<R,T1,T2,T3,T4> insertInto(Table<R> into,
                                                                                        Field<T1> field1,
                                                                                        Field<T2> field2,
                                                                                        Field<T3> field3,
                                                                                        Field<T4> field4)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, field4)
       .values(field1, field2, field3, field4)
       .values(field1, field2, field3, field4)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5> InsertValuesStep5<R,T1,T2,T3,T4,T5> insertInto(Table<R> into,
                                                                                              Field<T1> field1,
                                                                                              Field<T2> field2,
                                                                                              Field<T3> field3,
                                                                                              Field<T4> field4,
                                                                                              Field<T5> field5)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, field4, field5)
       .values(field1, field2, field3, field4, field5)
       .values(field1, field2, field3, field4, field5)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6> InsertValuesStep6<R,T1,T2,T3,T4,T5,T6> insertInto(Table<R> into,
                                                                                                    Field<T1> field1,
                                                                                                    Field<T2> field2,
                                                                                                    Field<T3> field3,
                                                                                                    Field<T4> field4,
                                                                                                    Field<T5> field5,
                                                                                                    Field<T6> field6)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field5, field6)
       .values(valueA1, valueA2, valueA3, .., valueA5, valueA6)
       .values(valueB1, valueB2, valueB3, .., valueB5, valueB6)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7> InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7> insertInto(Table<R> into,
                                                                                                          Field<T1> field1,
                                                                                                          Field<T2> field2,
                                                                                                          Field<T3> field3,
                                                                                                          Field<T4> field4,
                                                                                                          Field<T5> field5,
                                                                                                          Field<T6> field6,
                                                                                                          Field<T7> field7)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field6, field7)
       .values(valueA1, valueA2, valueA3, .., valueA6, valueA7)
       .values(valueB1, valueB2, valueB3, .., valueB6, valueB7)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8> insertInto(Table<R> into,
                                                                                                                Field<T1> field1,
                                                                                                                Field<T2> field2,
                                                                                                                Field<T3> field3,
                                                                                                                Field<T4> field4,
                                                                                                                Field<T5> field5,
                                                                                                                Field<T6> field6,
                                                                                                                Field<T7> field7,
                                                                                                                Field<T8> field8)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field7, field8)
       .values(valueA1, valueA2, valueA3, .., valueA7, valueA8)
       .values(valueB1, valueB2, valueB3, .., valueB7, valueB8)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9> insertInto(Table<R> into,
                                                                                                                      Field<T1> field1,
                                                                                                                      Field<T2> field2,
                                                                                                                      Field<T3> field3,
                                                                                                                      Field<T4> field4,
                                                                                                                      Field<T5> field5,
                                                                                                                      Field<T6> field6,
                                                                                                                      Field<T7> field7,
                                                                                                                      Field<T8> field8,
                                                                                                                      Field<T9> field9)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field8, field9)
       .values(valueA1, valueA2, valueA3, .., valueA8, valueA9)
       .values(valueB1, valueB2, valueB3, .., valueB8, valueB9)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> insertInto(Table<R> into,
                                                                                                                               Field<T1> field1,
                                                                                                                               Field<T2> field2,
                                                                                                                               Field<T3> field3,
                                                                                                                               Field<T4> field4,
                                                                                                                               Field<T5> field5,
                                                                                                                               Field<T6> field6,
                                                                                                                               Field<T7> field7,
                                                                                                                               Field<T8> field8,
                                                                                                                               Field<T9> field9,
                                                                                                                               Field<T10> field10)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field9, field10)
       .values(valueA1, valueA2, valueA3, .., valueA9, valueA10)
       .values(valueB1, valueB2, valueB3, .., valueB9, valueB10)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> insertInto(Table<R> into,
                                                                                                                                       Field<T1> field1,
                                                                                                                                       Field<T2> field2,
                                                                                                                                       Field<T3> field3,
                                                                                                                                       Field<T4> field4,
                                                                                                                                       Field<T5> field5,
                                                                                                                                       Field<T6> field6,
                                                                                                                                       Field<T7> field7,
                                                                                                                                       Field<T8> field8,
                                                                                                                                       Field<T9> field9,
                                                                                                                                       Field<T10> field10,
                                                                                                                                       Field<T11> field11)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field10, field11)
       .values(valueA1, valueA2, valueA3, .., valueA10, valueA11)
       .values(valueB1, valueB2, valueB3, .., valueB10, valueB11)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> insertInto(Table<R> into,
                                                                                                                                               Field<T1> field1,
                                                                                                                                               Field<T2> field2,
                                                                                                                                               Field<T3> field3,
                                                                                                                                               Field<T4> field4,
                                                                                                                                               Field<T5> field5,
                                                                                                                                               Field<T6> field6,
                                                                                                                                               Field<T7> field7,
                                                                                                                                               Field<T8> field8,
                                                                                                                                               Field<T9> field9,
                                                                                                                                               Field<T10> field10,
                                                                                                                                               Field<T11> field11,
                                                                                                                                               Field<T12> field12)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field11, field12)
       .values(valueA1, valueA2, valueA3, .., valueA11, valueA12)
       .values(valueB1, valueB2, valueB3, .., valueB11, valueB12)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> insertInto(Table<R> into,
                                                                                                                                                       Field<T1> field1,
                                                                                                                                                       Field<T2> field2,
                                                                                                                                                       Field<T3> field3,
                                                                                                                                                       Field<T4> field4,
                                                                                                                                                       Field<T5> field5,
                                                                                                                                                       Field<T6> field6,
                                                                                                                                                       Field<T7> field7,
                                                                                                                                                       Field<T8> field8,
                                                                                                                                                       Field<T9> field9,
                                                                                                                                                       Field<T10> field10,
                                                                                                                                                       Field<T11> field11,
                                                                                                                                                       Field<T12> field12,
                                                                                                                                                       Field<T13> field13)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field12, field13)
       .values(valueA1, valueA2, valueA3, .., valueA12, valueA13)
       .values(valueB1, valueB2, valueB3, .., valueB12, valueB13)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> insertInto(Table<R> into,
                                                                                                                                                               Field<T1> field1,
                                                                                                                                                               Field<T2> field2,
                                                                                                                                                               Field<T3> field3,
                                                                                                                                                               Field<T4> field4,
                                                                                                                                                               Field<T5> field5,
                                                                                                                                                               Field<T6> field6,
                                                                                                                                                               Field<T7> field7,
                                                                                                                                                               Field<T8> field8,
                                                                                                                                                               Field<T9> field9,
                                                                                                                                                               Field<T10> field10,
                                                                                                                                                               Field<T11> field11,
                                                                                                                                                               Field<T12> field12,
                                                                                                                                                               Field<T13> field13,
                                                                                                                                                               Field<T14> field14)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field13, field14)
       .values(valueA1, valueA2, valueA3, .., valueA13, valueA14)
       .values(valueB1, valueB2, valueB3, .., valueB13, valueB14)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> insertInto(Table<R> into,
                                                                                                                                                                       Field<T1> field1,
                                                                                                                                                                       Field<T2> field2,
                                                                                                                                                                       Field<T3> field3,
                                                                                                                                                                       Field<T4> field4,
                                                                                                                                                                       Field<T5> field5,
                                                                                                                                                                       Field<T6> field6,
                                                                                                                                                                       Field<T7> field7,
                                                                                                                                                                       Field<T8> field8,
                                                                                                                                                                       Field<T9> field9,
                                                                                                                                                                       Field<T10> field10,
                                                                                                                                                                       Field<T11> field11,
                                                                                                                                                                       Field<T12> field12,
                                                                                                                                                                       Field<T13> field13,
                                                                                                                                                                       Field<T14> field14,
                                                                                                                                                                       Field<T15> field15)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field14, field15)
       .values(valueA1, valueA2, valueA3, .., valueA14, valueA15)
       .values(valueB1, valueB2, valueB3, .., valueB14, valueB15)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> insertInto(Table<R> into,
                                                                                                                                                                               Field<T1> field1,
                                                                                                                                                                               Field<T2> field2,
                                                                                                                                                                               Field<T3> field3,
                                                                                                                                                                               Field<T4> field4,
                                                                                                                                                                               Field<T5> field5,
                                                                                                                                                                               Field<T6> field6,
                                                                                                                                                                               Field<T7> field7,
                                                                                                                                                                               Field<T8> field8,
                                                                                                                                                                               Field<T9> field9,
                                                                                                                                                                               Field<T10> field10,
                                                                                                                                                                               Field<T11> field11,
                                                                                                                                                                               Field<T12> field12,
                                                                                                                                                                               Field<T13> field13,
                                                                                                                                                                               Field<T14> field14,
                                                                                                                                                                               Field<T15> field15,
                                                                                                                                                                               Field<T16> field16)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field15, field16)
       .values(valueA1, valueA2, valueA3, .., valueA15, valueA16)
       .values(valueB1, valueB2, valueB3, .., valueB15, valueB16)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> insertInto(Table<R> into,
                                                                                                                                                                                       Field<T1> field1,
                                                                                                                                                                                       Field<T2> field2,
                                                                                                                                                                                       Field<T3> field3,
                                                                                                                                                                                       Field<T4> field4,
                                                                                                                                                                                       Field<T5> field5,
                                                                                                                                                                                       Field<T6> field6,
                                                                                                                                                                                       Field<T7> field7,
                                                                                                                                                                                       Field<T8> field8,
                                                                                                                                                                                       Field<T9> field9,
                                                                                                                                                                                       Field<T10> field10,
                                                                                                                                                                                       Field<T11> field11,
                                                                                                                                                                                       Field<T12> field12,
                                                                                                                                                                                       Field<T13> field13,
                                                                                                                                                                                       Field<T14> field14,
                                                                                                                                                                                       Field<T15> field15,
                                                                                                                                                                                       Field<T16> field16,
                                                                                                                                                                                       Field<T17> field17)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field16, field17)
       .values(valueA1, valueA2, valueA3, .., valueA16, valueA17)
       .values(valueB1, valueB2, valueB3, .., valueB16, valueB17)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> insertInto(Table<R> into,
                                                                                                                                                                                               Field<T1> field1,
                                                                                                                                                                                               Field<T2> field2,
                                                                                                                                                                                               Field<T3> field3,
                                                                                                                                                                                               Field<T4> field4,
                                                                                                                                                                                               Field<T5> field5,
                                                                                                                                                                                               Field<T6> field6,
                                                                                                                                                                                               Field<T7> field7,
                                                                                                                                                                                               Field<T8> field8,
                                                                                                                                                                                               Field<T9> field9,
                                                                                                                                                                                               Field<T10> field10,
                                                                                                                                                                                               Field<T11> field11,
                                                                                                                                                                                               Field<T12> field12,
                                                                                                                                                                                               Field<T13> field13,
                                                                                                                                                                                               Field<T14> field14,
                                                                                                                                                                                               Field<T15> field15,
                                                                                                                                                                                               Field<T16> field16,
                                                                                                                                                                                               Field<T17> field17,
                                                                                                                                                                                               Field<T18> field18)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field17, field18)
       .values(valueA1, valueA2, valueA3, .., valueA17, valueA18)
       .values(valueB1, valueB2, valueB3, .., valueB17, valueB18)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> insertInto(Table<R> into,
                                                                                                                                                                                                       Field<T1> field1,
                                                                                                                                                                                                       Field<T2> field2,
                                                                                                                                                                                                       Field<T3> field3,
                                                                                                                                                                                                       Field<T4> field4,
                                                                                                                                                                                                       Field<T5> field5,
                                                                                                                                                                                                       Field<T6> field6,
                                                                                                                                                                                                       Field<T7> field7,
                                                                                                                                                                                                       Field<T8> field8,
                                                                                                                                                                                                       Field<T9> field9,
                                                                                                                                                                                                       Field<T10> field10,
                                                                                                                                                                                                       Field<T11> field11,
                                                                                                                                                                                                       Field<T12> field12,
                                                                                                                                                                                                       Field<T13> field13,
                                                                                                                                                                                                       Field<T14> field14,
                                                                                                                                                                                                       Field<T15> field15,
                                                                                                                                                                                                       Field<T16> field16,
                                                                                                                                                                                                       Field<T17> field17,
                                                                                                                                                                                                       Field<T18> field18,
                                                                                                                                                                                                       Field<T19> field19)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field18, field19)
       .values(valueA1, valueA2, valueA3, .., valueA18, valueA19)
       .values(valueB1, valueB2, valueB3, .., valueB18, valueB19)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> insertInto(Table<R> into,
                                                                                                                                                                                                               Field<T1> field1,
                                                                                                                                                                                                               Field<T2> field2,
                                                                                                                                                                                                               Field<T3> field3,
                                                                                                                                                                                                               Field<T4> field4,
                                                                                                                                                                                                               Field<T5> field5,
                                                                                                                                                                                                               Field<T6> field6,
                                                                                                                                                                                                               Field<T7> field7,
                                                                                                                                                                                                               Field<T8> field8,
                                                                                                                                                                                                               Field<T9> field9,
                                                                                                                                                                                                               Field<T10> field10,
                                                                                                                                                                                                               Field<T11> field11,
                                                                                                                                                                                                               Field<T12> field12,
                                                                                                                                                                                                               Field<T13> field13,
                                                                                                                                                                                                               Field<T14> field14,
                                                                                                                                                                                                               Field<T15> field15,
                                                                                                                                                                                                               Field<T16> field16,
                                                                                                                                                                                                               Field<T17> field17,
                                                                                                                                                                                                               Field<T18> field18,
                                                                                                                                                                                                               Field<T19> field19,
                                                                                                                                                                                                               Field<T20> field20)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field19, field20)
       .values(valueA1, valueA2, valueA3, .., valueA19, valueA20)
       .values(valueB1, valueB2, valueB3, .., valueB19, valueB20)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> insertInto(Table<R> into,
                                                                                                                                                                                                                       Field<T1> field1,
                                                                                                                                                                                                                       Field<T2> field2,
                                                                                                                                                                                                                       Field<T3> field3,
                                                                                                                                                                                                                       Field<T4> field4,
                                                                                                                                                                                                                       Field<T5> field5,
                                                                                                                                                                                                                       Field<T6> field6,
                                                                                                                                                                                                                       Field<T7> field7,
                                                                                                                                                                                                                       Field<T8> field8,
                                                                                                                                                                                                                       Field<T9> field9,
                                                                                                                                                                                                                       Field<T10> field10,
                                                                                                                                                                                                                       Field<T11> field11,
                                                                                                                                                                                                                       Field<T12> field12,
                                                                                                                                                                                                                       Field<T13> field13,
                                                                                                                                                                                                                       Field<T14> field14,
                                                                                                                                                                                                                       Field<T15> field15,
                                                                                                                                                                                                                       Field<T16> field16,
                                                                                                                                                                                                                       Field<T17> field17,
                                                                                                                                                                                                                       Field<T18> field18,
                                                                                                                                                                                                                       Field<T19> field19,
                                                                                                                                                                                                                       Field<T20> field20,
                                                                                                                                                                                                                       Field<T21> field21)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field20, field21)
       .values(valueA1, valueA2, valueA3, .., valueA20, valueA21)
       .values(valueB1, valueB2, valueB3, .., valueB20, valueB21)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> insertInto(Table<R> into,
                                                                                                                                                                                                                               Field<T1> field1,
                                                                                                                                                                                                                               Field<T2> field2,
                                                                                                                                                                                                                               Field<T3> field3,
                                                                                                                                                                                                                               Field<T4> field4,
                                                                                                                                                                                                                               Field<T5> field5,
                                                                                                                                                                                                                               Field<T6> field6,
                                                                                                                                                                                                                               Field<T7> field7,
                                                                                                                                                                                                                               Field<T8> field8,
                                                                                                                                                                                                                               Field<T9> field9,
                                                                                                                                                                                                                               Field<T10> field10,
                                                                                                                                                                                                                               Field<T11> field11,
                                                                                                                                                                                                                               Field<T12> field12,
                                                                                                                                                                                                                               Field<T13> field13,
                                                                                                                                                                                                                               Field<T14> field14,
                                                                                                                                                                                                                               Field<T15> field15,
                                                                                                                                                                                                                               Field<T16> field16,
                                                                                                                                                                                                                               Field<T17> field17,
                                                                                                                                                                                                                               Field<T18> field18,
                                                                                                                                                                                                                               Field<T19> field19,
                                                                                                                                                                                                                               Field<T20> field20,
                                                                                                                                                                                                                               Field<T21> field21,
                                                                                                                                                                                                                               Field<T22> field22)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 using(configuration)
       .insertInto(table, field1, field2, field3, .., field21, field22)
       .values(valueA1, valueA2, valueA3, .., valueA21, valueA22)
       .values(valueB1, valueB2, valueB3, .., valueB21, valueB22)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

public <R extends Record> InsertValuesStepN<R> insertInto(Table<R> into,
                                                 Field<?>... fields)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 DSLContext create = DSL.using(configuration);

 create.insertInto(table, field1, field2)
       .values(value1, value2)
       .values(value3, value4)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

insertInto

public <R extends Record> InsertValuesStepN<R> insertInto(Table<R> into,
                                                 Collection<? extends Field<?>> fields)

Description copied from interface: DSLContext

Create a new DSL insert statement.

Example:

 DSLContext create = DSL.using(configuration);

 create.insertInto(table, field1, field2)
       .values(value1, value2)
       .values(value3, value4)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Specified by:

insertInto in interface DSLContext

updateQuery

public <R extends Record> UpdateQuery<R> updateQuery(Table<R> table)

Description copied from interface: DSLContext

Create a new UpdateQuery

Specified by:

updateQuery in interface DSLContext

Parameters:

table - The table to update data into

Returns:

The new UpdateQuery

update

public <R extends Record> UpdateSetFirstStep<R> update(Table<R> table)

Description copied from interface: DSLContext

Create a new DSL update statement.

Example:

 DSLContext create = DSL.using(configuration);

 create.update(table)
       .set(field1, value1)
       .set(field2, value2)
       .where(field1.greaterThan(100))
       .execute();
 

Note that some databases support table expressions more complex than simple table references. In CUBRID and MySQL, for instance, you can write

 create.update(t1.join(t2).on(t1.id.eq(t2.id)))
       .set(t1.value, value1)
       .set(t2.value, value2)
       .where(t1.id.eq(10))
       .execute();
 

Specified by:

update in interface DSLContext

mergeInto

public <R extends Record> MergeUsingStep<R> mergeInto(Table<R> table)

Description copied from interface: DSLContext

Create a new DSL SQL standard MERGE statement.

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

dialect	support type	documentation
CUBRID	SQL:2008 standard and some enhancements	http://www.cubrid.org/manual/90/en/MERGE
DB2	SQL:2008 standard and major enhancements	http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com. ibm.db2.udb.admin.doc/doc/r0010873.htm
HSQLDB	SQL:2008 standard	http://hsqldb.org/doc/2.0/guide/dataaccess-chapt.html#N129BA
Oracle	SQL:2008 standard and minor enhancements	http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/ statements_9016.htm
SQL Server	Similar to SQL:2008 standard with some major enhancements	http://msdn.microsoft.com/de-de/library/bb510625.aspx
Sybase	Similar to SQL:2008 standard with some major enhancements	http://dcx.sybase.com/1100/en/dbreference_en11/merge-statement.html

Example:

 DSLContext create = DSL.using(configuration);

 create.mergeInto(table)
       .using(select)
       .on(condition)
       .whenMatchedThenUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .whenNotMatchedThenInsert(field1, field2)
       .values(value1, value2)
       .execute();
 

Note: Using this method, you can also create an H2-specific MERGE statement without field specification. See also DSLContext.mergeInto(Table, Field...)

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1> MergeKeyStep1<R,T1> mergeInto(Table<R> table,
                                                                 Field<T1> field1)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2> MergeKeyStep2<R,T1,T2> mergeInto(Table<R> table,
                                                                       Field<T1> field1,
                                                                       Field<T2> field2)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3> MergeKeyStep3<R,T1,T2,T3> mergeInto(Table<R> table,
                                                                             Field<T1> field1,
                                                                             Field<T2> field2,
                                                                             Field<T3> field3)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4> MergeKeyStep4<R,T1,T2,T3,T4> mergeInto(Table<R> table,
                                                                                   Field<T1> field1,
                                                                                   Field<T2> field2,
                                                                                   Field<T3> field3,
                                                                                   Field<T4> field4)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5> MergeKeyStep5<R,T1,T2,T3,T4,T5> mergeInto(Table<R> table,
                                                                                         Field<T1> field1,
                                                                                         Field<T2> field2,
                                                                                         Field<T3> field3,
                                                                                         Field<T4> field4,
                                                                                         Field<T5> field5)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6> MergeKeyStep6<R,T1,T2,T3,T4,T5,T6> mergeInto(Table<R> table,
                                                                                               Field<T1> field1,
                                                                                               Field<T2> field2,
                                                                                               Field<T3> field3,
                                                                                               Field<T4> field4,
                                                                                               Field<T5> field5,
                                                                                               Field<T6> field6)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7> MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7> mergeInto(Table<R> table,
                                                                                                     Field<T1> field1,
                                                                                                     Field<T2> field2,
                                                                                                     Field<T3> field3,
                                                                                                     Field<T4> field4,
                                                                                                     Field<T5> field5,
                                                                                                     Field<T6> field6,
                                                                                                     Field<T7> field7)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8> mergeInto(Table<R> table,
                                                                                                           Field<T1> field1,
                                                                                                           Field<T2> field2,
                                                                                                           Field<T3> field3,
                                                                                                           Field<T4> field4,
                                                                                                           Field<T5> field5,
                                                                                                           Field<T6> field6,
                                                                                                           Field<T7> field7,
                                                                                                           Field<T8> field8)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9> mergeInto(Table<R> table,
                                                                                                                 Field<T1> field1,
                                                                                                                 Field<T2> field2,
                                                                                                                 Field<T3> field3,
                                                                                                                 Field<T4> field4,
                                                                                                                 Field<T5> field5,
                                                                                                                 Field<T6> field6,
                                                                                                                 Field<T7> field7,
                                                                                                                 Field<T8> field8,
                                                                                                                 Field<T9> field9)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> mergeInto(Table<R> table,
                                                                                                                          Field<T1> field1,
                                                                                                                          Field<T2> field2,
                                                                                                                          Field<T3> field3,
                                                                                                                          Field<T4> field4,
                                                                                                                          Field<T5> field5,
                                                                                                                          Field<T6> field6,
                                                                                                                          Field<T7> field7,
                                                                                                                          Field<T8> field8,
                                                                                                                          Field<T9> field9,
                                                                                                                          Field<T10> field10)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> mergeInto(Table<R> table,
                                                                                                                                  Field<T1> field1,
                                                                                                                                  Field<T2> field2,
                                                                                                                                  Field<T3> field3,
                                                                                                                                  Field<T4> field4,
                                                                                                                                  Field<T5> field5,
                                                                                                                                  Field<T6> field6,
                                                                                                                                  Field<T7> field7,
                                                                                                                                  Field<T8> field8,
                                                                                                                                  Field<T9> field9,
                                                                                                                                  Field<T10> field10,
                                                                                                                                  Field<T11> field11)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> mergeInto(Table<R> table,
                                                                                                                                          Field<T1> field1,
                                                                                                                                          Field<T2> field2,
                                                                                                                                          Field<T3> field3,
                                                                                                                                          Field<T4> field4,
                                                                                                                                          Field<T5> field5,
                                                                                                                                          Field<T6> field6,
                                                                                                                                          Field<T7> field7,
                                                                                                                                          Field<T8> field8,
                                                                                                                                          Field<T9> field9,
                                                                                                                                          Field<T10> field10,
                                                                                                                                          Field<T11> field11,
                                                                                                                                          Field<T12> field12)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> mergeInto(Table<R> table,
                                                                                                                                                  Field<T1> field1,
                                                                                                                                                  Field<T2> field2,
                                                                                                                                                  Field<T3> field3,
                                                                                                                                                  Field<T4> field4,
                                                                                                                                                  Field<T5> field5,
                                                                                                                                                  Field<T6> field6,
                                                                                                                                                  Field<T7> field7,
                                                                                                                                                  Field<T8> field8,
                                                                                                                                                  Field<T9> field9,
                                                                                                                                                  Field<T10> field10,
                                                                                                                                                  Field<T11> field11,
                                                                                                                                                  Field<T12> field12,
                                                                                                                                                  Field<T13> field13)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> mergeInto(Table<R> table,
                                                                                                                                                          Field<T1> field1,
                                                                                                                                                          Field<T2> field2,
                                                                                                                                                          Field<T3> field3,
                                                                                                                                                          Field<T4> field4,
                                                                                                                                                          Field<T5> field5,
                                                                                                                                                          Field<T6> field6,
                                                                                                                                                          Field<T7> field7,
                                                                                                                                                          Field<T8> field8,
                                                                                                                                                          Field<T9> field9,
                                                                                                                                                          Field<T10> field10,
                                                                                                                                                          Field<T11> field11,
                                                                                                                                                          Field<T12> field12,
                                                                                                                                                          Field<T13> field13,
                                                                                                                                                          Field<T14> field14)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> mergeInto(Table<R> table,
                                                                                                                                                                  Field<T1> field1,
                                                                                                                                                                  Field<T2> field2,
                                                                                                                                                                  Field<T3> field3,
                                                                                                                                                                  Field<T4> field4,
                                                                                                                                                                  Field<T5> field5,
                                                                                                                                                                  Field<T6> field6,
                                                                                                                                                                  Field<T7> field7,
                                                                                                                                                                  Field<T8> field8,
                                                                                                                                                                  Field<T9> field9,
                                                                                                                                                                  Field<T10> field10,
                                                                                                                                                                  Field<T11> field11,
                                                                                                                                                                  Field<T12> field12,
                                                                                                                                                                  Field<T13> field13,
                                                                                                                                                                  Field<T14> field14,
                                                                                                                                                                  Field<T15> field15)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> mergeInto(Table<R> table,
                                                                                                                                                                          Field<T1> field1,
                                                                                                                                                                          Field<T2> field2,
                                                                                                                                                                          Field<T3> field3,
                                                                                                                                                                          Field<T4> field4,
                                                                                                                                                                          Field<T5> field5,
                                                                                                                                                                          Field<T6> field6,
                                                                                                                                                                          Field<T7> field7,
                                                                                                                                                                          Field<T8> field8,
                                                                                                                                                                          Field<T9> field9,
                                                                                                                                                                          Field<T10> field10,
                                                                                                                                                                          Field<T11> field11,
                                                                                                                                                                          Field<T12> field12,
                                                                                                                                                                          Field<T13> field13,
                                                                                                                                                                          Field<T14> field14,
                                                                                                                                                                          Field<T15> field15,
                                                                                                                                                                          Field<T16> field16)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> mergeInto(Table<R> table,
                                                                                                                                                                                  Field<T1> field1,
                                                                                                                                                                                  Field<T2> field2,
                                                                                                                                                                                  Field<T3> field3,
                                                                                                                                                                                  Field<T4> field4,
                                                                                                                                                                                  Field<T5> field5,
                                                                                                                                                                                  Field<T6> field6,
                                                                                                                                                                                  Field<T7> field7,
                                                                                                                                                                                  Field<T8> field8,
                                                                                                                                                                                  Field<T9> field9,
                                                                                                                                                                                  Field<T10> field10,
                                                                                                                                                                                  Field<T11> field11,
                                                                                                                                                                                  Field<T12> field12,
                                                                                                                                                                                  Field<T13> field13,
                                                                                                                                                                                  Field<T14> field14,
                                                                                                                                                                                  Field<T15> field15,
                                                                                                                                                                                  Field<T16> field16,
                                                                                                                                                                                  Field<T17> field17)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> mergeInto(Table<R> table,
                                                                                                                                                                                          Field<T1> field1,
                                                                                                                                                                                          Field<T2> field2,
                                                                                                                                                                                          Field<T3> field3,
                                                                                                                                                                                          Field<T4> field4,
                                                                                                                                                                                          Field<T5> field5,
                                                                                                                                                                                          Field<T6> field6,
                                                                                                                                                                                          Field<T7> field7,
                                                                                                                                                                                          Field<T8> field8,
                                                                                                                                                                                          Field<T9> field9,
                                                                                                                                                                                          Field<T10> field10,
                                                                                                                                                                                          Field<T11> field11,
                                                                                                                                                                                          Field<T12> field12,
                                                                                                                                                                                          Field<T13> field13,
                                                                                                                                                                                          Field<T14> field14,
                                                                                                                                                                                          Field<T15> field15,
                                                                                                                                                                                          Field<T16> field16,
                                                                                                                                                                                          Field<T17> field17,
                                                                                                                                                                                          Field<T18> field18)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> mergeInto(Table<R> table,
                                                                                                                                                                                                  Field<T1> field1,
                                                                                                                                                                                                  Field<T2> field2,
                                                                                                                                                                                                  Field<T3> field3,
                                                                                                                                                                                                  Field<T4> field4,
                                                                                                                                                                                                  Field<T5> field5,
                                                                                                                                                                                                  Field<T6> field6,
                                                                                                                                                                                                  Field<T7> field7,
                                                                                                                                                                                                  Field<T8> field8,
                                                                                                                                                                                                  Field<T9> field9,
                                                                                                                                                                                                  Field<T10> field10,
                                                                                                                                                                                                  Field<T11> field11,
                                                                                                                                                                                                  Field<T12> field12,
                                                                                                                                                                                                  Field<T13> field13,
                                                                                                                                                                                                  Field<T14> field14,
                                                                                                                                                                                                  Field<T15> field15,
                                                                                                                                                                                                  Field<T16> field16,
                                                                                                                                                                                                  Field<T17> field17,
                                                                                                                                                                                                  Field<T18> field18,
                                                                                                                                                                                                  Field<T19> field19)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> mergeInto(Table<R> table,
                                                                                                                                                                                                          Field<T1> field1,
                                                                                                                                                                                                          Field<T2> field2,
                                                                                                                                                                                                          Field<T3> field3,
                                                                                                                                                                                                          Field<T4> field4,
                                                                                                                                                                                                          Field<T5> field5,
                                                                                                                                                                                                          Field<T6> field6,
                                                                                                                                                                                                          Field<T7> field7,
                                                                                                                                                                                                          Field<T8> field8,
                                                                                                                                                                                                          Field<T9> field9,
                                                                                                                                                                                                          Field<T10> field10,
                                                                                                                                                                                                          Field<T11> field11,
                                                                                                                                                                                                          Field<T12> field12,
                                                                                                                                                                                                          Field<T13> field13,
                                                                                                                                                                                                          Field<T14> field14,
                                                                                                                                                                                                          Field<T15> field15,
                                                                                                                                                                                                          Field<T16> field16,
                                                                                                                                                                                                          Field<T17> field17,
                                                                                                                                                                                                          Field<T18> field18,
                                                                                                                                                                                                          Field<T19> field19,
                                                                                                                                                                                                          Field<T20> field20)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> mergeInto(Table<R> table,
                                                                                                                                                                                                                  Field<T1> field1,
                                                                                                                                                                                                                  Field<T2> field2,
                                                                                                                                                                                                                  Field<T3> field3,
                                                                                                                                                                                                                  Field<T4> field4,
                                                                                                                                                                                                                  Field<T5> field5,
                                                                                                                                                                                                                  Field<T6> field6,
                                                                                                                                                                                                                  Field<T7> field7,
                                                                                                                                                                                                                  Field<T8> field8,
                                                                                                                                                                                                                  Field<T9> field9,
                                                                                                                                                                                                                  Field<T10> field10,
                                                                                                                                                                                                                  Field<T11> field11,
                                                                                                                                                                                                                  Field<T12> field12,
                                                                                                                                                                                                                  Field<T13> field13,
                                                                                                                                                                                                                  Field<T14> field14,
                                                                                                                                                                                                                  Field<T15> field15,
                                                                                                                                                                                                                  Field<T16> field16,
                                                                                                                                                                                                                  Field<T17> field17,
                                                                                                                                                                                                                  Field<T18> field18,
                                                                                                                                                                                                                  Field<T19> field19,
                                                                                                                                                                                                                  Field<T20> field20,
                                                                                                                                                                                                                  Field<T21> field21)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
public <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> mergeInto(Table<R> table,
                                                                                                                                                                                                                          Field<T1> field1,
                                                                                                                                                                                                                          Field<T2> field2,
                                                                                                                                                                                                                          Field<T3> field3,
                                                                                                                                                                                                                          Field<T4> field4,
                                                                                                                                                                                                                          Field<T5> field5,
                                                                                                                                                                                                                          Field<T6> field6,
                                                                                                                                                                                                                          Field<T7> field7,
                                                                                                                                                                                                                          Field<T8> field8,
                                                                                                                                                                                                                          Field<T9> field9,
                                                                                                                                                                                                                          Field<T10> field10,
                                                                                                                                                                                                                          Field<T11> field11,
                                                                                                                                                                                                                          Field<T12> field12,
                                                                                                                                                                                                                          Field<T13> field13,
                                                                                                                                                                                                                          Field<T14> field14,
                                                                                                                                                                                                                          Field<T15> field15,
                                                                                                                                                                                                                          Field<T16> field16,
                                                                                                                                                                                                                          Field<T17> field17,
                                                                                                                                                                                                                          Field<T18> field18,
                                                                                                                                                                                                                          Field<T19> field19,
                                                                                                                                                                                                                          Field<T20> field20,
                                                                                                                                                                                                                          Field<T21> field21,
                                                                                                                                                                                                                          Field<T22> field22)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

public <R extends Record> MergeKeyStepN<R> mergeInto(Table<R> table,
                                            Field<?>... fields)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

Specified by:

mergeInto in interface DSLContext

mergeInto

public <R extends Record> MergeKeyStepN<R> mergeInto(Table<R> table,
                                            Collection<? extends Field<?>> fields)

Description copied from interface: DSLContext

Create a new DSL merge statement (H2-specific syntax)

Specified by:

mergeInto in interface DSLContext

See Also:

DSLContext.mergeInto(Table, Field...)

deleteQuery

public <R extends Record> DeleteQuery<R> deleteQuery(Table<R> table)

Description copied from interface: DSLContext

Create a new DeleteQuery

Specified by:

deleteQuery in interface DSLContext

Parameters:

table - The table to delete data from

Returns:

The new DeleteQuery

delete

public <R extends Record> DeleteWhereStep<R> delete(Table<R> table)

Description copied from interface: DSLContext

Create a new DSL delete statement.

Example:

 DSLContext create = DSL.using(configuration);

 create.delete(table)
       .where(field1.greaterThan(100))
       .execute();
 

Some but not all databases support aliased tables in delete statements.

Specified by:

delete in interface DSLContext

batch

public Batch batch(Query... queries)

Description copied from interface: DSLContext

Execute a set of queries in batch mode (without bind values).

This essentially runs the following logic:

 Statement s = connection.createStatement();

 for (Query query : queries) {
     s.addBatch(query.getSQL(true));
 }

 s.execute();
 

Specified by:

batch in interface DSLContext

See Also:

Statement.executeBatch()

batch

public Batch batch(String... queries)

Description copied from interface: DSLContext

Execute a set of queries in batch mode (without bind values).

This is a convenience method for calling

batch(query(queries[0]), query(queries[1]), ...)

.

Specified by:

batch in interface DSLContext

See Also:

DSLContext.query(String), DSLContext.batch(Query...), Statement.executeBatch()

batch

public Batch batch(Collection<? extends Query> queries)

Description copied from interface: DSLContext

Execute a set of queries in batch mode (without bind values).

This essentially runs the following logic:

 Statement s = connection.createStatement();

 for (Query query : queries) {
     s.addBatch(query.getSQL(true));
 }

 s.execute();
 

Specified by:

batch in interface DSLContext

See Also:

Statement.executeBatch()

batch

public BatchBindStep batch(Query query)

Description copied from interface: DSLContext

Execute a set of queries in batch mode (with bind values).

When running

 create.batch(query)
       .bind(valueA1, valueA2)
       .bind(valueB1, valueB2)
       .execute();
 

This essentially runs the following logic:

 Statement s = connection.prepareStatement(query.getSQL(false));

 for (Object[] bindValues : allBindValues) {
     for (Object bindValue : bindValues) {
         s.setXXX(bindValue);
     }

     s.addBatch();
 }

 s.execute();
 

Note: bind values will be inlined to a static batch query as in DSLContext.batch(Query...), if you choose to execute queries with Settings.getStatementType() == StatementType.STATIC_STATEMENT

Specified by:

batch in interface DSLContext

See Also:

Statement.executeBatch()

batch

public BatchBindStep batch(String sql)

Description copied from interface: DSLContext

Execute a set of queries in batch mode (with bind values).

This is a convenience method for calling

batch(query(sql))

.

Specified by:

batch in interface DSLContext

See Also:

DSLContext.query(String), DSLContext.batch(Query), Statement.executeBatch()

batch

public Batch batch(Query query,
          Object[]... bindings)

Description copied from interface: DSLContext

Execute a set of queries in batch mode (with bind values).

This is a convenience method for calling DSLContext.batch(Query) and then binding values one by one using BatchBindStep.bind(Object...)

Note: bind values will be inlined to a static batch query as in DSLContext.batch(Query...), if you choose to execute queries with Settings.getStatementType() == StatementType.STATIC_STATEMENT

Specified by:

batch in interface DSLContext

See Also:

DSLContext.batch(Query), Statement.executeBatch()

batch

public Batch batch(String sql,
          Object[]... bindings)

Description copied from interface: DSLContext

Execute a set of queries in batch mode (with bind values).

This is a convenience method for calling

batch(query(sql), bindings)

.

Specified by:

batch in interface DSLContext

See Also:

DSLContext.query(String), DSLContext.batch(Query, Object[][]), Statement.executeBatch()

batchStore

public Batch batchStore(UpdatableRecord<?>... records)

Description copied from interface: DSLContext

Execute a set of INSERT and UPDATE queries in batch mode (with bind values).

This batch operation can be executed in two modes:

With Settings.getStatementType() == StatementType.PREPARED_STATEMENT (the default)

In this mode, record order is preserved as much as possible, as long as two subsequent records generate the same SQL (with bind variables). The number of executed batch operations corresponds to [number of distinct rendered SQL statements]. In the worst case, this corresponds to the number of total records.

The record type order is preserved in the way they are passed to this method. This is an example of how statements will be ordered:

 // Let's assume, odd numbers result in INSERTs and even numbers in UPDATES
 // Let's also assume a[n] are all of the same type, just as b[n], c[n]...
 int[] result = create.batchStore(a1, a2, a3, b1, a4, c1, b3, a5)
                      .execute();
 

The above results in result.length == 8 and the following 4 separate batch statements:

1. INSERT a1, a3, a5
2. UPDATE a2, a4
3. INSERT b1, b3
4. INSERT c1

With Settings.getStatementType() == StatementType.STATIC_STATEMENT

This mode may be better for large and complex batch store operations, as the order of records is preserved entirely, and jOOQ can guarantee that only a single batch statement is serialised to the database.

Specified by:

batchStore in interface DSLContext

See Also:

Statement.executeBatch()

batchStore

public Batch batchStore(Collection<? extends UpdatableRecord<?>> records)

Description copied from interface: DSLContext

Execute a set of INSERT and UPDATE queries in batch mode (with bind values).

Specified by:

batchStore in interface DSLContext

See Also:

DSLContext.batchStore(UpdatableRecord...), Statement.executeBatch()

batchInsert

public Batch batchInsert(UpdatableRecord<?>... records)

Description copied from interface: DSLContext

Execute a set of INSERT queries in batch mode (with bind values).

Specified by:

batchInsert in interface DSLContext

See Also:

DSLContext.batchStore(UpdatableRecord...), Statement.executeBatch()

batchInsert

public Batch batchInsert(Collection<? extends UpdatableRecord<?>> records)

Description copied from interface: DSLContext

Execute a set of INSERT queries in batch mode (with bind values).

Specified by:

batchInsert in interface DSLContext

See Also:

DSLContext.batchStore(UpdatableRecord...), Statement.executeBatch()

batchUpdate

public Batch batchUpdate(UpdatableRecord<?>... records)

Description copied from interface: DSLContext

Execute a set of UPDATE queries in batch mode (with bind values).

Specified by:

batchUpdate in interface DSLContext

See Also:

DSLContext.batchStore(UpdatableRecord...), Statement.executeBatch()

batchUpdate

public Batch batchUpdate(Collection<? extends UpdatableRecord<?>> records)

Description copied from interface: DSLContext

Execute a set of UPDATE queries in batch mode (with bind values).

Specified by:

batchUpdate in interface DSLContext

See Also:

DSLContext.batchStore(UpdatableRecord...), Statement.executeBatch()

batchDelete

public Batch batchDelete(UpdatableRecord<?>... records)

Description copied from interface: DSLContext

Execute a set of DELETE queries in batch mode (with bind values).

This batch operation can be executed in two modes:

With Settings.getStatementType() == StatementType.PREPARED_STATEMENT (the default)

In this mode, record order is preserved as much as possible, as long as two subsequent records generate the same SQL (with bind variables). The number of executed batch operations corresponds to [number of distinct rendered SQL statements]. In the worst case, this corresponds to the number of total records.

The record type order is preserved in the way they are passed to this method. This is an example of how statements will be ordered:

 // Let's assume a[n] are all of the same type, just as b[n], c[n]...
 int[] result = create.batchStore(a1, a2, a3, b1, a4, c1, c2, a5)
                      .execute();
 

The above results in result.length == 8 and the following 5 separate batch statements:

1. DELETE a1, a2, a3
2. DELETE b1
3. DELETE a4
4. DELETE c1, c2
5. DELETE a5

With Settings.getStatementType() == StatementType.STATIC_STATEMENT

This mode may be better for large and complex batch delete operations, as the order of records is preserved entirely, and jOOQ can guarantee that only a single batch statement is serialised to the database.

Specified by:

batchDelete in interface DSLContext

See Also:

Statement.executeBatch()

batchDelete

public Batch batchDelete(Collection<? extends UpdatableRecord<?>> records)

Description copied from interface: DSLContext

Execute a set of DELETE in batch mode (with bind values).

Specified by:

batchDelete in interface DSLContext

See Also:

DSLContext.batchDelete(UpdatableRecord...), Statement.executeBatch()

truncate

public <R extends Record> TruncateIdentityStep<R> truncate(Table<R> table)

Description copied from interface: DSLContext

Create a new DSL truncate statement.

Example:

 DSLContext create = DSL.using(configuration);

 create.truncate(table)
       .execute();
 

Simulation of TRUNCATE

Most dialects implement the TRUNCATE statement. If it is not supported, it is simulated using an equivalent DELETE statement. This is particularly true for these dialects:

• SQLDialect.FIREBIRD
• SQLDialect.INGRES
• SQLDialect.SQLITE

Vendor-specific extensions of TRUNCATE

Some statements also support extensions of the TRUNCATE statement, such as Postgres:

 create.truncate(table)
       .restartIdentity()
       .cascade()
       .execute();
 

These vendor-specific extensions are currently not simulated for those dialects that do not support them natively.

Specified by:

truncate in interface DSLContext

lastID

public BigInteger lastID()
                  throws DataAccessException

Description copied from interface: DSLContext

Retrieve the last inserted ID.

Note, there are some restrictions to the following dialects:

• SQLDialect.DB2 doesn't support this
• SQLDialect.ORACLE doesn't support this
• SQLDialect.POSTGRES doesn't support this
• SQLDialect.SQLITE supports this, but its support is poorly documented.

Specified by:

lastID in interface DSLContext

Returns:

The last inserted ID. This may be null in some dialects, if no such number is available.

Throws:

DataAccessException - if something went wrong executing the query

nextval

public <T extends Number> T nextval(Sequence<T> sequence)

Description copied from interface: DSLContext

Convenience method to fetch the NEXTVAL for a sequence directly from this DSLContext's underlying JDBC Connection

Specified by:

nextval in interface DSLContext

currval

public <T extends Number> T currval(Sequence<T> sequence)

Description copied from interface: DSLContext

Convenience method to fetch the CURRVAL for a sequence directly from this DSLContext's underlying JDBC Connection

Specified by:

currval in interface DSLContext

newRecord

public <R extends UDTRecord<R>> R newRecord(UDT<R> type)

Description copied from interface: DSLContext

Create a new UDTRecord.

The resulting record is attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

newRecord in interface DSLContext

Type Parameters:

R - The generic record type

Parameters:

type - The UDT describing records of type <R>

Returns:

The new record

newRecord

public <R extends Record> R newRecord(Table<R> table)

Description copied from interface: DSLContext

Create a new Record that can be inserted into the corresponding table.

The resulting record is attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

newRecord in interface DSLContext

Type Parameters:

R - The generic record type

Parameters:

table - The table holding records of type <R>

Returns:

The new record

newRecord

public <R extends Record> R newRecord(Table<R> table,
                             Object source)

Description copied from interface: DSLContext

Create a new pre-filled Record that can be inserted into the corresponding table.

This performs roughly the inverse operation of Record.into(Class)

The resulting record will have its internal "changed" flags set to true for all values. This means that UpdatableRecord.store() will perform an INSERT statement. If you wish to store the record using an UPDATE statement, use DSLContext.executeUpdate(UpdatableRecord) instead.

The resulting record is attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

newRecord in interface DSLContext

Type Parameters:

R - The generic record type

Parameters:

table - The table holding records of type <R>

source - The source to be used to fill the new record

Returns:

The new record

See Also:

Record.from(Object), Record.into(Class)

newResult

public <R extends Record> Result<R> newResult(Table<R> table)

Description copied from interface: DSLContext

Create a new empty Result.

The result is attached to this Configuration by default. This result can be used as a container for records.

Specified by:

newResult in interface DSLContext

Type Parameters:

R - The generic record type

Parameters:

table - The table holding records of type <R>

Returns:

The new result

fetch

public <R extends Record> Result<R> fetch(ResultQuery<R> query)
                               throws DataAccessException

Description copied from interface: DSLContext

Execute a ResultQuery in the context of this executor and return results.

Specified by:

fetch in interface DSLContext

Parameters:

query - The query to execute

Returns:

The result

Throws:

DataAccessException - if something went wrong executing the query

See Also:

ResultQuery.fetch()

fetchLazy

public <R extends Record> Cursor<R> fetchLazy(ResultQuery<R> query)
                                   throws DataAccessException

Description copied from interface: DSLContext

Execute a ResultQuery in the context of this executor and return a cursor.

Specified by:

fetchLazy in interface DSLContext

Parameters:

query - The query to execute

Returns:

The cursor

Throws:

DataAccessException - if something went wrong executing the query

See Also:

ResultQuery.fetchLazy()

fetchMany

public <R extends Record> List<Result<Record>> fetchMany(ResultQuery<R> query)
                               throws DataAccessException

Description copied from interface: DSLContext

Execute a ResultQuery in the context of this executor and return a cursor.

Specified by:

fetchMany in interface DSLContext

Parameters:

query - The query to execute

Returns:

The results

Throws:

DataAccessException - if something went wrong executing the query

See Also:

ResultQuery.fetchMany()

fetchOne

public <R extends Record> R fetchOne(ResultQuery<R> query)
                          throws DataAccessException,
                                 InvalidResultException

Description copied from interface: DSLContext

Execute a ResultQuery in the context of this executor and return a record.

Specified by:

fetchOne in interface DSLContext

Parameters:

query - The query to execute

Returns:

The record

Throws:

DataAccessException - if something went wrong executing the query

InvalidResultException - if the query returned more than one record

See Also:

ResultQuery.fetchOne()

fetchCount

public int fetchCount(Select<?> query)
               throws DataAccessException

Description copied from interface: DSLContext

Execute a Select query in the context of this executor and return a COUNT(*) value.

This wraps a pre-existing SELECT query in another one to calculate the COUNT(*) value, without modifying the original SELECT. An example:

 -- Original query:
 SELECT id, title FROM book WHERE title LIKE '%a%'

 -- Wrapped query:
 SELECT count(*) FROM (
   SELECT id, title FROM book WHERE title LIKE '%a%'
 )
 

This is particularly useful for those databases that do not support the COUNT(*) OVER() window function to calculate total results in paged queries.

Specified by:

fetchCount in interface DSLContext

Parameters:

query - The wrapped query

Returns:

The COUNT(*) result

Throws:

DataAccessException - if something went wrong executing the query

execute

public int execute(Query query)
            throws DataAccessException

Description copied from interface: DSLContext

Execute a Query in the context of this executor.

Specified by:

execute in interface DSLContext

Parameters:

query - The query to execute

Returns:

The number of affected rows

Throws:

DataAccessException - if something went wrong executing the query

See Also:

Query.execute()

fetch

public <R extends Record> Result<R> fetch(Table<R> table)
                               throws DataAccessException

Description copied from interface: DSLContext

Execute and return all records for

SELECT * FROM [table]

.

The result and its contained records are attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

fetch in interface DSLContext

Throws:

DataAccessException - if something went wrong executing the query

fetch

public <R extends Record> Result<R> fetch(Table<R> table,
                                 Condition condition)
                               throws DataAccessException

Description copied from interface: DSLContext

Execute and return all records for

SELECT * FROM [table] WHERE [condition] 

.

The result and its contained records are attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

fetch in interface DSLContext

Throws:

DataAccessException - if something went wrong executing the query

fetchOne

public <R extends Record> R fetchOne(Table<R> table)
                          throws DataAccessException,
                                 InvalidResultException

Description copied from interface: DSLContext

Execute and return zero or one record for

SELECT * FROM [table]

.

The resulting record is attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

fetchOne in interface DSLContext

Returns:

The record or null if no record was returned

Throws:

DataAccessException - if something went wrong executing the query

InvalidResultException - if the query returned more than one record

fetchOne

public <R extends Record> R fetchOne(Table<R> table,
                            Condition condition)
                          throws DataAccessException,
                                 InvalidResultException

Description copied from interface: DSLContext

Execute and return zero or one record for

SELECT * FROM [table] WHERE [condition] 

.

The resulting record is attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

fetchOne in interface DSLContext

Returns:

The record or null if no record was returned

Throws:

DataAccessException - if something went wrong executing the query

InvalidResultException - if the query returned more than one record

fetchAny

public <R extends Record> R fetchAny(Table<R> table)
                          throws DataAccessException

Description copied from interface: DSLContext

Execute and return zero or one record for

SELECT * FROM [table] LIMIT 1

.

The resulting record is attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

fetchAny in interface DSLContext

Returns:

The record or null if no record was returned

Throws:

DataAccessException - if something went wrong executing the query

fetchAny

public <R extends Record> R fetchAny(Table<R> table,
                            Condition condition)
                          throws DataAccessException

Description copied from interface: DSLContext

Execute and return zero or one record for

SELECT * FROM [table] WHERE [condition] LIMIT 1

.

The resulting record is attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

fetchAny in interface DSLContext

Returns:

The record or null if no record was returned

Throws:

DataAccessException - if something went wrong executing the query

fetchLazy

public <R extends Record> Cursor<R> fetchLazy(Table<R> table)
                                   throws DataAccessException

Description copied from interface: DSLContext

Execute and return all records lazily for

SELECT * FROM [table]

.

The result and its contained records are attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

fetchLazy in interface DSLContext

Throws:

DataAccessException - if something went wrong executing the query

fetchLazy

public <R extends Record> Cursor<R> fetchLazy(Table<R> table,
                                     Condition condition)
                                   throws DataAccessException

Description copied from interface: DSLContext

Execute and return all records lazily for

SELECT * FROM [table] WHERE [condition] 

.

The result and its contained records are attached to this Configuration by default. Use Settings.isAttachRecords() to override this behaviour.

Specified by:

fetchLazy in interface DSLContext

Throws:

DataAccessException - if something went wrong executing the query

executeInsert

public <R extends TableRecord<R>> int executeInsert(R record)
                  throws DataAccessException

Description copied from interface: DSLContext

Insert one record.

This executes something like the following statement:

INSERT INTO [table] ... VALUES [record] 

Unlike UpdatableRecord.store(), this does not change any of the argument record's internal "changed" flags, such that a subsequent call to UpdatableRecord.store() might lead to another INSERT statement being executed.

Specified by:

executeInsert in interface DSLContext

Returns:

The number of inserted records

Throws:

DataAccessException - if something went wrong executing the query

executeUpdate

public <R extends UpdatableRecord<R>> int executeUpdate(R record)
                  throws DataAccessException

Description copied from interface: DSLContext

Update a table.

UPDATE [table] SET [modified values in record] WHERE [record is supplied record] 

Specified by:

executeUpdate in interface DSLContext

Returns:

The number of updated records

Throws:

DataAccessException - if something went wrong executing the query

executeUpdate

public <R extends TableRecord<R>,T> int executeUpdate(R record,
                                             Condition condition)
                  throws DataAccessException

Description copied from interface: DSLContext

Update a table.

UPDATE [table] SET [modified values in record] WHERE [condition]

Specified by:

executeUpdate in interface DSLContext

Returns:

The number of updated records

Throws:

DataAccessException - if something went wrong executing the query

executeDelete

public <R extends UpdatableRecord<R>> int executeDelete(R record)
                  throws DataAccessException

Description copied from interface: DSLContext

Delete a record from a table.

DELETE FROM [table] WHERE [record is supplied record]

Specified by:

executeDelete in interface DSLContext

Returns:

The number of deleted records

Throws:

DataAccessException - if something went wrong executing the query

executeDelete

public <R extends TableRecord<R>,T> int executeDelete(R record,
                                             Condition condition)
                  throws DataAccessException

Description copied from interface: DSLContext

Delete a record from a table.

DELETE FROM [table] WHERE [condition]

Specified by:

executeDelete in interface DSLContext

Returns:

The number of deleted records

Throws:

DataAccessException - if something went wrong executing the query

toString

public String toString()

Overrides:

toString in class Object