Uses of Class org.jooq.exception.DataAccessException (jOOQ 3.15.12 API)

Packages that use DataAccessException

Package

Description

org.jooq

This package contains jOOQ's public API.

org.jooq.exception

This package contains jOOQ's exceptions.

org.jooq.impl

This package contains jOOQ's implementation classes.

Uses of DataAccessException in org.jooq

Methods in org.jooq that return DataAccessException

Modifier and Type

Method

Description

DataAccessException

LoaderError.exception()

The underlying DataAccessException that caused the error.

DataAccessException

ResultOrRows.exception()

The exception if applicable or null if there was no exception.

Methods in org.jooq that throw DataAccessException

Modifier and Type

Method

Description

@Nullable Connection

ConnectionProvider.acquire()

Acquire a connection from the connection lifecycle handler.

void

SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type)

Joins the existing table product to a new table using a foreign key.

void

SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, TableField<?,?>... keyFields)

Joins the existing table product to a new table using a foreign key.

@NotNull Meta

Meta.apply(String migration)

Apply a migration to this meta to produce a new Meta.

@NotNull Meta

Meta.apply(Collection<? extends Query> migration)

Apply a migration to this meta to produce a new Meta.

@NotNull Meta

Meta.apply(Queries migration)

Apply a migration to this meta to produce a new Meta.

@NotNull Meta

Meta.apply(Query... migration)

Apply a migration to this meta to produce a new Meta.

void

TransactionProvider.begin(TransactionContext ctx)

Begin a new transaction.

@NotNull BindContext

Context.bindValue(Object value, Field<?> field)

Bind a value using a specific type.

void

Query.cancel()

Cancel the underlying statement.

void

CloseableDSLContext.close()

Close the underlying resources, if any resources have been allocated when constructing this DSLContext.

void

Cursor.close()

Explicitly close the underlying PreparedStatement and ResultSet.

void

Query.close()

Close the underlying statement.

<X, A> X

Cursor.collect(Collector<? super R,A,X> collector)

Reduce the execution results of this query using a Collector.

<X, A> X

ResultQuery.collect(Collector<? super R,A,X> collector)

Reduce the execution results of this query using a Collector.

void

TransactionProvider.commit(TransactionContext ctx)

Commit a transaction.

long

DAO.count()

Count all records of the underlying table.

@NotNull BigInteger

DSLContext.currval(String sequence)

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

@NotNull BigInteger

DSLContext.currval(Name sequence)

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

<T extends Number> T

DSLContext.currval(Sequence<T> sequence)

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

@NotNull Queries

Meta.ddl()

Generate a creation script for the entire meta data.

@NotNull Queries

Meta.ddl(DDLExportConfiguration configuration)

Generate a creation script for the entire meta data.

void

DAO.delete(Collection objects)

Performs a DELETE statement for a given set of POJOs.

void

DAO.delete(P object)

Performs a DELETE statement for a POJO

void

DAO.delete(P... objects)

Performs a DELETE statement for a given set of POJOs.

int

UpdatableRecord.delete()

Deletes this record from the database, based on the value of the primary key or main unique key.

void

DAO.deleteById(Collection<T> ids)

Performs a DELETE statement for a given set of IDs.

void

DAO.deleteById(T... ids)

Performs a DELETE statement for a given set of IDs.

@org.jetbrains.annotations.NotNull int[]

Batch.execute()

Execute the batch operation.

int

DSLContext.execute(String sql)

Execute a query holding plain SQL.

int

DSLContext.execute(String sql, Object... bindings)

Execute a new query holding plain SQL.

int

