Uses of Class org.jooq.exception.DataAccessException (jOOQ 3.17.31 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

CloseableQuery.close()

Close the underlying statement.

void

Cursor.close()

Explicitly close the underlying PreparedStatement and ResultSet.

<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 id)

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.

int @NotNull []

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, using Fields.field(String) for lookup.

 @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, using Fields.field(String) for lookup.

 @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, using Fields.field(String) for lookup.

 @NotNull List

ResultQuery.fetch(Field<?> field, Class<? extends U> type)

Execute the query and return all values for a field from the generated result, using Fields.field(Field) for lookup.

<T> @NotNull List<T>

ResultQuery.fetch(Field<T> field)

Execute the query and return all values for a field from the generated result, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

@NotNull List<?>

ResultQuery.fetch(Name fieldName)

Execute the query and return all values for a field name from the generated result, using Fields.field(Name) for lookup.

 @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, using Fields.field(Name) for lookup.

 @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, using Fields.field(Name) for lookup.

<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, using Fields.field(String) for lookup.

 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, using Fields.field(String) for lookup.

 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, using Fields.field(String) for lookup.

 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, using Fields.field(Field) for lookup.

<T> T

ResultQuery.fetchAny(Field<T> field)

Execute the query and return at most one resulting value for a field from the generated result, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

@Nullable Object

ResultQuery.fetchAny(Name fieldName)

Execute the query and return at most one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.

 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, using Fields.field(Name) for lookup.

 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, using Fields.field(Name) for lookup.

<E> E

ResultQuery.fetchAny(RecordMapper<? super R,E> mapper)

Execute the query and return at most one resulting record.

@Nullable Object @Nullable []

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 @NotNull []

ResultQuery.fetchArray()

Execute the query and return the generated result as an array of records.

@Nullable Object @NotNull []

ResultQuery.fetchArray(int fieldIndex)

Execute the query and return all values for a field index from the generated result.

 U @NotNull []

ResultQuery.fetchArray(int fieldIndex, Class<? extends U> type)

Execute the query and return all values for a field index from the generated result.

 U @NotNull []

ResultQuery.fetchArray(int fieldIndex, Converter<?,? extends U> converter)

Execute the query and return all values for a field index from the generated result.

@Nullable Object @NotNull []

ResultQuery.fetchArray(String fieldName)

Execute the query and return all values for a field name from the generated result, using Fields.field(String) for lookup.

 U @NotNull []

ResultQuery.fetchArray(String fieldName, Class<? extends U> type)

Execute the query and return all values for a field name from the generated result, using Fields.field(String) for lookup.

 U @NotNull []

ResultQuery.fetchArray(String fieldName, Converter<?,? extends U> converter)

Execute the query and return all values for a field name from the generated result, using Fields.field(String) for lookup.

 U @NotNull []

ResultQuery.fetchArray(Field<?> field, Class<? extends U> type)

Execute the query and return all values for a field from the generated result, using Fields.field(Field) for lookup.

<T> T @NotNull []

ResultQuery.fetchArray(Field<T> field)

Execute the query and return all values for a field from the generated result, using Fields.field(Field) for lookup.

<T, U> U @NotNull []

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, using Fields.field(Field) for lookup.

@Nullable Object @NotNull []

ResultQuery.fetchArray(Name fieldName)

Execute the query and return all values for a field name from the generated result, using Fields.field(Name) for lookup.

 U @NotNull []

ResultQuery.fetchArray(Name fieldName, Class<? extends U> type)

Execute the query and return all values for a field name from the generated result, using Fields.field(Name) for lookup.

 U @NotNull []

ResultQuery.fetchArray(Name fieldName, Converter<?,? extends U> converter)

Execute the query and return all values for a field name from the generated result, using Fields.field(Name) for lookup.

@Nullable Object @NotNull [] @NotNull []

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.

<K, V> @NotNull Map<K,List<V>>

DSLContext.fetchGroups(ResultQuery<? extends Record2<K,V>> query)

Execute the query and return a Map with the first column as the map key and the second column as the map values.

@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, using Fields.field(String) for lookup.

@NotNull Map<Record,Result<R>>

ResultQuery.fetchGroups(String[] keyFieldNames)

Execute the query and return a Map with the result grouped by the given keys, using Fields.field(String) for lookup.

@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, using Fields.field(String) for lookup.

<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, using Fields.field(String) for lookup.

@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, using Fields.field(String) for lookup.

<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, using Fields.field(String) for lookup.

@NotNull Map<Record,Result<R>>

ResultQuery.fetchGroups(Field<?>[] keys)

Execute the query and return a Map with the result grouped by the given keys, using Fields.field(Field) for lookup.

@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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

@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, using Fields.field(Name) for lookup.

@NotNull Map<Record,Result<R>>

ResultQuery.fetchGroups(Name[] keyFieldNames)

Execute the query and return a Map with the result grouped by the given keys, using Fields.field(Name) for lookup.

@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, using Fields.field(Name) for lookup.

<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, using Fields.field(Name) for lookup.

@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, using Fields.field(Name) for lookup.

<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, using Fields.field(Name) for lookup.

<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.

<K, V> @NotNull Map<K,V>

DSLContext.fetchMap(ResultQuery<? extends Record2<K,V>> query)

Execute the query and return a Map with the first column as the map key and the second column as the map value.

@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, using Fields.field(String) for lookup.

@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, using Fields.field(String) for lookup.

<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, using Fields.field(String) for lookup.

@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, using Fields.field(String) for lookup.

<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, using Fields.field(String) for lookup.

<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, using Fields.field(String) for lookup.

@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, using Fields.field(String) for lookup.

