Uses of Class
org.jooq.exception.DataAccessException
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's exceptions.
This package contains jOOQ's implementation classes.
-
Uses of DataAccessException in org.jooq
Modifier and TypeMethodDescriptionLoaderError.exception()
The underlyingDataAccessException
that caused the error.ResultOrRows.exception()
The exception if applicable ornull
if there was no exception.Modifier and TypeMethodDescription@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
Apply a migration to this meta to produce a newMeta
.@NotNull Meta
Meta.apply
(Collection<? extends Query> migration) Apply a migration to this meta to produce a newMeta
.@NotNull Meta
Apply a migration to this meta to produce a newMeta
.@NotNull Meta
Apply a migration to this meta to produce a newMeta
.void
TransactionProvider.begin
(TransactionContext ctx) Begin a new transaction.@NotNull BindContext
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 thisDSLContext
.void
Cursor.close()
Explicitly close the underlyingPreparedStatement
andResultSet
.void
Query.close()
Close the underlying statement.<X,
A> X Reduce the execution results of this query using aCollector
.<X,
A> X Reduce the execution results of this query using aCollector
.void
TransactionProvider.commit
(TransactionContext ctx) Commit a transaction.long
DAO.count()
Count all records of the underlying table.@NotNull BigInteger
Convenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.@NotNull BigInteger
Convenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.<T extends Number>
TConvenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.@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<P> objects) Performs aDELETE
statement for a given set of POJOs.void
Performs aDELETE
statement for a POJOvoid
Performs aDELETE
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 aDELETE
statement for a given set of IDs.void
DAO.deleteById
(T... ids) Performs aDELETE
statement for a given set of IDs.int @NotNull []
Batch.execute()
Execute the batch operation.int
Execute a query holding plain SQL.int
Execute a new query holding plain SQL.int
Execute a new query holding plain SQL.int
Execute aQuery
in the context of thisDSLContext
.int
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 connectionint
Routine.execute
(Configuration configuration) Execute the stored object using aConfiguration
objectint
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
Checks if a given POJO exists.boolean
DAO.existsById
(T id) Checks if a given ID exists.Cursor.fetch()
Fetch all remaining records as a result.Cursor.fetch
(int number) Deprecated, for removal: This API element is subject to removal in a future version.<E> @NotNull List<E>
Cursor.fetch
(RecordMapper<? super R, E> mapper) Fetch results into a custom mapper callback.DAO.fetch
(Field<Z> field, Collection<? extends Z> values) Find records by a given field and a set of values.Find records by a given field and a set of values.Execute a new query holding plain SQL.Execute a new query holding plain SQL.Execute a new query holding plain SQL.DSLContext.fetch
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return results.Execute a new query holding plain SQL.Execute and return all records forDSLContext.fetch
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records forExecute and return all records forExecute and return all records forResultQuery.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.<U> @NotNull List<U>
Execute the query and return all values for a field index from the generated result.<U> @NotNull List<U>
Execute the query and return all values for a field index from the generated result.@NotNull List<?>
Execute the query and return all values for a field name from the generated result.<U> @NotNull List<U>
Execute the query and return all values for a field name from the generated result.<U> @NotNull List<U>
Execute the query and return all values for a field name from the generated result.<U> @NotNull List<U>
Execute the query and return all values for a field from the generated result.<T> @NotNull List<T>
Execute the query and return all values for a field from the generated result.<T,
U> @NotNull List<U> Execute the query and return all values for a field from the generated result.@NotNull List<?>
Execute the query and return all values for a field name from the generated result.<U> @NotNull List<U>
Execute the query and return all values for a field name from the generated result.<U> @NotNull List<U>
Execute the query and return all values for a field name from the generated result.<E> @NotNull List<E>
ResultQuery.fetch
(RecordMapper<? super R, E> mapper) Fetch results into a custom mapper callback.<R extends Record>
RExecute and return zero or one record for<R extends Record>
RDSLContext.fetchAny
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RExecute and return zero or on e record forResultQuery.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> U
Execute the query and return at most one resulting value for a field index from the generated result.<U> U
Execute the query and return at most one resulting value for a field index from the generated result.@Nullable Object
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field from the generated result.<T> T
Execute the query and return at most one resulting value for a field from the generated result.<T,
U> U Execute the query and return at most one resulting value for a field from the generated result.@Nullable Object
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<E> E
ResultQuery.fetchAny
(RecordMapper<? super R, E> mapper) Execute the query and return at most one resulting record.@Nullable Object @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>
ZResultQuery.fetchAnyInto
(Table<Z> table) Map resulting records onto a custom record.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> 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> 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.<U> 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.<U> 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.<U> U @NotNull []
ResultQuery.fetchArray
(Field<?> field, Class<? extends U> type) Execute the query and return all values for a field from the generated result.<T> T @NotNull []
ResultQuery.fetchArray
(Field<T> field) Execute the query and return all values for a field from the generated result.<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.@Nullable Object @NotNull []
ResultQuery.fetchArray
(Name fieldName) Execute the query and return all values for a field name from the generated result.<U> 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.<U> 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.@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>>
OUpdatableRecord.fetchChild
(ForeignKey<O, R> key) Fetch a child record of this record, given a foreign key.ForeignKey.fetchChildren
(Collection<? extends O> records) Fetch child records of a given set of records through this foreign keyForeignKey.fetchChildren
(O record) Fetch child records of a given record through this foreign keyForeignKey.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 fromResult.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) 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 aSelect
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.DSLContext.fetchFromCSV
(String string) Fetch all data from a CSV string.DSLContext.fetchFromCSV
(String string, boolean header) Fetch all data from a CSV string.DSLContext.fetchFromCSV
(String string, boolean header, char delimiter) Fetch all data from a CSV string.DSLContext.fetchFromCSV
(String string, char delimiter) Fetch all data from a CSV string.DSLContext.fetchFromHTML
(String string) Convert an HTML table into a jOOQResult
.DSLContext.fetchFromTXT
(String string) Fetch all data from a formatted string.DSLContext.fetchFromTXT
(String string, String nullLiteral) Fetch all data from a formatted string.DSLContext.fetchGroups
(ResultQuery<? extends Record2<K, V>> query) Execute the query and return aMap
with the first column as the map key and the second column as the map values.ResultQuery.fetchGroups
(int keyFieldIndex) Execute the query and return aMap
with one of the result's columns as key and a list of corresponding records as value.ResultQuery.fetchGroups
(int[] keyFieldIndexes) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(int keyFieldIndex, int valueFieldIndex) Execute the query and return aMap
with one of the result's columns as key and another one of the result's columns as valueResultQuery.fetchGroups
(int keyFieldIndex, Class<? extends E> type) Return aMap
with results grouped by the given key and mapped into the given entity type.ResultQuery.fetchGroups
(int keyFieldIndex, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key and mapped by the given mapper.ResultQuery.fetchGroups
(String keyFieldName) Execute the query and return aMap
with one of the result's columns as key and a list of corresponding records as value.ResultQuery.fetchGroups
(String[] keyFieldNames) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(String keyFieldName, Class<? extends E> type) Return aMap
with results grouped by the given key and mapped into the given entity type.ResultQuery.fetchGroups
(String keyFieldName, String valueFieldName) Execute the query and return aMap
with one of the result's columns as key and another one of the result's columns as valueResultQuery.fetchGroups
(String keyFieldName, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key and mapped by the given mapper.ResultQuery.fetchGroups
(Field<?>[] keys) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(Field<?>[] keys, Field<?>[] values) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(Field<K> key) Execute the query and return aMap
with one of the result's columns as key and a list of corresponding records as value.ResultQuery.fetchGroups
(Field<K> key, Class<? extends E> type) Return aMap
with results grouped by the given key and mapped into the given entity type.ResultQuery.fetchGroups
(Field<K> key, Field<V> value) Execute the query and return aMap
with one of the result's columns as key and another one of the result's columns as valueResultQuery.fetchGroups
(Field<K> key, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key and mapped by the given mapper.ResultQuery.fetchGroups
(Name keyFieldName) Execute the query and return aMap
with one of the result's columns as key and a list of corresponding records as value.ResultQuery.fetchGroups
(Name[] keyFieldNames) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(Name keyFieldName, Class<? extends E> type) Return aMap
with results grouped by the given key and mapped into the given entity type.ResultQuery.fetchGroups
(Name keyFieldName, Name valueFieldName) Execute the query and return aMap
with one of the result's columns as key and another one of the result's columns as valueResultQuery.fetchGroups
(Name keyFieldName, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key and mapped by the given mapper.ResultQuery.fetchGroups
(Table<S> table) Execute the query and return aMap
with the result grouped by the given table.ResultQuery.fetchGroups
(Table<S> table, Class<? extends E> type) Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.ResultQuery.fetchGroups
(Table<S> table, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.ResultQuery.fetchGroups
(Table<S> keyTable, Table<T> valueTable) Execute the query and return aMap
with the result grouped by the given table.<H extends RecordHandler<? super R>>
HCursor.fetchInto
(H handler) Deprecated, for removal: This API element is subject to removal in a future version.- 3.15.0 - [#11902] - UseIterable.forEach(Consumer)
based methods, instead.<E> @NotNull List<E>
Map resulting records onto a custom type.Map resulting records onto a custom record.<H extends RecordHandler<? super R>>
HResultQuery.fetchInto
(H handler) Deprecated, for removal: This API element is subject to removal in a future version.- 3.15.0 - [#11902] - UseIterable.forEach(Consumer)
based methods, instead.<E> @NotNull List<E>
Map resulting records onto a custom type.Map resulting records onto a custom record.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchLazy
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a cursor.Execute a new query holding plain SQL and "lazily" return the generated result.Execute and return all records lazily forDSLContext.fetchLazy
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records lazily forExecute and return all records lazily forExecute and return all records lazily forResultQuery.fetchLazy()
Execute the query and "lazily" return the generated result.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.DSLContext.fetchMany
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a cursor.@NotNull Results
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 aMap
with the first column as the map key and the second column as the map value.ResultQuery.fetchMap
(int keyFieldIndex) Execute the query and return aMap
with one of the result's columns as key and the corresponding records as value.ResultQuery.fetchMap
(int[] keyFieldIndexes) Execute the query and return aMap
with keys as a map key and the corresponding record as value.ResultQuery.fetchMap
(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMap
with keys as a map key and the corresponding record as value.Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type.ResultQuery.fetchMap
(int[] keyFieldIndexes, RecordMapper<? super R, E> mapper) Execute the query and return aMap
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 aMap
with one of the result's columns as key and another one of the result's columns as value<E> @NotNull Map<?,
E> Execute the query and return aMap
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 aMap
with results grouped by the given key and mapped by the given mapper.Execute the query and return aMap
with results grouped by the given key entity.<K,
V> @NotNull Map<K, V> Execute the query and return aMap
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 aMap
with results grouped by the given key entity and mapped into the given entity type.Execute the query and return aMap
with one of the result's columns as key and the corresponding records as value.Execute the query and return aMap
with keys as a map key and the corresponding record as value.Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type.Execute the query and return aMap
with keys as a map key and the corresponding record as value.ResultQuery.fetchMap
(String[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper.<E> @NotNull Map<?,
E> Execute the query and return aMap
with results grouped by the given key and mapped into the given entity type.@NotNull Map<?,
?> Execute the query and return aMap
with one of the result's columns as key and another one of the result's columns as value<E> @NotNull Map<?,
E> ResultQuery.fetchMap
(String keyFieldName, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given key and mapped by the given mapper.Execute the query and return aMap
with keys as a map key and the corresponding record as value.Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type.Execute the query and return aMap
with keys as a map key and the corresponding record as value.ResultQuery.fetchMap
(Field<?>[] keys, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper.Execute the query and return aMap
with one of the result's columns as key and the corresponding records as value.<K,
E> @NotNull Map<K, E> Execute the query and return aMap
with results grouped by the given key and mapped into the given entity type.<K,
V> @NotNull Map<K, V> Execute the query and return aMap
with one of the result's columns as key and another one of the result's columns as value<K,
E> @NotNull Map<K, E> ResultQuery.fetchMap
(Field<K> key, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given key and mapped by the given mapper.Execute the query and return aMap
with one of the result's columns as key and the corresponding records as value.Execute the query and return aMap
with keys as a map key and the corresponding record as value.Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type.Execute the query and return aMap
with keys as a map key and the corresponding record as value.ResultQuery.fetchMap
(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper.<E> @NotNull Map<?,
E> Execute the query and return aMap
with results grouped by the given key and mapped into the given entity type.@NotNull Map<?,
?> Execute the query and return aMap
with one of the result's columns as key and another one of the result's columns as value<E> @NotNull Map<?,
E> ResultQuery.fetchMap
(Name keyFieldName, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given key and mapped by the given mapper.ResultQuery.fetchMap
(RecordMapper<? super R, K> keyMapper) Execute the query and return aMap
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 aMap
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 aMap
with results grouped by the given key entity and mapped into the given entity type.Execute the query and return aMap
with table as a map key and the corresponding record as value.Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.ResultQuery.fetchMap
(Table<S> table, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.Execute the query and return aMap
with table as a map key and the corresponding record as value.ResultQuery.fetchMaps()
Execute the query and return the generated result as a list of name/value maps.Cursor.fetchNext()
Fetch the next record from the cursor.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>>
HCursor.fetchNextInto
(H handler) Deprecated, for removal: This API element is subject to removal in a future version.- 3.15.0 - [#11902] - UseIterable.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>
ZCursor.fetchNextInto
(Table<Z> table) Map the next resulting record onto a custom record.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.Cursor.fetchNextOptionalInto
(Table<Z> table) Map the next resulting record onto a custom record.Cursor.fetchOne()
Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.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] - UseCursor.fetchNext(RecordMapper)
instead.<Z> P
Find a unique record by a given field and a value.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
@Nullable Record
@Nullable Record
@Nullable Record
<R extends Record>
RDSLContext.fetchOne
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.@Nullable Record
Execute a new query holding plain SQL.<R extends Record>
RExecute and return zero or one record for<R extends Record>
RDSLContext.fetchOne
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record for<R extends Record>
RExecute and return zero or one record for<R extends Record>
RExecute and return zero or one record forResultQuery.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> U
Execute the query and return at most one resulting value for a field index from the generated result.<U> U
Execute the query and return at most one resulting value for a field index from the generated result.@Nullable Object
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field from the generated result.<T> T
Execute the query and return at most one resulting value for a field from the generated result.<T,
U> U Execute the query and return at most one resulting value for a field from the generated result.@Nullable Object
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<E> E
ResultQuery.fetchOne
(RecordMapper<? super R, E> mapper) Execute the query and return at most one resulting value into a custom mapper callback.@Nullable Object @Nullable []
ResultQuery.fetchOneArray()
Execute the query and return at most one resulting record as an array<H extends RecordHandler<? super R>>
HCursor.fetchOneInto
(H handler) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.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] - UseCursor.fetchNextInto(Class)
instead.<Z extends Record>
ZCursor.fetchOneInto
(Table<Z> table) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.fetchNextInto(Table)
instead.<E> E
ResultQuery.fetchOneInto
(Class<? extends E> type) Map resulting records onto a custom type.<Z extends Record>
ZResultQuery.fetchOneInto
(Table<Z> table) Map resulting records onto a custom record.ResultQuery.fetchOneMap()
Execute the query and return at most one resulting record as a name/value map.Cursor.fetchOptional()
Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.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] - UseCursor.fetchNextOptional(RecordMapper)
instead.DAO.fetchOptional
(Field<Z> field, Z value) Find a unique record by a given field and a value.DSLContext.fetchOptional
(String sql) Execute a new query holding plain SQL.DSLContext.fetchOptional
(String sql, Object... bindings) Execute a new query holding plain SQL.DSLContext.fetchOptional
(String sql, QueryPart... parts) Execute a new query holding plain SQL.DSLContext.fetchOptional
(ResultSet rs) DSLContext.fetchOptional
(ResultSet rs, Class<?>... types) DSLContext.fetchOptional
(ResultSet rs, DataType<?>... types) DSLContext.fetchOptional
(ResultSet rs, Field<?>... fields) DSLContext.fetchOptional
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.DSLContext.fetchOptional
(SQL sql) Execute a new query holding plain SQL.DSLContext.fetchOptional
(Table<R> table) Execute and return zero or one record forDSLContext.fetchOptional
(Table<R> table, Collection<? extends Condition> conditions) Execute and return zero or one record forDSLContext.fetchOptional
(Table<R> table, Condition condition) Execute and return zero or one record forDSLContext.fetchOptional
(Table<R> table, Condition... conditions) Execute and return zero or one record forResultQuery.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.<U> @NotNull Optional<U>
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.<U> @NotNull Optional<U>
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.<U> @NotNull Optional<U>
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.<U> @NotNull Optional<U>
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.<U> @NotNull Optional<U>
ResultQuery.fetchOptional
(Field<?> field, Class<? extends U> type) Execute the query and return at most one resulting value for a field from the generated result.<T> @NotNull Optional<T>
ResultQuery.fetchOptional
(Field<T> field) Execute the query and return at most one resulting value for a field from the generated result.<T,
U> @NotNull Optional<U> ResultQuery.fetchOptional
(Field<T> field, Converter<? super T, ? extends U> converter) Execute the query and return at most one resulting value for a field from the generated result.@NotNull Optional<?>
ResultQuery.fetchOptional
(Name fieldName) Execute the query and return at most one resulting value for a field name from the generated result.<U> @NotNull Optional<U>
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.<U> @NotNull Optional<U>
ResultQuery.fetchOptional
(Name fieldName, Converter<?, ? extends U> converter) Execute the query and return at most one resulting value for a field name from the generated result.<E> @NotNull Optional<E>
ResultQuery.fetchOptional
(RecordMapper<? super R, E> mapper) Execute the query and return at most one resulting value into a custom mapper callback.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] - UseCursor.fetchNextOptionalInto(Class)
instead.Cursor.fetchOptionalInto
(Table<Z> table) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6363] - UseCursor.fetchNextOptionalInto(Table)
instead.<E> @NotNull Optional<E>
ResultQuery.fetchOptionalInto
(Class<? extends E> type) Map resulting records onto a custom type.ResultQuery.fetchOptionalInto
(Table<Z> table) Map resulting records onto a custom record.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 JDBCResultSet
and return the only contained value.<T> @NotNull Optional<T>
DSLContext.fetchOptionalValue
(ResultSet rs, Class<T> type) Fetch a record from a JDBCResultSet
and return the only contained value.<T> @NotNull Optional<T>
DSLContext.fetchOptionalValue
(ResultSet rs, DataType<T> type) Fetch a record from a JDBCResultSet
and return the only contained value.<T> @NotNull Optional<T>
DSLContext.fetchOptionalValue
(ResultSet rs, Field<T> field) Fetch a record from a JDBCResultSet
and return the only contained value.DSLContext.fetchOptionalValue
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
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 aResultQuery
in the context of thisDSLContext
and return a single value.ForeignKey.fetchParent
(R record) Fetch a parent record of a given record through this foreign key<O extends UpdatableRecord<O>>
OTableRecord.fetchParent
(ForeignKey<R, O> key) Fetch a parent record of this record, given a foreign key.ForeignKey.fetchParents
(Collection<? extends R> records) Fetch parent records of a given set of record through this foreign keyForeignKey.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 fromResult.parents(ForeignKey)
.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 JDBCResultSet
.@NotNull Set<?>
ResultQuery.fetchSet
(int fieldIndex) Execute the query and return all values for a field index from the generated result.<U> @NotNull Set<U>
Execute the query and return all values for a field index from the generated result.<U> @NotNull Set<U>
Execute the query and return all values for a field index from the generated result.@NotNull Set<?>
Execute the query and return all values for a field name from the generated result.<U> @NotNull Set<U>
Execute the query and return all values for a field name from the generated result.<U> @NotNull Set<U>
Execute the query and return all values for a field name from the generated result.<U> @NotNull Set<U>
Execute the query and return all values for a field from the generated result.<T> @NotNull Set<T>
Execute the query and return all values for a field from the generated result.<T,
U> @NotNull Set<U> Execute the query and return all values for a field from the generated result.@NotNull Set<?>
Execute the query and return all values for a field name from the generated result.<U> @NotNull Set<U>
Execute the query and return all values for a field name from the generated result.<U> @NotNull Set<U>
Execute the query and return all values for a field name from the generated result.<E> @NotNull Set<E>
ResultQuery.fetchSet
(RecordMapper<? super R, E> mapper) Fetch results into a custom mapper callback.@NotNull Record
DSLContext.fetchSingle
(String sql) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(ResultSet rs) @NotNull Record
DSLContext.fetchSingle
(ResultSet rs, Class<?>... types) @NotNull Record
DSLContext.fetchSingle
(ResultSet rs, DataType<?>... types) @NotNull Record
DSLContext.fetchSingle
(ResultSet rs, Field<?>... fields) @NotNull Record
DSLContext.fetchSingle
(Collection<? extends SelectField<?>> fields) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
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>
RDSLContext.fetchSingle
(Table<R> table) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Collection<? extends Condition> conditions) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition condition) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle
(Table<R> table, Condition... conditions) Execute and return exactly one record forResultQuery.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> 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> U
ResultQuery.fetchSingle
(int fieldIndex, Converter<?, ? extends U> converter) Execute the query and return exactly one resulting value for a field index from the generated result.@Nullable Object
ResultQuery.fetchSingle
(String fieldName) Execute the query and return exactly one resulting value for a field name from the generated result.<U> U
ResultQuery.fetchSingle
(String fieldName, Class<? extends U> type) Execute the query and return exactly one resulting value for a field name from the generated result.<U> U
ResultQuery.fetchSingle
(String fieldName, Converter<?, ? extends U> converter) Execute the query and return exactly one resulting value for a field name from the generated result.<U> U
ResultQuery.fetchSingle
(Field<?> field, Class<? extends U> type) Execute the query and return exactly one resulting value for a field from the generated result.<T> T
ResultQuery.fetchSingle
(Field<T> field) Execute the query and return exactly one resulting value for a field from the generated result.<T,
U> U ResultQuery.fetchSingle
(Field<T> field, Converter<? super T, ? extends U> converter) Execute the query and return exactly one resulting value for a field from the generated result.@Nullable Object
ResultQuery.fetchSingle
(Name fieldName) Execute the query and return exactly one resulting value for a field name from the generated result.<U> U
ResultQuery.fetchSingle
(Name fieldName, Class<? extends U> type) Execute the query and return exactly one resulting value for a field name from the generated result.<U> U
ResultQuery.fetchSingle
(Name fieldName, Converter<?, ? extends U> converter) Execute the query and return exactly one resulting value for a field name from the generated result.<E> E
ResultQuery.fetchSingle
(RecordMapper<? super R, E> mapper) Execute the query and return exactly one resulting value into a custom mapper callback.@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>
ZResultQuery.fetchSingleInto
(Table<Z> table) Map resulting records onto a custom record.ResultQuery.fetchSingleMap()
Execute the query and return exactly one resulting record as a name/value map.DSLContext.fetchStream
(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream
(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream
(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream
(ResultSet rs) DSLContext.fetchStream
(ResultSet rs, Class<?>... types) DSLContext.fetchStream
(ResultSet rs, DataType<?>... types) DSLContext.fetchStream
(ResultSet rs, Field<?>... fields) DSLContext.fetchStream
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a stream.DSLContext.fetchStream
(SQL sql) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream
(Table<R> table) Execute and return all records lazily forDSLContext.fetchStream
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records lazily forDSLContext.fetchStream
(Table<R> table, Condition condition) Execute and return all records lazily forDSLContext.fetchStream
(Table<R> table, Condition... conditions) Execute and return all records lazily forResultQuery.fetchStream()
Stream this query.<E> @NotNull Stream<E>
ResultQuery.fetchStreamInto
(Class<? extends E> type) Stream this query, mapping records into a custom type.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 JDBCResultSet
and return the only contained value.<T> T
DSLContext.fetchValue
(ResultSet rs, Class<T> type) Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
DSLContext.fetchValue
(ResultSet rs, DataType<T> type) Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
DSLContext.fetchValue
(ResultSet rs, Field<T> field) Fetch a record from a JDBCResultSet
and return the only contained value.<T,
R extends Record1<T>>
TDSLContext.fetchValue
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a single value.<T> T
DSLContext.fetchValue
(SelectField<T> field) Execute aResultQuery
in the context of thisDSLContext
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 aResultQuery
in the context of thisDSLContext
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 JDBCResultSet
and return the only contained column's values.<T> @NotNull List<T>
DSLContext.fetchValues
(ResultSet rs, Class<T> type) Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> @NotNull List<T>
DSLContext.fetchValues
(ResultSet rs, DataType<T> type) Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> @NotNull List<T>
DSLContext.fetchValues
(ResultSet rs, Field<T> field) Fetch a result from a JDBCResultSet
and return the only contained column's values.DSLContext.fetchValues
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
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 givenTable
'sTableField
.DAO.findAll()
Find all records of the underlying table.Find a record of the underlying table by ID.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, ornull
if no such object exists.@NotNull Catalog
Meta.getCatalog
(Name name) Get a catalog object by name from the underlying meta data source, ornull
if no such object exists.Meta.getCatalogs()
Get all catalog objects from the underlying meta data source.Meta.getDomains()
Get all domain objects from the underlying meta data source.Meta.getDomains
(String name) Get all domain objects by name from the underlying meta data source.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.Meta.getIndexes()
Get all indexes from the underlying meta data sources.Meta.getIndexes
(String name) Get all indexes from the underlying meta data sources.Meta.getIndexes
(Name name) Get all indexes from the underlying meta data sources.Meta.getPrimaryKeys()
Get all primary keys from the underlying meta data source.Meta.getPrimaryKeys
(String name) Get all primary keys from the underlying meta data source.Meta.getPrimaryKeys
(Name name) Get all primary keys from the underlying meta data source.Meta.getSchemas()
Get all schema objects from the underlying meta data source.Meta.getSchemas
(String name) Get all schema objects by name from the underlying meta data source.Meta.getSchemas
(Name name) Get all schema objects by name from the underlying meta data source.Meta.getSequences()
Get all sequence objects from the underlying meta data source.Meta.getSequences
(String name) Get all sequence objects by name from the underlying meta data source.Meta.getSequences
(Name name) Get all sequence objects by name from the underlying meta data source.Meta.getTables()
Get all table objects from the underlying meta data source.Get all table objects by name from the underlying meta data source.Get all table objects by name from the underlying meta data source.Meta.getUniqueKeys()
Get all unique keys from the underlying meta data source.Meta.getUniqueKeys
(String name) Get all unique keys from the underlying meta data source.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 theInformationSchema
format.void
DAO.insert
(Collection<P> objects) Performs a batchINSERT
statement for a given set of POJOs.void
Performs anINSERT
statement for a given POJO.void
Performs a batchINSERT
statement for a given set of POJOs.int
TableRecord.insert()
Store this record to the database using anINSERT
statement.int
TableRecord.insert
(Collection<? extends Field<?>> fields) Store parts of this record to the database using anINSERT
statement.int
Store parts of this record to the database using anINSERT
statement.int
UpdatableRecord.insert()
Store this record back to the database using anINSERT
statement.int
UpdatableRecord.insert
(Collection<? extends Field<?>> fields) Store parts of this record to the database using anINSERT
statement.int
Store parts of this record to the database using anINSERT
statement.ResultQuery.iterator()
Execute the query usingResultQuery.fetch()
and return the generated result as anIterator
.@NotNull BigInteger
DSLContext.lastID()
Retrieve the last inserted ID.void
DAO.merge
(Collection<P> objects) Performs a batchMERGE
statement for a given set of POJOs.void
Performs anMERGE
statement for a given POJO.void
Performs a batchMERGE
statement for a given set of POJOs.int
UpdatableRecord.merge()
Store this record back to the database using aMERGE
statement.int
UpdatableRecord.merge
(Collection<? extends Field<?>> fields) Store parts of this record to the database using aMERGE
statement.int
Store parts of this record to the database using aMERGE
statement.@NotNull Queries
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
Convenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.@NotNull BigInteger
Convenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.<T extends Number>
TConvenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.Convenience method to fetch several NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.@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
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 thisMeta
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
Store parts of this record to the database.Cursor.stream()
Turn thisCursor
into aStream
.ResultQuery.stream()
Stream this query.void
DAO.update
(Collection<P> objects) Performs a batchUPDATE
statement for a given set of POJOs.void
Performs anUPDATE
statement for a given POJO.void
Performs a batchUPDATE
statement for a given set of POJOs.int
UpdatableRecord.update()
Store this record back to the database using anUPDATE
statement.int
UpdatableRecord.update
(Collection<? extends Field<?>> fields) Store parts of this record to the database using anUPDATE
statement.int
Store parts of this record to the database using anUPDATE
statement.Visit aQueryPart
in the currentContext
.Context.visitSubquery
(QueryPart part) Visit aQueryPart
as a subquery in the currentContext
. -
Uses of DataAccessException in org.jooq.exception
Modifier and TypeClassDescriptionclass
TheConfiguration
was set up in a way that does not allow for a particular operation.class
An error occurred while storing a record with optimistic locking active, whose underlying data had already been changed.class
An error occurred while running DDL statements inDSLContext.meta(org.jooq.Source...)
and related API.class
An error occurred while running aMigration
.class
An error occurred while runningMigration.validate()
.class
An error occurred while handling data types.class
class
An unexpected result was encountered after executing aQuery
.class
The jOOQIOException
is a wrapper for aIOException
.class
TheLoaderConfigurationException
indicates that aLoader
was executed with an illegal execution configuration.class
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
An unexpected result can be encountered while loading a file-basedMockDataProvider
.class
No rows were returned from aResultQuery
, when exactly one row was expected.class
An exception that occurs with plainSQL
templating.class
Too many rows (more than 1) were returned from aResultQuery
. -
Uses of DataAccessException in org.jooq.impl
Modifier and TypeClassDescriptionfinal class
An exception that arises while parsing SQL throughDSLContext.parser()
.Modifier and TypeMethodDescriptionfinal void
DefaultConnectionProvider.commit()
Convenience method to accessConnection.commit()
.DefaultDSLContext.fetchSingle
(Collection<? extends SelectField<?>> fields) DefaultDSLContext.fetchSingle
(SelectField<?>... fields) final boolean
DefaultConnectionProvider.getAutoCommit()
Convenience method to accessConnection.getAutoCommit()
.final int
DefaultConnectionProvider.getHoldability()
Convenience method to accessConnection.getHoldability()
.final int
DefaultConnectionProvider.getTransactionIsolation()
Convenience method to accessConnection.getTransactionIsolation()
.final boolean
DefaultConnectionProvider.isReadOnly()
Convenience method to accessConnection.isReadOnly()
.final void
DefaultConnectionProvider.releaseSavepoint
(Savepoint savepoint) Convenience method to accessConnection.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 accessConnection.rollback()
.final void
Convenience method to accessConnection.rollback(Savepoint)
.final void
DefaultConnectionProvider.setAutoCommit
(boolean autoCommit) Convenience method to accessConnection.setAutoCommit(boolean)
.final void
DefaultConnectionProvider.setHoldability
(int holdability) Convenience method to accessConnection.setHoldability(int)
.final void
DefaultConnectionProvider.setReadOnly
(boolean readOnly) Convenience method to accessConnection.setReadOnly(boolean)
.final @NotNull Savepoint
DefaultConnectionProvider.setSavepoint()
Convenience method to accessConnection.setSavepoint()
.final @NotNull Savepoint
DefaultConnectionProvider.setSavepoint
(String name) Convenience method to accessConnection.setSavepoint(String)
.final void
DefaultConnectionProvider.setTransactionIsolation
(int level) Convenience method to accessConnection.setTransactionIsolation(int)
.
Cursor.fetchNext(int)
instead.