DSLContext.execute(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

int

DSLContext.execute(Query query)

Execute a Query in the context of this DSLContext.

int

DSLContext.execute(SQL sql)

Execute a query holding plain SQL.

int

Query.execute()

Execute the query, if it has been created with a proper configuration.

int

Routine.execute()

Execute the stored object on an underlying connection

int

Routine.execute(Configuration configuration)

Execute the stored object using a Configuration object

int

DSLContext.executeDelete(TableRecord<?> record, Condition condition)

Delete a record from a table.

int

DSLContext.executeDelete(UpdatableRecord<?> record)

Delete a record from a table.

int

DSLContext.executeInsert(TableRecord<?> record)

Insert one record.

int

DSLContext.executeUpdate(TableRecord<?> record, Condition condition)

Update a table.

int

DSLContext.executeUpdate(UpdatableRecord<?> record)

Update a table.

boolean

DAO.exists(P object)

Checks if a given POJO exists.

boolean

DAO.existsById(T id)

Checks if a given ID exists.

@NotNull Result<R>

Cursor.fetch()

Fetch all remaining records as a result.

@NotNull Result<R>

Cursor.fetch(int number)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.10 - [#6363] - Use Cursor.fetchNext(int) instead.

<E> @NotNull List<E>

Cursor.fetch(RecordMapper<? super R,E> mapper)

Fetch results into a custom mapper callback.

<Z> @NotNull List

DAO.fetch(Field<Z> field, Collection<? extends Z> values)

Find records by a given field and a set of values.

<Z> @NotNull List

DAO.fetch(Field<Z> field, Z... values)

Find records by a given field and a set of values.

@NotNull Result<Record>

DSLContext.fetch(String sql)

Execute a new query holding plain SQL.

@NotNull Result<Record>

DSLContext.fetch(String sql, Object... bindings)

Execute a new query holding plain SQL.

@NotNull Result<Record>

DSLContext.fetch(String sql, QueryPart... parts)

Execute a new query holding plain SQL.

@NotNull Result<Record>

DSLContext.fetch(ResultSet rs)

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

@NotNull Result<Record>

DSLContext.fetch(ResultSet rs, Class<?>... types)

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

@NotNull Result<Record>

DSLContext.fetch(ResultSet rs, DataType<?>... types)

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

@NotNull Result<Record>

DSLContext.fetch(ResultSet rs, Field<?>... fields)

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

<R extends Record> @NotNull Result<R>

DSLContext.fetch(ResultQuery<R> query)

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

@NotNull Result<Record>

DSLContext.fetch(SQL sql)

Execute a new query holding plain SQL.

<R extends Record> @NotNull Result<R>

DSLContext.fetch(Table<R> table)

Execute and return all records for
<R extends Record> @NotNull Result<R> DSLContext.fetch(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records for <R extends Record> @NotNull Result<R> DSLContext.fetch(Table<R> table, Condition condition) Execute and return all records for <R extends Record> @NotNull Result<R> DSLContext.fetch(Table<R> table, Condition... conditions) Execute and return all records for @NotNull Result<R> ResultQuery.fetch() Execute the query and return the generated result. @NotNull List<?> ResultQuery.fetch(int fieldIndex) Execute the query and return all values for a field index from the generated result. @NotNull List ResultQuery.fetch(int fieldIndex, Class<? extends U> type) Execute the query and return all values for a field index from the generated result. @NotNull List ResultQuery.fetch(int fieldIndex, Converter<?,? extends U> converter) Execute the query and return all values for a field index from the generated result. @NotNull List<?> ResultQuery.fetch(String fieldName) Execute the query and return all values for a field name from the generated result. @NotNull List ResultQuery.fetch(String fieldName, Class<? extends U> type) Execute the query and return all values for a field name from the generated result. @NotNull List ResultQuery.fetch(String fieldName, Converter<?,? extends U> converter) Execute the query and return all values for a field name from the generated result. @NotNull List ResultQuery.fetch(Field<?> field, Class<? extends U> type) Execute the query and return all values for a field from the generated result. <T> @NotNull List<T> ResultQuery.fetch(Field<T> field) Execute the query and return all values for a field from the generated result. <T, U> @NotNull List ResultQuery.fetch(Field<T> field, Converter<? super T,? extends U> converter) Execute the query and return all values for a field from the generated result. @NotNull List<?> ResultQuery.fetch(Name fieldName) Execute the query and return all values for a field name from the generated result. @NotNull List ResultQuery.fetch(Name fieldName, Class<? extends U> type) Execute the query and return all values for a field name from the generated result. @NotNull List ResultQuery.fetch(Name fieldName, Converter<?,? extends U> converter) Execute the query and return all values for a field name from the generated result. <E> @NotNull List<E> ResultQuery.fetch(RecordMapper<? super R,E> mapper) Fetch results into a custom mapper callback. <R extends Record> R DSLContext.fetchAny(Table<R> table) Execute and return zero or one record for <R extends Record> R DSLContext.fetchAny(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for <R extends Record> R DSLContext.fetchAny(Table<R> table, Condition condition) Execute and return zero or one record for <R extends Record> R DSLContext.fetchAny(Table<R> table, Condition... conditions) Execute and return zero or on e record for R ResultQuery.fetchAny() Execute the query and return at most one resulting record. @Nullable Object ResultQuery.fetchAny(int fieldIndex) Execute the query and return at most one resulting value for a field index from the generated result. U ResultQuery.fetchAny(int fieldIndex, Class<? extends U> type) Execute the query and return at most one resulting value for a field index from the generated result. U ResultQuery.fetchAny(int fieldIndex, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field index from the generated result. @Nullable Object ResultQuery.fetchAny(String fieldName) Execute the query and return at most one resulting value for a field name from the generated result. U ResultQuery.fetchAny(String fieldName, Class<? extends U> type) Execute the query and return at most one resulting value for a field name from the generated result. U ResultQuery.fetchAny(String fieldName, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field name from the generated result. U ResultQuery.fetchAny(Field<?> field, Class<? extends U> type) Execute the query and return at most one resulting value for a field from the generated result. <T> T ResultQuery.fetchAny(Field<T> field) Execute the query and return at most one resulting value for a field from the generated result. <T, U> U ResultQuery.fetchAny(Field<T> field, Converter<? super T,? extends U> converter) Execute the query and return at most one resulting value for a field from the generated result. @Nullable Object ResultQuery.fetchAny(Name fieldName) Execute the query and return at most one resulting value for a field name from the generated result. U ResultQuery.fetchAny(Name fieldName, Class<? extends U> type) Execute the query and return at most one resulting value for a field name from the generated result. U ResultQuery.fetchAny(Name fieldName, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field name from the generated result. <E> E ResultQuery.fetchAny(RecordMapper<? super R,E> mapper) Execute the query and return at most one resulting record. @Nullable Object[] ResultQuery.fetchAnyArray() Execute the query and return at most one resulting record as an array <E> E ResultQuery.fetchAnyInto(Class<? extends E> type) Map resulting records onto a custom type. <Z extends Record> Z ResultQuery.fetchAnyInto(Table<Z> table) Map resulting records onto a custom record. @Nullable Map<String,Object> ResultQuery.fetchAnyMap() Execute the query and return at most one resulting record as a name/value map. @NotNull R[] ResultQuery.fetchArray() Execute the query and return the generated result as an array of records. @NotNull Object[] ResultQuery.fetchArray(int fieldIndex) Execute the query and return all values for a field index from the generated result. @NotNull U[] ResultQuery.fetchArray(int fieldIndex, Class<? extends U> type) Execute the query and return all values for a field index from the generated result. @NotNull U[] ResultQuery.fetchArray(int fieldIndex, Converter<?,? extends U> converter) Execute the query and return all values for a field index from the generated result. @NotNull Object[] ResultQuery.fetchArray(String fieldName) Execute the query and return all values for a field name from the generated result. @NotNull U[] ResultQuery.fetchArray(String fieldName, Class<? extends U> type) Execute the query and return all values for a field name from the generated result. @NotNull U[] ResultQuery.fetchArray(String fieldName, Converter<?,? extends U> converter) Execute the query and return all values for a field name from the generated result. @NotNull U[] ResultQuery.fetchArray(Field<?> field, Class<? extends U> type) Execute the query and return all values for a field from the generated result. <T> @NotNull T[] ResultQuery.fetchArray(Field<T> field) Execute the query and return all values for a field from the generated result. <T, U> @NotNull U[] ResultQuery.fetchArray(Field<T> field, Converter<? super T,? extends U> converter) Execute the query and return all values for a field from the generated result. @NotNull Object[] ResultQuery.fetchArray(Name fieldName) Execute the query and return all values for a field name from the generated result. @NotNull U[] ResultQuery.fetchArray(Name fieldName, Class<? extends U> type) Execute the query and return all values for a field name from the generated result. @NotNull U[] ResultQuery.fetchArray(Name fieldName, Converter<?,? extends U> converter) Execute the query and return all values for a field name from the generated result. @NotNull Object[][] ResultQuery.fetchArrays() Execute the query and return the generated result as an Object matrix. <R extends TableRecord<R>> @NotNull Result<R> DSLContext.fetchByExample(R example) Execute a "Query by Example" (QBE) based on an example record. <O extends TableRecord<O>> O UpdatableRecord.fetchChild(ForeignKey<O,R> key) Fetch a child record of this record, given a foreign key. @NotNull Result<R> ForeignKey.fetchChildren(Collection<? extends O> records) Fetch child records of a given set of records through this foreign key @NotNull Result<R> ForeignKey.fetchChildren(O record) Fetch child records of a given record through this foreign key @NotNull Result<R> ForeignKey.fetchChildren(O... records) Fetch child records of a given set of records through this foreign key <O extends TableRecord<O>> @NotNull Result<O> Result.fetchChildren(ForeignKey<O,R> key) Fetch child records of this record, given a foreign key, as if fetching from Result.children(ForeignKey). <O extends TableRecord<O>> @NotNull Result<O> UpdatableRecord.fetchChildren(ForeignKey<O,R> key) Fetch child records of this record, given a foreign key. int DSLContext.fetchCount(Select<?> query) Execute a Select query in the context of this DSLContext and return a COUNT(*) value. int DSLContext.fetchCount(Table<?> table) Count the number of records in a table. int DSLContext.fetchCount(Table<?> table, Collection<? extends Condition> conditions) Count the number of records in a table that satisfy a condition. int DSLContext.fetchCount(Table<?> table, Condition condition) Count the number of records in a table that satisfy a condition. int DSLContext.fetchCount(Table<?> table, Condition... conditions) Count the number of records in a table that satisfy a condition. boolean DSLContext.fetchExists(Select<?> query) Check if a Select would return any records, if it were executed. boolean DSLContext.fetchExists(Table<?> table) Check if a table has any records. boolean DSLContext.fetchExists(Table<?> table, Collection<? extends Condition> conditions) Check if a table has any records that satisfy a condition. boolean DSLContext.fetchExists(Table<?> table, Condition condition) Check if a table has any records that satisfy a condition. boolean DSLContext.fetchExists(Table<?> table, Condition... conditions) Check if a table has any records that satisfy a condition. @NotNull Result<Record> DSLContext.fetchFromCSV(String string) Fetch all data from a CSV string. @NotNull Result<Record> DSLContext.fetchFromCSV(String string, boolean header) Fetch all data from a CSV string. @NotNull Result<Record> DSLContext.fetchFromCSV(String string, boolean header, char delimiter) Fetch all data from a CSV string. @NotNull Result<Record> DSLContext.fetchFromCSV(String string, char delimiter) Fetch all data from a CSV string. @NotNull Result<Record> DSLContext.fetchFromHTML(String string) Convert an HTML table into a jOOQ Result. @NotNull Result<Record> DSLContext.fetchFromTXT(String string) Fetch all data from a formatted string. @NotNull Result<Record> DSLContext.fetchFromTXT(String string, String nullLiteral) Fetch all data from a formatted string. @NotNull Map<?,Result<R>> ResultQuery.fetchGroups(int keyFieldIndex) Execute the query and return a Map with one of the result's columns as key and a list of corresponding records as value. @NotNull Map<Record,Result<R>> ResultQuery.fetchGroups(int[] keyFieldIndexes) Execute the query and return a Map with the result grouped by the given keys. @NotNull Map<Record,Result<Record>> ResultQuery.fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return a Map with the result grouped by the given keys. @NotNull Map<?,List<?>> ResultQuery.fetchGroups(int keyFieldIndex, int valueFieldIndex) Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value <E> @NotNull Map<?,List<E>> ResultQuery.fetchGroups(int keyFieldIndex, Class<? extends E> type) Return a Map with results grouped by the given key and mapped into the given entity type. <E> @NotNull Map<?,List<E>> ResultQuery.fetchGroups(int keyFieldIndex, RecordMapper<? super R,E> mapper) Return a Map with results grouped by the given key and mapped by the given mapper. @NotNull Map<?,Result<R>> ResultQuery.fetchGroups(String keyFieldName) Execute the query and return a Map with one of the result's columns as key and a list of corresponding records as value. @NotNull Map<Record,Result<R>> ResultQuery.fetchGroups(String[] keyFieldNames) Execute the query and return a Map with the result grouped by the given keys. @NotNull Map<Record,Result<Record>> ResultQuery.fetchGroups(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return a Map with the result grouped by the given keys. <E> @NotNull Map<?,List<E>> ResultQuery.fetchGroups(String keyFieldName, Class<? extends E> type) Return a Map with results grouped by the given key and mapped into the given entity type. @NotNull Map<?,List<?>> ResultQuery.fetchGroups(String keyFieldName, String valueFieldName) Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value <E> @NotNull Map<?,List<E>> ResultQuery.fetchGroups(String keyFieldName, RecordMapper<? super R,E> mapper) Return a Map with results grouped by the given key and mapped by the given mapper. @NotNull Map<Record,Result<R>> ResultQuery.fetchGroups(Field<?>[] keys) Execute the query and return a Map with the result grouped by the given keys. @NotNull Map<Record,Result<Record>> ResultQuery.fetchGroups(Field<?>[] keys, Field<?>[] values) Execute the query and return a Map with the result grouped by the given keys. <K> @NotNull Map<K,Result<R>> ResultQuery.fetchGroups(Field<K> key) Execute the query and return a Map with one of the result's columns as key and a list of corresponding records as value. <K, E> @NotNull Map<K,List<E>> ResultQuery.fetchGroups(Field<K> key, Class<? extends E> type) Return a Map with results grouped by the given key and mapped into the given entity type. <K, V> @NotNull Map<K,List<V>> ResultQuery.fetchGroups(Field<K> key, Field<V> value) Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value <K, E> @NotNull Map<K,List<E>> ResultQuery.fetchGroups(Field<K> key, RecordMapper<? super R,E> mapper) Return a Map with results grouped by the given key and mapped by the given mapper. @NotNull Map<?,Result<R>> ResultQuery.fetchGroups(Name keyFieldName) Execute the query and return a Map with one of the result's columns as key and a list of corresponding records as value. @NotNull Map<Record,Result<R>> ResultQuery.fetchGroups(Name[] keyFieldNames) Execute the query and return a Map with the result grouped by the given keys. @NotNull Map<Record,Result<Record>> ResultQuery.fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return a Map with the result grouped by the given keys. <E> @NotNull Map<?,List<E>> ResultQuery.fetchGroups(Name keyFieldName, Class<? extends E> type) Return a Map with results grouped by the given key and mapped into the given entity type. @NotNull Map<?,List<?>> ResultQuery.fetchGroups(Name keyFieldName, Name valueFieldName) Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value <E> @NotNull Map<?,List<E>> ResultQuery.fetchGroups(Name keyFieldName, RecordMapper<? super R,E> mapper) Return a Map with results grouped by the given key and mapped by the given mapper. <S extends Record> @NotNull Map<S,Result<R>> ResultQuery.fetchGroups(Table<S> table) Execute the query and return a Map with the result grouped by the given table. <E, S extends Record> @NotNull Map<S,List<E>> ResultQuery.fetchGroups(Table<S> table, Class<? extends E> type) Execute the query and return a Map with results grouped by the given table and mapped into the given entity type. <E, S extends Record> @NotNull Map<S,List<E>> ResultQuery.fetchGroups(Table<S> table, RecordMapper<? super R,E> mapper) Execute the query and return a Map with results grouped by the given table and mapped by the given mapper. <S extends Record, T extends Record> @NotNull Map<S,Result<T>> ResultQuery.fetchGroups(Table<S> keyTable, Table<T> valueTable) Execute the query and return a Map with the result grouped by the given table. <H extends RecordHandler<? super R>> H Cursor.fetchInto(H handler) Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#11902] - Use Iterable.forEach(Consumer) based methods, instead. <E> @NotNull List<E> Cursor.fetchInto(Class<? extends E> type) Map resulting records onto a custom type. <Z extends Record> @NotNull Result<Z> Cursor.fetchInto(Table<Z> table) Map resulting records onto a custom record. <H extends RecordHandler<? super R>> H ResultQuery.fetchInto(H handler) Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#11902] - Use Iterable.forEach(Consumer) based methods, instead. <E> @NotNull List<E> ResultQuery.fetchInto(Class<? extends E> type) Map resulting records onto a custom type. <Z extends Record> @NotNull Result<Z> ResultQuery.fetchInto(Table<Z> table) Map resulting records onto a custom record. @NotNull Cursor<Record> DSLContext.fetchLazy(String sql) Execute a new query holding plain SQL and "lazily" return the generated result. @NotNull Cursor<Record> DSLContext.fetchLazy(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result. @NotNull Cursor<Record> DSLContext.fetchLazy(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result. @NotNull Cursor<Record> DSLContext.fetchLazy(ResultSet rs) Wrap a JDBC ResultSet into a jOOQ Cursor. @NotNull Cursor<Record> DSLContext.fetchLazy(ResultSet rs, Class<?>... types) Wrap a JDBC ResultSet into a jOOQ Cursor. @NotNull Cursor<Record> DSLContext.fetchLazy(ResultSet rs, DataType<?>... types) Wrap a JDBC ResultSet into a jOOQ Cursor. @NotNull Cursor<Record> DSLContext.fetchLazy(ResultSet rs, Field<?>... fields) Wrap a JDBC ResultSet into a jOOQ Cursor. <R extends Record> @NotNull Cursor<R> DSLContext.fetchLazy(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a cursor. @NotNull Cursor<Record> DSLContext.fetchLazy(SQL sql) Execute a new query holding plain SQL and "lazily" return the generated result. <R extends Record> @NotNull Cursor<R> DSLContext.fetchLazy(Table<R> table) Execute and return all records lazily for <R extends Record> @NotNull Cursor<R> DSLContext.fetchLazy(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records lazily for <R extends Record> @NotNull Cursor<R> DSLContext.fetchLazy(Table<R> table, Condition condition) Execute and return all records lazily for <R extends Record> @NotNull Cursor<R> DSLContext.fetchLazy(Table<R> table, Condition... conditions) Execute and return all records lazily for @NotNull Cursor<R> ResultQuery.fetchLazy() Execute the query and "lazily" return the generated result. @NotNull Results DSLContext.fetchMany(String sql) Execute a new query holding plain SQL, possibly returning several result sets. @NotNull Results DSLContext.fetchMany(String sql, Object... bindings) Execute a new query holding plain SQL, possibly returning several result sets. @NotNull Results DSLContext.fetchMany(String sql, QueryPart... parts) Execute a new query holding plain SQL, possibly returning several result sets. <R extends Record> @NotNull Results DSLContext.fetchMany(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a cursor. @NotNull Results DSLContext.fetchMany(SQL sql) Execute a new query holding plain SQL, possibly returning several result sets. @NotNull Results ResultQuery.fetchMany() Execute a query, possibly returning several result sets. @NotNull Map<?,R> ResultQuery.fetchMap(int keyFieldIndex) Execute the query and return a Map with one of the result's columns as key and the corresponding records as value. @NotNull Map<Record,R> ResultQuery.fetchMap(int[] keyFieldIndexes) Execute the query and return a Map with keys as a map key and the corresponding record as value. @NotNull Map<Record,Record> ResultQuery.fetchMap(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return a Map with keys as a map key and the corresponding record as value. <E> @NotNull Map<List<?>,E> ResultQuery.fetchMap(int[] keyFieldIndexes, Class<? extends E> type) Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type. <E> @NotNull Map<List<?>,E> ResultQuery.fetchMap(int[] keyFieldIndexes, RecordMapper<? super R,E> mapper) Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper. @NotNull Map<?,?> ResultQuery.fetchMap(int keyFieldIndex, int valueFieldIndex) Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value <E> @NotNull Map<?,E> ResultQuery.fetchMap(int keyFieldIndex, Class<? extends E> type) Execute the query and return a Map with results grouped by the given key and mapped into the given entity type. <E> @NotNull Map<?,E> ResultQuery.fetchMap(int keyFieldIndex, RecordMapper<? super R,E> mapper) Execute the query and return a Map with results grouped by the given key and mapped by the given mapper. <K> @NotNull Map<K,R> ResultQuery.fetchMap(Class<? extends K> keyType) Execute the query and return a Map with results grouped by the given key entity. <K, V> @NotNull Map<K,V> ResultQuery.fetchMap(Class<? extends K> keyType, Class<? extends V> valueType) Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type. <K, V> @NotNull Map<K,V> ResultQuery.fetchMap(Class<? extends K> keyType, RecordMapper<? super R,V> valueMapper) Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type. @NotNull Map<?,R> ResultQuery.fetchMap(String keyFieldName) Execute the query and return a Map with one of the result's columns as key and the corresponding records as value. @NotNull Map<Record,R> ResultQuery.fetchMap(String[] keyFieldNames) Execute the query and return a Map with keys as a map key and the corresponding record as value. <E> @NotNull Map<List<?>,E> ResultQuery.fetchMap(String[] keyFieldNames, Class<? extends E> type) Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type. @NotNull Map<Record,Record> ResultQuery.fetchMap(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return a Map with keys as a map key and the corresponding record as value. <E> @NotNull Map<List<?>,E> ResultQuery.fetchMap(String[] keyFieldNames, RecordMapper<? super R,E> mapper) Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper. <E> @NotNull Map<?,E> ResultQuery.fetchMap(String keyFieldName, Class<? extends E> type) Execute the query and return a Map with results grouped by the given key and mapped into the given entity type. @NotNull Map<?,?> ResultQuery.fetchMap(String keyFieldName, String valueFieldName) Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value <E> @NotNull Map<?,E> ResultQuery.fetchMap(String keyFieldName, RecordMapper<? super R,E> mapper) Execute the query and return a Map with results grouped by the given key and mapped by the given mapper. @NotNull Map<Record,R> ResultQuery.fetchMap(Field<?>[] keys) Execute the query and return a Map with keys as a map key and the corresponding record as value. <E> @NotNull Map<List<?>,E> ResultQuery.fetchMap(Field<?>[] keys, Class<? extends E> type) Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type. @NotNull Map<Record,Record> ResultQuery.fetchMap(Field<?>[] keys, Field<?>[] values) Execute the query and return a Map with keys as a map key and the corresponding record as value. <E> @NotNull Map<List<?>,E> ResultQuery.fetchMap(Field<?>[] keys, RecordMapper<? super R,E> mapper) Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper. <K> @NotNull Map<K,R> ResultQuery.fetchMap(Field<K> key) Execute the query and return a Map with one of the result's columns as key and the corresponding records as value. <K, E> @NotNull Map<K,E> ResultQuery.fetchMap(Field<K> key, Class<? extends E> type) Execute the query and return a Map with results grouped by the given key and mapped into the given entity type. <K, V> @NotNull Map<K,V> ResultQuery.fetchMap(Field<K> key, Field<V> value) Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value <K, E> @NotNull Map<K,E> ResultQuery.fetchMap(Field<K> key, RecordMapper<? super R,E> mapper) Execute the query and return a Map with results grouped by the given key and mapped by the given mapper. @NotNull Map<?,R> ResultQuery.fetchMap(Name keyFieldName) Execute the query and return a Map with one of the result's columns as key and the corresponding records as value. @NotNull Map<Record,R> ResultQuery.fetchMap(Name[] keyFieldNames) Execute the query and return a Map with keys as a map key and the corresponding record as value. <E> @NotNull Map<List<?>,E> ResultQuery.fetchMap(Name[] keyFieldNames, Class<? extends E> type) Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type. @NotNull Map<Record,Record> ResultQuery.fetchMap(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return a Map with keys as a map key and the corresponding record as value. <E> @NotNull Map<List<?>,E> ResultQuery.fetchMap(Name[] keyFieldNames, RecordMapper<? super R,E> mapper) Execute the query and return a Map with results grouped by the given keys and mapped by the given mapper. <E> @NotNull Map<?,E> ResultQuery.fetchMap(Name keyFieldName, Class<? extends E> type) Execute the query and return a Map with results grouped by the given key and mapped into the given entity type. @NotNull Map<?,?> ResultQuery.fetchMap(Name keyFieldName, Name valueFieldName) Execute the query and return a Map with one of the result's columns as key and another one of the result's columns as value <E> @NotNull Map<?,E> ResultQuery.fetchMap(Name keyFieldName, RecordMapper<? super R,E> mapper) Execute the query and return a Map with results grouped by the given key and mapped by the given mapper. <K> @NotNull Map<K,R> ResultQuery.fetchMap(RecordMapper<? super R,K> keyMapper) Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type. <K, V> @NotNull Map<K,V> ResultQuery.fetchMap(RecordMapper<? super R,K> keyMapper, Class<V> valueType) Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type. <K, V> @NotNull Map<K,V> ResultQuery.fetchMap(RecordMapper<? super R,K> keyMapper, RecordMapper<? super R,V> valueMapper) Execute the query and return a Map with results grouped by the given key entity and mapped into the given entity type. <S extends Record> @NotNull Map<S,R> ResultQuery.fetchMap(Table<S> table) Execute the query and return a Map with table as a map key and the corresponding record as value. <E, S extends Record> @NotNull Map<S,E> ResultQuery.fetchMap(Table<S> table, Class<? extends E> type) Execute the query and return a Map with results grouped by the given table and mapped into the given entity type. <E, S extends Record> @NotNull Map<S,E> ResultQuery.fetchMap(Table<S> table, RecordMapper<? super R,E> mapper) Execute the query and return a Map with results grouped by the given table and mapped by the given mapper. <S extends Record, T extends Record> @NotNull Map<S,T> ResultQuery.fetchMap(Table<S> keyTable, Table<T> valueTable) Execute the query and return a Map with table as a map key and the corresponding record as value. @NotNull List<Map<String,Object>> ResultQuery.fetchMaps() Execute the query and return the generated result as a list of name/value maps. R Cursor.fetchNext() Fetch the next record from the cursor. @NotNull Result<R> Cursor.fetchNext(int number) Fetch the next couple of records from the cursor. <E> E Cursor.fetchNext(RecordMapper<? super R,E> mapper) Fetch the next record into a custom mapper callback. <H extends RecordHandler<? super R>> H Cursor.fetchNextInto(H handler) Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#11902] - Use Iterable.forEach(Consumer) based methods, instead. <E> E Cursor.fetchNextInto(Class<? extends E> type) Map the next resulting record onto a custom type. <Z extends Record> Z Cursor.fetchNextInto(Table<Z> table) Map the next resulting record onto a custom record. @NotNull Optional<R> Cursor.fetchNextOptional() Fetch the next record from the cursor. <E> @NotNull Optional<E> Cursor.fetchNextOptional(RecordMapper<? super R,E> mapper) Fetch the next record into a custom mapper callback. <E> @NotNull Optional<E> Cursor.fetchNextOptionalInto(Class<? extends E> type) Map the next resulting record onto a custom type. <Z extends Record> @NotNull Optional<Z> Cursor.fetchNextOptionalInto(Table<Z> table) Map the next resulting record onto a custom record. R Cursor.fetchOne() Deprecated, for removal: This API element is subject to removal in a future version. - 3.10 - [#6363] - Use Cursor.fetchNext() instead. <E> E Cursor.fetchOne(RecordMapper<? super R,E> mapper) Deprecated, for removal: This API element is subject to removal in a future version. - 3.10 - [#6363] - Use Cursor.fetchNext(RecordMapper) instead. <Z> P DAO.fetchOne(Field<Z> field, Z value) Find a unique record by a given field and a value. @Nullable Record DSLContext.fetchOne(String sql) Execute a new query holding plain SQL. @Nullable Record DSLContext.fetchOne(String sql, Object... bindings) Execute a new query holding plain SQL. @Nullable Record DSLContext.fetchOne(String sql, QueryPart... parts) Execute a new query holding plain SQL. @Nullable Record DSLContext.fetchOne(ResultSet rs) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. @Nullable Record DSLContext.fetchOne(ResultSet rs, Class<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. @Nullable Record DSLContext.fetchOne(ResultSet rs, DataType<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. @Nullable Record DSLContext.fetchOne(ResultSet rs, Field<?>... fields) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. <R extends Record> R DSLContext.fetchOne(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a record. @Nullable Record DSLContext.fetchOne(SQL sql) Execute a new query holding plain SQL. <R extends Record> R DSLContext.fetchOne(Table<R> table) Execute and return zero or one record for <R extends Record> R DSLContext.fetchOne(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for <R extends Record> R DSLContext.fetchOne(Table<R> table, Condition condition) Execute and return zero or one record for <R extends Record> R DSLContext.fetchOne(Table<R> table, Condition... conditions) Execute and return zero or one record for R ResultQuery.fetchOne() Execute the query and return at most one resulting record. @Nullable Object ResultQuery.fetchOne(int fieldIndex) Execute the query and return at most one resulting value for a field index from the generated result. U ResultQuery.fetchOne(int fieldIndex, Class<? extends U> type) Execute the query and return at most one resulting value for a field index from the generated result. U ResultQuery.fetchOne(int fieldIndex, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field index from the generated result. @Nullable Object ResultQuery.fetchOne(String fieldName) Execute the query and return at most one resulting value for a field name from the generated result. U ResultQuery.fetchOne(String fieldName, Class<? extends U> type) Execute the query and return at most one resulting value for a field name from the generated result. U ResultQuery.fetchOne(String fieldName, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field name from the generated result. U ResultQuery.fetchOne(Field<?> field, Class<? extends U> type) Execute the query and return at most one resulting value for a field from the generated result. <T> T ResultQuery.fetchOne(Field<T> field) Execute the query and return at most one resulting value for a field from the generated result. <T, U> U ResultQuery.fetchOne(Field<T> field, Converter<? super T,? extends U> converter) Execute the query and return at most one resulting value for a field from the generated result. @Nullable Object ResultQuery.fetchOne(Name fieldName) Execute the query and return at most one resulting value for a field name from the generated result. U ResultQuery.fetchOne(Name fieldName, Class<? extends U> type) Execute the query and return at most one resulting value for a field name from the generated result. U ResultQuery.fetchOne(Name fieldName, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field name from the generated result. <E> E ResultQuery.fetchOne(RecordMapper<? super R,E> mapper) Execute the query and return at most one resulting value into a custom mapper callback. @Nullable Object[] ResultQuery.fetchOneArray() Execute the query and return at most one resulting record as an array <H extends RecordHandler<? super R>> H Cursor.fetchOneInto(H handler) Deprecated, for removal: This API element is subject to removal in a future version. - 3.10 - [#6363] - Use Cursor.fetchNextInto(RecordHandler) instead. <E> E Cursor.fetchOneInto(Class<? extends E> type) Deprecated, for removal: This API element is subject to removal in a future version. - 3.10 - [#6363] - Use Cursor.fetchNextInto(Class) instead. <Z extends Record> Z Cursor.fetchOneInto(Table<Z> table) Deprecated, for removal: This API element is subject to removal in a future version. - 3.10 - [#6363] - Use Cursor.fetchNextInto(Table) instead. <E> E ResultQuery.fetchOneInto(Class<? extends E> type) Map resulting records onto a custom type. <Z extends Record> Z ResultQuery.fetchOneInto(Table<Z> table) Map resulting records onto a custom record. @Nullable Map<String,Object> ResultQuery.fetchOneMap() Execute the query and return at most one resulting record as a name/value map. @NotNull Optional<R> Cursor.fetchOptional() Deprecated, for removal: This API element is subject to removal in a future version. - 3.10 - [#6363] - Use Cursor.fetchNextOptional() instead. <E> @NotNull Optional<E> Cursor.fetchOptional(RecordMapper<? super R,E> mapper) Deprecated, for removal: This API element is subject to removal in a future version. - 3.10 - [#6363] - Use Cursor.fetchNextOptional(RecordMapper) instead. <Z> @NotNull Optional DAO.fetchOptional(Field<Z> field, Z value) Find a unique record by a given field and a value. @NotNull Optional<Record> DSLContext.fetchOptional(String sql) Execute a new query holding plain SQL. @NotNull Optional<Record> DSLContext.fetchOptional(String sql, Object... bindings) Execute a new query holding plain SQL. @NotNull Optional<Record> DSLContext.fetchOptional(String sql, QueryPart... parts) Execute a new query holding plain SQL. @NotNull Optional<Record> DSLContext.fetchOptional(ResultSet rs) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. @NotNull Optional<Record> DSLContext.fetchOptional(ResultSet rs, Class<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. @NotNull Optional<Record> DSLContext.fetchOptional(ResultSet rs, DataType<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. @NotNull Optional<Record> DSLContext.fetchOptional(ResultSet rs, Field<?>... fields) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. <R extends Record> @NotNull Optional<R> DSLContext.fetchOptional(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a record. @NotNull Optional<Record> DSLContext.fetchOptional(SQL sql) Execute a new query holding plain SQL. <R extends Record> @NotNull Optional<R> DSLContext.fetchOptional(Table<R> table) Execute and return zero or one record for <R extends Record> @NotNull Optional<R> DSLContext.fetchOptional(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for <R extends Record> @NotNull Optional<R> DSLContext.fetchOptional(Table<R> table, Condition condition) Execute and return zero or one record for <R extends Record> @NotNull Optional<R> DSLContext.fetchOptional(Table<R> table, Condition... conditions) Execute and return zero or one record for @NotNull Optional<R> ResultQuery.fetchOptional() Execute the query and return at most one resulting record. @NotNull Optional<?> ResultQuery.fetchOptional(int fieldIndex) Execute the query and return at most one resulting value for a field index from the generated result. @NotNull Optional ResultQuery.fetchOptional(int fieldIndex, Class<? extends U> type) Execute the query and return at most one resulting value for a field index from the generated result. @NotNull Optional ResultQuery.fetchOptional(int fieldIndex, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field index from the generated result. @NotNull Optional<?> ResultQuery.fetchOptional(String fieldName) Execute the query and return at most one resulting value for a field name from the generated result. @NotNull Optional ResultQuery.fetchOptional(String fieldName, Class<? extends U> type) Execute the query and return at most one resulting value for a field name from the generated result. @NotNull Optional ResultQuery.fetchOptional(String fieldName, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field name from the generated result. @NotNull Optional ResultQuery.fetchOptional(Field<?> field, Class<? extends U> type) Execute the query and return at most one resulting value for a field from the generated result. <T> @NotNull Optional<T> ResultQuery.fetchOptional(Field<T> field) Execute the query and return at most one resulting value for a field from the generated result. <T, U> @NotNull Optional ResultQuery.fetchOptional(Field<T> field, Converter<? super T,? extends U> converter) Execute the query and return at most one resulting value for a field from the generated result. @NotNull Optional<?> ResultQuery.fetchOptional(Name fieldName) Execute the query and return at most one resulting value for a field name from the generated result. @NotNull Optional ResultQuery.fetchOptional(Name fieldName, Class<? extends U> type) Execute the query and return at most one resulting value for a field name from the generated result. @NotNull Optional ResultQuery.fetchOptional(Name fieldName, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field name from the generated result. <E> @NotNull Optional<E> ResultQuery.fetchOptional(RecordMapper<? super R,E> mapper) Execute the query and return at most one resulting value into a custom mapper callback. @NotNull Optional<Object[]> ResultQuery.fetchOptionalArray() Execute the query and return at most one resulting record as an array. <E> @NotNull Optional<E> Cursor.fetchOptionalInto(Class<? extends E> type) Deprecated, for removal: This API element is subject to removal in a future version. - 3.10 - [#6363] - Use Cursor.fetchNextOptionalInto(Class) instead. <Z extends Record> @NotNull Optional<Z> Cursor.fetchOptionalInto(Table<Z> table) Deprecated, for removal: This API element is subject to removal in a future version. - 3.10 - [#6363] - Use Cursor.fetchNextOptionalInto(Table) instead. <E> @NotNull Optional<E> ResultQuery.fetchOptionalInto(Class<? extends E> type) Map resulting records onto a custom type. <Z extends Record> @NotNull Optional<Z> ResultQuery.fetchOptionalInto(Table<Z> table) Map resulting records onto a custom record. @NotNull Optional<Map<String,Object>> ResultQuery.fetchOptionalMap() Execute the query and return at most one resulting record as a name/value map. @NotNull Optional<?> DSLContext.fetchOptionalValue(String sql) Execute a new query holding plain SQL. @NotNull Optional<?> DSLContext.fetchOptionalValue(String sql, Object... bindings) Execute a new query holding plain SQL. @NotNull Optional<?> DSLContext.fetchOptionalValue(String sql, QueryPart... parts) Execute a new query holding plain SQL. @NotNull Optional<?> DSLContext.fetchOptionalValue(ResultSet rs) Fetch a record from a JDBC ResultSet and return the only contained value. <T> @NotNull Optional<T> DSLContext.fetchOptionalValue(ResultSet rs, Class<T> type) Fetch a record from a JDBC ResultSet and return the only contained value. <T> @NotNull Optional<T> DSLContext.fetchOptionalValue(ResultSet rs, DataType<T> type) Fetch a record from a JDBC ResultSet and return the only contained value. <T> @NotNull Optional<T> DSLContext.fetchOptionalValue(ResultSet rs, Field<T> field) Fetch a record from a JDBC ResultSet and return the only contained value. <T, R extends Record1<T>> @NotNull Optional<T> DSLContext.fetchOptionalValue(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a single value. @NotNull Optional<?> DSLContext.fetchOptionalValue(SQL sql) Execute a new query holding plain SQL. <T> @NotNull Optional<T> DSLContext.fetchOptionalValue(TableField<?,T> field) Execute a ResultQuery in the context of this DSLContext and return a single value. O ForeignKey.fetchParent(R record) Fetch a parent record of a given record through this foreign key <O extends UpdatableRecord<O>> O TableRecord.fetchParent(ForeignKey<R,O> key) Fetch a parent record of this record, given a foreign key. @NotNull Result<O> ForeignKey.fetchParents(Collection<? extends R> records) Fetch parent records of a given set of record through this foreign key @NotNull Result<O> ForeignKey.fetchParents(R... records) Fetch parent records of a given set of record through this foreign key <O extends UpdatableRecord<O>> @NotNull Result<O> Result.fetchParents(ForeignKey<R,O> key) Fetch parent records of this record, given a foreign key, as if fetching from Result.parents(ForeignKey). <Z> @NotNull List DAO.fetchRange(Field<Z> field, Z lowerInclusive, Z upperInclusive) Find records by a given field and a range of values. @NotNull ResultSet ResultQuery.fetchResultSet() Execute the query and return the generated result as a JDBC ResultSet. @NotNull Set<?> ResultQuery.fetchSet(int fieldIndex) Execute the query and return all values for a field index from the generated result. @NotNull Set ResultQuery.fetchSet(int fieldIndex, Class<? extends U> type) Execute the query and return all values for a field index from the generated result. @NotNull Set ResultQuery.fetchSet(int fieldIndex, Converter<?,? extends U> converter) Execute the query and return all values for a field index from the generated result. @NotNull Set<?> ResultQuery.fetchSet(String fieldName) Execute the query and return all values for a field name from the generated result. @NotNull Set ResultQuery.fetchSet(String fieldName, Class<? extends U> type) Execute the query and return all values for a field name from the generated result. @NotNull Set ResultQuery.fetchSet(String fieldName, Converter<?,? extends U> converter) Execute the query and return all values for a field name from the generated result. @NotNull Set ResultQuery.fetchSet(Field<?> field, Class<? extends U> type) Execute the query and return all values for a field from the generated result. <T> @NotNull Set<T> ResultQuery.fetchSet(Field<T> field) Execute the query and return all values for a field from the generated result. <T, U> @NotNull Set ResultQuery.fetchSet(Field<T> field, Converter<? super T,? extends U> converter) Execute the query and return all values for a field from the generated result. @NotNull Set<?> ResultQuery.fetchSet(Name fieldName) Execute the query and return all values for a field name from the generated result. @NotNull Set ResultQuery.fetchSet(Name fieldName, Class<? extends U> type) Execute the query and return all values for a field name from the generated result. @NotNull Set ResultQuery.fetchSet(Name fieldName, Converter<?,? extends U> converter) Execute the query and return all values for a field name from the generated result. <E> @NotNull Set<E> ResultQuery.fetchSet(RecordMapper<? super R,E> mapper) Fetch results into a custom mapper callback. @NotNull Record DSLContext.fetchSingle(String sql) Execute a new query holding plain SQL. @NotNull Record DSLContext.fetchSingle(String sql, Object... bindings) Execute a new query holding plain SQL. @NotNull Record DSLContext.fetchSingle(String sql, QueryPart... parts) Execute a new query holding plain SQL. @NotNull Record DSLContext.fetchSingle(ResultSet rs) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. @NotNull Record DSLContext.fetchSingle(ResultSet rs, Class<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. @NotNull Record DSLContext.fetchSingle(ResultSet rs, DataType<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. @NotNull Record DSLContext.fetchSingle(ResultSet rs, Field<?>... fields) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record. @NotNull Record DSLContext.fetchSingle(Collection<? extends SelectField<?>> fields) Execute and return exactly one record for <R extends Record> R DSLContext.fetchSingle(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a record. @NotNull Record DSLContext.fetchSingle(SelectField<?>... fields) Execute and return exactly one record for <T1> @NotNull Record1<T1> DSLContext.fetchSingle(SelectField<T1> field1) Execute and return exactly one record for <T1, T2> @NotNull Record2<T1,T2> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2) Execute and return exactly one record for <T1, T2, T3> @NotNull Record3<T1,T2,T3> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3) Execute and return exactly one record for <T1, T2, T3, T4> @NotNull Record4<T1,T2,T3,T4> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4) Execute and return exactly one record for <T1, T2, T3, T4, T5> @NotNull Record5<T1,T2,T3,T4,T5> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6> @NotNull Record6<T1,T2,T3,T4,T5,T6> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7> @NotNull Record7<T1,T2,T3,T4,T5,T6,T7> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8> @NotNull Record8<T1,T2,T3,T4,T5,T6,T7,T8> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21) Execute and return exactly one record for <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22) Execute and return exactly one record for @NotNull Record DSLContext.fetchSingle(SQL sql) Execute a new query holding plain SQL. <R extends Record> R DSLContext.fetchSingle(Table<R> table) Execute and return exactly one record for <R extends Record> R DSLContext.fetchSingle(Table<R> table, Collection<? extends Condition> conditions) Execute and return exactly one record for <R extends Record> R DSLContext.fetchSingle(Table<R> table, Condition condition) Execute and return exactly one record for <R extends Record> R DSLContext.fetchSingle(Table<R> table, Condition... conditions) Execute and return exactly one record for R ResultQuery.fetchSingle() Execute the query and return exactly one resulting record. @Nullable Object ResultQuery.fetchSingle(int fieldIndex) Execute the query and return exactly one resulting value for a field index from the generated result. U ResultQuery.fetchSingle(int fieldIndex, Class<? extends U> type) Execute the query and return exactly one resulting value for a field index from the generated result. U ResultQuery.fetchSingle(int fieldIndex, Converter<?,? extends U> converter) Execute the query and return exactly one resulting value for a field index from the generated result. @Nullable Object ResultQuery.fetchSingle(String fieldName) Execute the query and return exactly one resulting value for a field name from the generated result. U ResultQuery.fetchSingle(String fieldName, Class<? extends U> type) Execute the query and return exactly one resulting value for a field name from the generated result. U ResultQuery.fetchSingle(String fieldName, Converter<?,? extends U> converter) Execute the query and return exactly one resulting value for a field name from the generated result. U ResultQuery.fetchSingle(Field<?> field, Class<? extends U> type) Execute the query and return exactly one resulting value for a field from the generated result. <T> T ResultQuery.fetchSingle(Field<T> field) Execute the query and return exactly one resulting value for a field from the generated result. <T, U> U ResultQuery.fetchSingle(Field<T> field, Converter<? super T,? extends U> converter) Execute the query and return exactly one resulting value for a field from the generated result. @Nullable Object ResultQuery.fetchSingle(Name fieldName) Execute the query and return exactly one resulting value for a field name from the generated result. U ResultQuery.fetchSingle(Name fieldName, Class<? extends U> type) Execute the query and return exactly one resulting value for a field name from the generated result. U ResultQuery.fetchSingle(Name fieldName, Converter<?,? extends U> converter) Execute the query and return exactly one resulting value for a field name from the generated result. <E> E ResultQuery.fetchSingle(RecordMapper<? super R,E> mapper) Execute the query and return exactly one resulting value into a custom mapper callback. @NotNull Object[] ResultQuery.fetchSingleArray() Execute the query and return exactly one resulting record as an array <E> E ResultQuery.fetchSingleInto(Class<? extends E> type) Map resulting records onto a custom type. <Z extends Record> Z ResultQuery.fetchSingleInto(Table<Z> table) Map resulting records onto a custom record. @NotNull Map<String,Object> ResultQuery.fetchSingleMap() Execute the query and return exactly one resulting record as a name/value map. @NotNull Stream<Record> DSLContext.fetchStream(String sql) Execute a new query holding plain SQL and "lazily" return the generated result. @NotNull Stream<Record> DSLContext.fetchStream(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result. @NotNull Stream<Record> DSLContext.fetchStream(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result. @NotNull Stream<Record> DSLContext.fetchStream(ResultSet rs) Wrap a JDBC ResultSet into a jOOQ Stream. @NotNull Stream<Record> DSLContext.fetchStream(ResultSet rs, Class<?>... types) Wrap a JDBC ResultSet into a jOOQ Stream. @NotNull Stream<Record> DSLContext.fetchStream(ResultSet rs, DataType<?>... types) Wrap a JDBC ResultSet into a jOOQ Stream. @NotNull Stream<Record> DSLContext.fetchStream(ResultSet rs, Field<?>... fields) Wrap a JDBC ResultSet into a jOOQ Stream. <R extends Record> @NotNull Stream<R> DSLContext.fetchStream(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a stream. @NotNull Stream<Record> DSLContext.fetchStream(SQL sql) Execute a new query holding plain SQL and "lazily" return the generated result. <R extends Record> @NotNull Stream<R> DSLContext.fetchStream(Table<R> table) Execute and return all records lazily for <R extends Record> @NotNull Stream<R> DSLContext.fetchStream(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records lazily for <R extends Record> @NotNull Stream<R> DSLContext.fetchStream(Table<R> table, Condition condition) Execute and return all records lazily for <R extends Record> @NotNull Stream<R> DSLContext.fetchStream(Table<R> table, Condition... conditions) Execute and return all records lazily for @NotNull Stream<R> ResultQuery.fetchStream() Stream this query. <E> @NotNull Stream<E> ResultQuery.fetchStreamInto(Class<? extends E> type) Stream this query, mapping records into a custom type. <Z extends Record> @NotNull Stream<Z> ResultQuery.fetchStreamInto(Table<Z> table) Stream this query, mapping records into a custom record. @Nullable Object DSLContext.fetchValue(String sql) Execute a new query holding plain SQL. @Nullable Object DSLContext.fetchValue(String sql, Object... bindings) Execute a new query holding plain SQL. @Nullable Object DSLContext.fetchValue(String sql, QueryPart... parts) Execute a new query holding plain SQL. @Nullable Object DSLContext.fetchValue(ResultSet rs) Fetch a record from a JDBC ResultSet and return the only contained value. <T> T DSLContext.fetchValue(ResultSet rs, Class<T> type) Fetch a record from a JDBC ResultSet and return the only contained value. <T> T DSLContext.fetchValue(ResultSet rs, DataType<T> type) Fetch a record from a JDBC ResultSet and return the only contained value. <T> T DSLContext.fetchValue(ResultSet rs, Field<T> field) Fetch a record from a JDBC ResultSet and return the only contained value. <T, R extends Record1<T>> T DSLContext.fetchValue(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a single value. <T> T DSLContext.fetchValue(SelectField<T> field) Execute a ResultQuery in the context of this DSLContext and return a single value. @Nullable Object DSLContext.fetchValue(SQL sql) Execute a new query holding plain SQL. <T> T DSLContext.fetchValue(Table<? extends Record1<T>> table) Fetch a single value from a single column table. <T> T DSLContext.fetchValue(TableField<?,T> field) Execute a ResultQuery in the context of this DSLContext and return a single value. @NotNull List<?> DSLContext.fetchValues(String sql) Execute a new query holding plain SQL. @NotNull List<?> DSLContext.fetchValues(String sql, Object... bindings) Execute a new query holding plain SQL. @NotNull List<?> DSLContext.fetchValues(String sql, QueryPart... parts) Execute a new query holding plain SQL. @NotNull List<?> DSLContext.fetchValues(ResultSet rs) Fetch a result from a JDBC ResultSet and return the only contained column's values. <T> @NotNull List<T> DSLContext.fetchValues(ResultSet rs, Class<T> type) Fetch a result from a JDBC ResultSet and return the only contained column's values. <T> @NotNull List<T> DSLContext.fetchValues(ResultSet rs, DataType<T> type) Fetch a result from a JDBC ResultSet and return the only contained column's values. <T> @NotNull List<T> DSLContext.fetchValues(ResultSet rs, Field<T> field) Fetch a result from a JDBC ResultSet and return the only contained column's values. <T, R extends Record1<T>> @NotNull List<T> DSLContext.fetchValues(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return all values for the only column. @NotNull List<?> DSLContext.fetchValues(SQL sql) Execute a new query holding plain SQL. <T> @NotNull List<T> DSLContext.fetchValues(Table<? extends Record1<T>> table) Fetch all values from a single column table. <T> @NotNull List<T> DSLContext.fetchValues(TableField<?,T> field) Fetch all values in a given Table's TableField. @NotNull List DAO.findAll() Find all records of the underlying table. P DAO.findById(T id) Find a record of the underlying table by ID. @NotNull Catalog Meta.getCatalog(String name) Get a catalog object by name from the underlying meta data source, or null if no such object exists. @NotNull Catalog Meta.getCatalog(Name name) Get a catalog object by name from the underlying meta data source, or null if no such object exists. @NotNull List<Catalog> Meta.getCatalogs() Get all catalog objects from the underlying meta data source. @NotNull List<Domain<?>> Meta.getDomains() Get all domain objects from the underlying meta data source. @NotNull List<Domain<?>> Meta.getDomains(String name) Get all domain objects by name from the underlying meta data source. @NotNull List<Domain<?>> Meta.getDomains(Name name) Get all domain objects by name from the underlying meta data source. @NotNull List<ForeignKey<?,?>> Meta.getForeignKeys() Get all foreign keys from the underlying meta data source. @NotNull List<ForeignKey<?,?>> Meta.getForeignKeys(String name) Get all foreign keys from the underlying meta data source. @NotNull List<ForeignKey<?,?>> Meta.getForeignKeys(Name name) Get all foreign keys from the underlying meta data source. @NotNull List<Index> Meta.getIndexes() Get all indexes from the underlying meta data sources. @NotNull List<Index> Meta.getIndexes(String name) Get all indexes from the underlying meta data sources. @NotNull List<Index> Meta.getIndexes(Name name) Get all indexes from the underlying meta data sources. @NotNull List<UniqueKey<?>> Meta.getPrimaryKeys() Get all primary keys from the underlying meta data source. @NotNull List<UniqueKey<?>> Meta.getPrimaryKeys(String name) Get all primary keys from the underlying meta data source. @NotNull List<UniqueKey<?>> Meta.getPrimaryKeys(Name name) Get all primary keys from the underlying meta data source. @NotNull List<Schema> Meta.getSchemas() Get all schema objects from the underlying meta data source. @NotNull List<Schema> Meta.getSchemas(String name) Get all schema objects by name from the underlying meta data source. @NotNull List<Schema> Meta.getSchemas(Name name) Get all schema objects by name from the underlying meta data source. @NotNull List<Sequence<?>> Meta.getSequences() Get all sequence objects from the underlying meta data source. @NotNull List<Sequence<?>> Meta.getSequences(String name) Get all sequence objects by name from the underlying meta data source. @NotNull List<Sequence<?>> Meta.getSequences(Name name) Get all sequence objects by name from the underlying meta data source. @NotNull List<Table<?>> Meta.getTables() Get all table objects from the underlying meta data source. @NotNull List<Table<?>> Meta.getTables(String name) Get all table objects by name from the underlying meta data source. @NotNull List<Table<?>> Meta.getTables(Name name) Get all table objects by name from the underlying meta data source. @NotNull List<UniqueKey<?>> Meta.getUniqueKeys() Get all unique keys from the underlying meta data source. @NotNull List<UniqueKey<?>> Meta.getUniqueKeys(String name) Get all unique keys from the underlying meta data source. @NotNull List<UniqueKey<?>> Meta.getUniqueKeys(Name name) Get all unique keys from the underlying meta data source. boolean Cursor.hasNext() Check whether this cursor has a next record. @NotNull InformationSchema Meta.informationSchema() Export to the InformationSchema format. void DAO.insert(Collection objects) Performs a batch INSERT statement for a given set of POJOs. void DAO.insert(P object) Performs an INSERT statement for a given POJO. void DAO.insert(P... objects) Performs a batch INSERT statement for a given set of POJOs. int TableRecord.insert() Store this record to the database using an INSERT statement. int TableRecord.insert(Collection<? extends Field<?>> fields) Store parts of this record to the database using an INSERT statement. int TableRecord.insert(Field<?>... fields) Store parts of this record to the database using an INSERT statement. int UpdatableRecord.insert() Store this record back to the database using an INSERT statement. int UpdatableRecord.insert(Collection<? extends Field<?>> fields) Store parts of this record to the database using an INSERT statement. int UpdatableRecord.insert(Field<?>... fields) Store parts of this record to the database using an INSERT statement. @NotNull Iterator<R> ResultQuery.iterator() Execute the query using ResultQuery.fetch() and return the generated result as an Iterator. @NotNull BigInteger DSLContext.lastID() Retrieve the last inserted ID. void DAO.merge(Collection objects) Performs a batch MERGE statement for a given set of POJOs. void DAO.merge(P object) Performs an MERGE statement for a given POJO. void DAO.merge(P... objects) Performs a batch MERGE statement for a given set of POJOs. int UpdatableRecord.merge() Store this record back to the database using a MERGE statement. int UpdatableRecord.merge(Collection<? extends Field<?>> fields) Store parts of this record to the database using a MERGE statement. int UpdatableRecord.merge(Field<?>... fields) Store parts of this record to the database using a MERGE statement. @NotNull Queries Meta.migrateTo(Meta other) Generate a migration script to get from this meta data to another one. @NotNull Queries Meta.migrateTo(Meta other, MigrationConfiguration configuration) Generate a migration script to get from this meta data to another one. @NotNull BigInteger DSLContext.nextval(String sequence) Convenience method to fetch the NEXTVAL for a sequence directly from this DSLContext's underlying JDBC Connection. @NotNull BigInteger DSLContext.nextval(Name sequence) Convenience method to fetch the NEXTVAL for a sequence directly from this DSLContext's underlying JDBC Connection. <T extends Number> T DSLContext.nextval(Sequence<T> sequence) Convenience method to fetch the NEXTVAL for a sequence directly from this DSLContext's underlying JDBC Connection. <T extends Number> @NotNull List<T> DSLContext.nextvals(Sequence<T> sequence, int size) Convenience method to fetch several NEXTVAL for a sequence directly from this DSLContext's underlying JDBC Connection. @NotNull SelectJoinStep<R> SelectOnStep.onKey() Join the previous table on a non-ambiguous foreign key relationship between the two joined tables. @NotNull SelectJoinStep<R> SelectOnStep.onKey(TableField<?,?>... keyFields) Join the previous table on a non-ambiguous foreign key relationship between the two joined tables. @NotNull TableOnConditionStep<R> TableOnStep.onKey() Join the table on a non-ambiguous foreign key relationship between the two joined tables. @NotNull TableOnConditionStep<R> TableOnStep.onKey(TableField<?,?>... keyFields) Join the table on a non-ambiguous foreign key relationship between the two joined tables. void UpdatableRecord.refresh() Refresh this record from the database. void UpdatableRecord.refresh(Collection<? extends Field<?>> fields) Refresh parts of this record from the database. void UpdatableRecord.refresh(Field<?>... fields) Refresh parts of this record from the database. void ConnectionProvider.release(Connection connection) Release a connection to the connection lifecycle handler. boolean Configuration.requireCommercial(Supplier<String> logMessage) Whether this is a commercial edition of jOOQ, throwing an exception with a message, if not. void TransactionProvider.rollback(TransactionContext ctx) Rollback a transaction. @NotNull Meta Meta.snapshot() Eager-create an in-memory copy of this Meta instance without any connection to the original data source. int UpdatableRecord.store() Store this record back to the database. int UpdatableRecord.store(Collection<? extends Field<?>> fields) Store parts of this record to the database. int UpdatableRecord.store(Field<?>... fields) Store parts of this record to the database. @NotNull Stream<R> Cursor.stream() Turn this Cursor into a Stream. @NotNull Stream<R> ResultQuery.stream() Stream this query. void DAO.update(Collection objects) Performs a batch UPDATE statement for a given set of POJOs. void DAO.update(P object) Performs an UPDATE statement for a given POJO. void DAO.update(P... objects) Performs a batch UPDATE statement for a given set of POJOs. int UpdatableRecord.update() Store this record back to the database using an UPDATE statement. int UpdatableRecord.update(Collection<? extends Field<?>> fields) Store parts of this record to the database using an UPDATE statement. int UpdatableRecord.update(Field<?>... fields) Store parts of this record to the database using an UPDATE statement. C Context.visit(QueryPart part) Visit a QueryPart in the current Context.




Uses of DataAccessException in org.jooq.exception
Subclasses of DataAccessException in org.jooq.exception

Modifier and Type
Class
Description
class 
ConfigurationException

The Configuration was set up in a way that does not allow for a
 particular operation.

class 
DataChangedException

An error occurred while storing a record whose underlying data had already
 been changed

class 
DataDefinitionException

An error occurred while running DDL statements in
 DSLContext.meta(org.jooq.Source...) and related API.

class 
DataMigrationException

An error occurred while running a Migration.

class 
DataMigrationValidationException

An error occurred while running Migration.validate().

class 
DataTypeException

An error occurred while handling data types.

class 
DetachedException

An operation was invoked on a detached object (Query,
 QueryPart, or UpdatableRecord).

class 
InvalidResultException

An unexpected result was encountered after executing a Query.

class 
IOException

The jOOQ IOException is a wrapper for a
 IOException.

class 
LoaderConfigurationException

The LoaderConfigurationException indicates that a Loader
 was executed with an illegal execution configuration.

class 
MappingException

An error occurred while fetching data into a user defined Java object with
 any of these methods:
 
  ResultQuery.fetchInto(Class)
  Cursor.fetchInto(Class)
  Result.into(Class)
  Record.into(Class)
 
 ...

class 
MockFileDatabaseException

An unexpected result can be encountered while loading a file-based
 MockDataProvider.

class 
NoDataFoundException

No rows were returned from a ResultQuery, when exactly one row was
 expected.

class 
TemplatingException

An exception that occurs with plain SQL templating.

class 
TooManyRowsException

Too many rows (more than 1) were returned from a ResultQuery.






Uses of DataAccessException in org.jooq.impl
Subclasses of DataAccessException in org.jooq.impl

Modifier and Type
Class
Description
class 
ParserException

An exception that arises while parsing SQL through
 DSLContext.parser().


Methods in org.jooq.impl that throw DataAccessException

Modifier and Type
Method
Description
void
DefaultConnectionProvider.commit()

Convenience method to access Connection.commit().

Record
DefaultDSLContext.fetchSingle(Collection<? extends SelectField<?>> fields)
 
Record
DefaultDSLContext.fetchSingle(SelectField<?>... fields)
 
boolean
DefaultConnectionProvider.getAutoCommit()

Convenience method to access Connection.getAutoCommit().

int
DefaultConnectionProvider.getHoldability()

Convenience method to access Connection.getHoldability().

int
DefaultConnectionProvider.getTransactionIsolation()

Convenience method to access Connection.getTransactionIsolation().

boolean
DefaultConnectionProvider.isReadOnly()

Convenience method to access Connection.isReadOnly().

void
DefaultConnectionProvider.releaseSavepoint(Savepoint savepoint)

Convenience method to access
 Connection.releaseSavepoint(Savepoint).

boolean
AbstractConfiguration.requireCommercial(Supplier<String> logMessage)
 
void
DefaultConnectionProvider.rollback()

Convenience method to access Connection.rollback().

void
DefaultConnectionProvider.rollback(Savepoint savepoint)

Convenience method to access Connection.rollback(Savepoint).

void
DefaultConnectionProvider.setAutoCommit(boolean autoCommit)

Convenience method to access Connection.setAutoCommit(boolean).

void
DefaultConnectionProvider.setHoldability(int holdability)

Convenience method to access Connection.setHoldability(int).

void
DefaultConnectionProvider.setReadOnly(boolean readOnly)

Convenience method to access Connection.setReadOnly(boolean).

@NotNull Savepoint
DefaultConnectionProvider.setSavepoint()

Convenience method to access Connection.setSavepoint().

@NotNull Savepoint
DefaultConnectionProvider.setSavepoint(String name)

Convenience method to access Connection.setSavepoint(String).

void
DefaultConnectionProvider.setTransactionIsolation(int level)

Convenience method to access
 Connection.setTransactionIsolation(int).

Uses of Classorg.jooq.exception.DataAccessException

Uses of DataAccessException in org.jooq

Uses of DataAccessException in org.jooq.exception

Uses of DataAccessException in org.jooq.impl

Uses of Class
org.jooq.exception.DataAccessException