<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, using Fields.field(String) for lookup.

@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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

@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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

@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, using Fields.field(Name) for lookup.

@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, using Fields.field(Name) for lookup.

<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, using Fields.field(Name) for lookup.

@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, using Fields.field(Name) for lookup.

<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, using Fields.field(Name) for lookup.

<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, using Fields.field(Name) for lookup.

@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, using Fields.field(Name) for lookup.

<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, using Fields.field(Name) for lookup.

<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, using Fields.field(String) for lookup.

 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, using Fields.field(String) for lookup.

 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, using Fields.field(String) for lookup.

 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, using Fields.field(Field) for lookup.

<T> T

ResultQuery.fetchOne(Field<T> field)

Execute the query and return at most one resulting value for a field from the generated result, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

@Nullable Object

ResultQuery.fetchOne(Name fieldName)

Execute the query and return at most one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.

 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, using Fields.field(Name) for lookup.

 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, using Fields.field(Name) for lookup.

<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 @Nullable []

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, using Fields.field(String) for lookup.

 @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, using Fields.field(String) for lookup.

 @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, using Fields.field(String) for lookup.

 @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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

@NotNull Optional<?>

ResultQuery.fetchOptional(Name fieldName)

Execute the query and return at most one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.

 @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, using Fields.field(Name) for lookup.

 @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, using Fields.field(Name) for lookup.

<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, using Fields.field(String) for lookup.

 @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, using Fields.field(String) for lookup.

 @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, using Fields.field(String) for lookup.

 @NotNull Set

ResultQuery.fetchSet(Field<?> field, Class<? extends U> type)

Execute the query and return all values for a field from the generated result, using Fields.field(Field) for lookup.

<T> @NotNull Set<T>

ResultQuery.fetchSet(Field<T> field)

Execute the query and return all values for a field from the generated result, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

@NotNull Set<?>

ResultQuery.fetchSet(Name fieldName)

Execute the query and return all values for a field name from the generated result, using Fields.field(Name) for lookup.

 @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, using Fields.field(Name) for lookup.

 @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, using Fields.field(Name) for lookup.

<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 extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

<R extends Record> R

DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22)

Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).

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, using Fields.field(String) for lookup.

 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, using Fields.field(String) for lookup.

 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, using Fields.field(String) for lookup.

 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, using Fields.field(Field) for lookup.

<T> T

ResultQuery.fetchSingle(Field<T> field)

Execute the query and return exactly one resulting value for a field from the generated result, using Fields.field(Field) for lookup.

<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, using Fields.field(Field) for lookup.

@Nullable Object

ResultQuery.fetchSingle(Name fieldName)

Execute the query and return exactly one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.

 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, using Fields.field(Name) for lookup.

 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, using Fields.field(Name) for lookup.

<E> E

ResultQuery.fetchSingle(RecordMapper<? super R,E> mapper)

Execute the query and return exactly one resulting value into a custom mapper callback.

@Nullable Object @NotNull []

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 Optional

DAO.findOptionalById(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 SelectOnConditionStep<R>

SelectOnStep.onKey()

Join the previous table on a non-ambiguous foreign key relationship between the two joined tables.

@NotNull SelectOnConditionStep<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(Condition part)

Visit a Condition as an ordinary QueryPart.

C

Context.visit(Field<?> part)

Visit a Field as a DSL.field(Condition), if it is a Condition, or as an ordinery QueryPart, otherwise.

C

Context.visit(QueryPart part)

Visit a QueryPart in the current Context.

C

Context.visitSubquery(QueryPart part)

Visit a QueryPart as a subquery 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 with optimistic locking active, 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

final 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

final void

DefaultConnectionProvider.commit()

Convenience method to access Connection.commit().

Record

DefaultDSLContext.fetchSingle(Collection<? extends SelectField<?>> fields)

Record

DefaultDSLContext.fetchSingle(SelectField<?>... fields)

final boolean

DefaultConnectionProvider.getAutoCommit()

Convenience method to access Connection.getAutoCommit().

final int

DefaultConnectionProvider.getHoldability()

Convenience method to access Connection.getHoldability().

final int

DefaultConnectionProvider.getTransactionIsolation()

Convenience method to access Connection.getTransactionIsolation().

final boolean

DefaultConnectionProvider.isReadOnly()

Convenience method to access Connection.isReadOnly().

final void

DefaultConnectionProvider.releaseSavepoint(Savepoint savepoint)

Convenience method to access Connection.releaseSavepoint(Savepoint).

boolean

AbstractConfiguration.requireCommercial(Supplier<String> logMessage)

static final void

Internal.requireCommercial(Supplier<String> logMessage)

Whether this is a commercial edition of jOOQ, throwing an exception with a message, if not.

final void

DefaultConnectionProvider.rollback()

Convenience method to access Connection.rollback().

final void

DefaultConnectionProvider.rollback(Savepoint savepoint)

Convenience method to access Connection.rollback(Savepoint).

final void

DefaultConnectionProvider.setAutoCommit(boolean autoCommit)

Convenience method to access Connection.setAutoCommit(boolean).

final void

DefaultConnectionProvider.setHoldability(int holdability)

Convenience method to access Connection.setHoldability(int).

final void

DefaultConnectionProvider.setReadOnly(boolean readOnly)

Convenience method to access Connection.setReadOnly(boolean).

final @NotNull Savepoint

DefaultConnectionProvider.setSavepoint()

Convenience method to access Connection.setSavepoint().

final @NotNull Savepoint

DefaultConnectionProvider.setSavepoint(String name)

Convenience method to access Connection.setSavepoint(String).

final 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