Uses of Class
org.jooq.exception.DataAccessException
Packages that use 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
Methods in org.jooq that return DataAccessExceptionModifier and TypeMethodDescriptionLoaderError.exception()The underlyingDataAccessExceptionthat caused the error.ResultOrRows.exception()The exception if applicable ornullif there was no exception.Methods in org.jooq that throw DataAccessExceptionModifier and TypeMethodDescription@Nullable ConnectionConnectionProvider.acquire()Acquire a connection from the connection lifecycle handler.voidSelectQuery.addJoinOnKey(TableLike<?> table, JoinType type) Joins the existing table product to a new table using a foreign key.voidSelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, QOM.JoinHint hint) Joins the existing table product to a new table using a foreign key.voidSelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, QOM.JoinHint hint, TableField<?, ?>... keyFields) Joins the existing table product to a new table using a foreign key.voidSelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, TableField<?, ?>... keyFields) Joins the existing table product to a new table using a foreign key.@NotNull MetaApply a migration to this meta to produce a newMeta.@NotNull MetaMeta.apply(Collection<? extends Query> migration) Apply a migration to this meta to produce a newMeta.@NotNull MetaApply a migration to this meta to produce a newMeta.@NotNull MetaApply a migration to this meta to produce a newMeta.voidTransactionProvider.begin(TransactionContext ctx) Begin a new transaction.@NotNull BindContextBind a value using a specific type.voidQuery.cancel()Cancel the underlying statement.voidCloseableDSLContext.close()Close the underlying resources, if any resources have been allocated when constructing thisDSLContext.voidCloseableQuery.close()Close the underlying statement.voidCursor.close()Explicitly close the underlyingPreparedStatementandResultSet.<X,A> X Reduce the execution results of this query using aCollector.<X,A> X Reduce the execution results of this query using aCollector.voidTransactionProvider.commit(TransactionContext ctx) Commit a transaction.longDAO.count()Count all records of the underlying table.@NotNull BigIntegerConvenience method to fetch the CURRVAL for a sequence directly from thisDSLContext's underlying JDBCConnection.@NotNull BigIntegerConvenience 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 QueriesMeta.ddl()Generate a creation script for the entire meta data.@NotNull QueriesMeta.ddl(DDLExportConfiguration configuration) Generate a creation script for the entire meta data.voidDAO.delete(Collection<P> objects) Performs aDELETEstatement for a given set of POJOs.voidPerforms aDELETEstatement for a POJOvoidPerforms aDELETEstatement for a given set of POJOs.intUpdatableRecord.delete()Deletes this record from the database, based on the value of the primary key or main unique key.voidDAO.deleteById(Collection<T> ids) Performs aDELETEstatement for a given set of IDs.voidDAO.deleteById(T id) Performs aDELETEstatement for a given set of IDs.voidDAO.deleteById(T... ids) Performs aDELETEstatement for a given set of IDs.int @NotNull []Batch.execute()Execute the batch operation.intExecute a query holding plain SQL.intExecute a new query holding plain SQL.intExecute a new query holding plain SQL.intExecute aQueryin the context of thisDSLContext.intExecute a query holding plain SQL.intQuery.execute()Execute the query, if it has been created with a proper configuration.intRoutine.execute()Execute the stored object on an underlying connectionintRoutine.execute(Configuration configuration) Execute the stored object using aConfigurationobjectintDSLContext.executeDelete(TableRecord<?> record, Condition condition) Delete a record from a table.intDSLContext.executeDelete(UpdatableRecord<?> record) Delete a record from a table.intDSLContext.executeInsert(TableRecord<?> record) Insert one record.intDSLContext.executeUpdate(TableRecord<?> record, Condition condition) Update a table.intDSLContext.executeUpdate(UpdatableRecord<?> record) Update a table.booleanChecks if a given POJO exists.booleanDAO.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 aResultQueryin the context of thisDSLContextand 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, usingFields.field(String)for lookup.<U> @NotNull List<U> Execute the query and return all values for a field name from the generated result, usingFields.field(String)for lookup.<U> @NotNull List<U> Execute the query and return all values for a field name from the generated result, usingFields.field(String)for lookup.<U> @NotNull List<U> Execute the query and return all values for a field from the generated result, usingFields.field(Field)for lookup.<T> @NotNull List<T> Execute the query and return all values for a field from the generated result, usingFields.field(Field)for lookup.<T,U> @NotNull List <U> Execute the query and return all values for a field from the generated result, usingFields.field(Field)for lookup.@NotNull List<?> Execute the query and return all values for a field name from the generated result, usingFields.field(Name)for lookup.<U> @NotNull List<U> Execute the query and return all values for a field name from the generated result, usingFields.field(Name)for lookup.<U> @NotNull List<U> Execute the query and return all values for a field name from the generated result, usingFields.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>
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 ObjectResultQuery.fetchAny(int fieldIndex) Execute the query and return at most one resulting value for a field index from the generated result.<U> UExecute the query and return at most one resulting value for a field index from the generated result.<U> UExecute the query and return at most one resulting value for a field index from the generated result.@Nullable ObjectExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(String)for lookup.<U> UExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(String)for lookup.<U> UExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(String)for lookup.<U> UExecute the query and return at most one resulting value for a field from the generated result, usingFields.field(Field)for lookup.<T> TExecute the query and return at most one resulting value for a field from the generated result, usingFields.field(Field)for lookup.<T,U> U Execute the query and return at most one resulting value for a field from the generated result, usingFields.field(Field)for lookup.@Nullable ObjectExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<U> UExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<U> UExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<E> EResultQuery.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> EResultQuery.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.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, usingFields.field(String)for lookup.<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, usingFields.field(String)for lookup.<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, usingFields.field(String)for lookup.<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, usingFields.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, usingFields.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, usingFields.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, usingFields.field(Name)for lookup.<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, usingFields.field(Name)for lookup.<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, usingFields.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>>
OUpdatableRecord.fetchChild(ForeignKey<O, R> key) Fetch a child record of this record, given a foreign key.ForeignKey.fetchChildren(Collection<? extends PARENT> records) Fetch child records of a given set of records through this foreign keyForeignKey.fetchChildren(PARENT record) Fetch child records of a given record through this foreign keyForeignKey.fetchChildren(PARENT... 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.intDSLContext.fetchCount(Select<?> query) intDSLContext.fetchCount(Table<?> table) Count the number of records in a table.intDSLContext.fetchCount(Table<?> table, Collection<? extends Condition> conditions) Count the number of records in a table that satisfy a condition.intDSLContext.fetchCount(Table<?> table, Condition condition) Count the number of records in a table that satisfy a condition.intDSLContext.fetchCount(Table<?> table, Condition... conditions) Count the number of records in a table that satisfy a condition.booleanDSLContext.fetchExists(Select<?> query) Check if aSelectwould return any records, if it were executed.booleanDSLContext.fetchExists(Table<?> table) Check if a table has any records.booleanDSLContext.fetchExists(Table<?> table, Collection<? extends Condition> conditions) Check if a table has any records that satisfy a condition.booleanDSLContext.fetchExists(Table<?> table, Condition condition) Check if a table has any records that satisfy a condition.booleanDSLContext.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 aMapwith the first column as the map key and the second column as the map values.ResultQuery.fetchGroups(int keyFieldIndex) Execute the query and return aMapwith 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 aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMapwith the result grouped by the given keys.ResultQuery.fetchGroups(int keyFieldIndex, int valueFieldIndex) Execute the query and return aMapwith one of the result's columns as key and another one of the result's columns as value.ResultQuery.fetchGroups(int keyFieldIndex, Class<? extends E> type) Return aMapwith results grouped by the given key and mapped into the given entity type.ResultQuery.fetchGroups(int keyFieldIndex, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given key and mapped by the given mapper.ResultQuery.fetchGroups(String keyFieldName) Execute the query and return aMapwith one of the result's columns as key and a list of corresponding records as value, usingFields.field(String)for lookup.ResultQuery.fetchGroups(String[] keyFieldNames) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(String)for lookup.ResultQuery.fetchGroups(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(String)for lookup.ResultQuery.fetchGroups(String keyFieldName, Class<? extends E> type) Return aMapwith results grouped by the given key and mapped into the given entity type, usingFields.field(String)for lookup.ResultQuery.fetchGroups(String keyFieldName, String valueFieldName) Execute the query and return aMapwith one of the result's columns as key and another one of the result's columns as value, usingFields.field(String)for lookup.ResultQuery.fetchGroups(String keyFieldName, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given key and mapped by the given mapper, usingFields.field(String)for lookup.ResultQuery.fetchGroups(Field<?>[] keys) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Field<?>[] keys, Field<?>[] values) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Field<K> key) Execute the query and return aMapwith one of the result's columns as key and a list of corresponding records as value, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Field<K> key, Class<? extends E> type) Return aMapwith results grouped by the given key and mapped into the given entity type, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Field<K> key, Field<V> value) Execute the query and return aMapwith one of the result's columns as key and another one of the result's columns as value, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Field<K> key, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given key and mapped by the given mapper, usingFields.field(Field)for lookup.ResultQuery.fetchGroups(Name keyFieldName) Execute the query and return aMapwith one of the result's columns as key and a list of corresponding records as value, usingFields.field(Name)for lookup.ResultQuery.fetchGroups(Name[] keyFieldNames) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(Name)for lookup.ResultQuery.fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return aMapwith the result grouped by the given keys, usingFields.field(Name)for lookup.ResultQuery.fetchGroups(Name keyFieldName, Class<? extends E> type) Return aMapwith results grouped by the given key and mapped into the given entity type, usingFields.field(Name)for lookup.ResultQuery.fetchGroups(Name keyFieldName, Name valueFieldName) Execute the query and return aMapwith one of the result's columns as key and another one of the result's columns as value, usingFields.field(Name)for lookup.ResultQuery.fetchGroups(Name keyFieldName, RecordMapper<? super R, E> mapper) Return aMapwith results grouped by the given key and mapped by the given mapper, usingFields.field(Name)for lookup.ResultQuery.fetchGroups(Table<S> table) Execute the query and return aMapwith the result grouped by the given table.ResultQuery.fetchGroups(Table<S> table, Class<? extends E> type) Execute the query and return aMapwith 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 aMapwith 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 aMapwith 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 aResultQueryin the context of thisDSLContextand 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 ResultsExecute a new query holding plain SQL, possibly returning several result sets.@NotNull ResultsExecute a new query holding plain SQL, possibly returning several result sets.@NotNull ResultsExecute a new query holding plain SQL, possibly returning several result sets.DSLContext.fetchMany(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand return a cursor.@NotNull ResultsExecute a new query holding plain SQL, possibly returning several result sets.@NotNull ResultsResultQuery.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 aMapwith the first column as the map key and the second column as the map value.ResultQuery.fetchMap(int keyFieldIndex) Execute the query and return aMapwith one of the result's columns as key and the corresponding records as value.ResultQuery.fetchMap(int[] keyFieldIndexes) Execute the query and return aMapwith keys as a map key and the corresponding record as value.ResultQuery.fetchMap(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMapwith keys as a map key and the corresponding record as value.Execute the query and return aMapwith 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 aMapwith 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 aMapwith 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 aMapwith 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 aMapwith results grouped by the given key and mapped by the given mapper.Execute the query and return aMapwith results grouped by the given key entity.<K,V> @NotNull Map <K, V> Execute the query and return aMapwith 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 aMapwith results grouped by the given key entity and mapped into the given entity type.Execute the query and return aMapwith one of the result's columns as key and the corresponding records as value, usingFields.field(String)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(String)for lookup.Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(String)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(String)for lookup.ResultQuery.fetchMap(String[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper, usingFields.field(String)for lookup.<E> @NotNull Map<?, E> Execute the query and return aMapwith results grouped by the given key and mapped into the given entity type, usingFields.field(String)for lookup.@NotNull Map<?, ?> Execute the query and return aMapwith one of the result's columns as key and another one of the result's columns as value, usingFields.field(String)for lookup.<E> @NotNull Map<?, E> ResultQuery.fetchMap(String keyFieldName, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given key and mapped by the given mapper, usingFields.field(String)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Field)for lookup.Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(Field)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Field)for lookup.ResultQuery.fetchMap(Field<?>[] keys, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper, usingFields.field(Field)for lookup.Execute the query and return aMapwith one of the result's columns as key and the corresponding records as value, usingFields.field(Field)for lookup.<K,E> @NotNull Map <K, E> Execute the query and return aMapwith results grouped by the given key and mapped into the given entity type, usingFields.field(Field)for lookup.<K,V> @NotNull Map <K, V> Execute the query and return aMapwith one of the result's columns as key and another one of the result's columns as value, usingFields.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 aMapwith results grouped by the given key and mapped by the given mapper, usingFields.field(Field)for lookup.Execute the query and return aMapwith one of the result's columns as key and the corresponding records as value, usingFields.field(Name)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Name)for lookup.Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Name)for lookup.ResultQuery.fetchMap(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given keys and mapped by the given mapper, usingFields.field(Name)for lookup.<E> @NotNull Map<?, E> Execute the query and return aMapwith results grouped by the given key and mapped into the given entity type, usingFields.field(Name)for lookup.@NotNull Map<?, ?> Execute the query and return aMapwith one of the result's columns as key and another one of the result's columns as value, usingFields.field(Name)for lookup.<E> @NotNull Map<?, E> ResultQuery.fetchMap(Name keyFieldName, RecordMapper<? super R, E> mapper) Execute the query and return aMapwith results grouped by the given key and mapped by the given mapper, usingFields.field(Name)for lookup.ResultQuery.fetchMap(RecordMapper<? super R, K> keyMapper) Execute the query and return aMapwith 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 aMapwith 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 aMapwith results grouped by the given key entity and mapped into the given entity type.Execute the query and return aMapwith table as a map key and the corresponding record as value.Execute the query and return aMapwith 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 aMapwith results grouped by the given table and mapped by the given mapper.Execute the query and return aMapwith 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> ECursor.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> ECursor.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> ECursor.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> PFind a unique record by a given field and a value.@Nullable RecordExecute a new query holding plain SQL.@Nullable RecordExecute a new query holding plain SQL.@Nullable RecordExecute a new query holding plain SQL.@Nullable Record@Nullable Record@Nullable Record@Nullable Record<R extends Record>
RDSLContext.fetchOne(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand return a record.@Nullable RecordExecute 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 ObjectResultQuery.fetchOne(int fieldIndex) Execute the query and return at most one resulting value for a field index from the generated result.<U> UExecute the query and return at most one resulting value for a field index from the generated result.<U> UExecute the query and return at most one resulting value for a field index from the generated result.@Nullable ObjectExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(String)for lookup.<U> UExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(String)for lookup.<U> UExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(String)for lookup.<U> UExecute the query and return at most one resulting value for a field from the generated result, usingFields.field(Field)for lookup.<T> TExecute the query and return at most one resulting value for a field from the generated result, usingFields.field(Field)for lookup.<T,U> U Execute the query and return at most one resulting value for a field from the generated result, usingFields.field(Field)for lookup.@Nullable ObjectExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<U> UExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<U> UExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<E> EResultQuery.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> ECursor.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> EResultQuery.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 aResultQueryin the context of thisDSLContextand 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, usingFields.field(String)for lookup.<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, usingFields.field(String)for lookup.<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, usingFields.field(String)for lookup.<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, usingFields.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, usingFields.field(Field)for lookup.<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, usingFields.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, usingFields.field(Name)for lookup.<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, usingFields.field(Name)for lookup.<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, usingFields.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.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 JDBCResultSetand return the only contained value.<T> @NotNull Optional<T> DSLContext.fetchOptionalValue(ResultSet rs, Class<T> type) Fetch a record from a JDBCResultSetand return the only contained value.<T> @NotNull Optional<T> DSLContext.fetchOptionalValue(ResultSet rs, DataType<T> type) Fetch a record from a JDBCResultSetand return the only contained value.<T> @NotNull Optional<T> DSLContext.fetchOptionalValue(ResultSet rs, Field<T> field) Fetch a record from a JDBCResultSetand return the only contained value.DSLContext.fetchOptionalValue(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand 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 aResultQueryin the context of thisDSLContextand return a single value.<T> @NotNull Optional<T> DSLContext.fetchOptionalValue(TableField<?, T> field, Condition condition) Execute aResultQueryin the context of thisDSLContextand return a single value.ForeignKey.fetchParent(CHILD 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(CHILD... records) Fetch parent records of a given set of record through this foreign keyForeignKey.fetchParents(Collection<? extends CHILD> 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 ResultSetResultQuery.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, usingFields.field(String)for lookup.<U> @NotNull Set<U> Execute the query and return all values for a field name from the generated result, usingFields.field(String)for lookup.<U> @NotNull Set<U> Execute the query and return all values for a field name from the generated result, usingFields.field(String)for lookup.<U> @NotNull Set<U> Execute the query and return all values for a field from the generated result, usingFields.field(Field)for lookup.<T> @NotNull Set<T> Execute the query and return all values for a field from the generated result, usingFields.field(Field)for lookup.<T,U> @NotNull Set <U> Execute the query and return all values for a field from the generated result, usingFields.field(Field)for lookup.@NotNull Set<?> Execute the query and return all values for a field name from the generated result, usingFields.field(Name)for lookup.<U> @NotNull Set<U> Execute the query and return all values for a field name from the generated result, usingFields.field(Name)for lookup.<U> @NotNull Set<U> Execute the query and return all values for a field name from the generated result, usingFields.field(Name)for lookup.<E> @NotNull Set<E> ResultQuery.fetchSet(RecordMapper<? super R, E> mapper) Fetch results into a custom mapper callback.@NotNull RecordDSLContext.fetchSingle(String sql) Execute a new query holding plain SQL.@NotNull RecordDSLContext.fetchSingle(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull RecordDSLContext.fetchSingle(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull RecordDSLContext.fetchSingle(ResultSet rs) @NotNull RecordDSLContext.fetchSingle(ResultSet rs, Class<?>... types) @NotNull RecordDSLContext.fetchSingle(ResultSet rs, DataType<?>... types) @NotNull RecordDSLContext.fetchSingle(ResultSet rs, Field<?>... fields) @NotNull RecordDSLContext.fetchSingle(Collection<? extends SelectField<?>> fields) Execute and return exactly one record for<R extends Record>
RDSLContext.fetchSingle(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand return a record.@NotNull RecordDSLContext.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 RecordDSLContext.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 for<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDisambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9) Disambiguation overload ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).<R extends Record>
RDSLContext.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 ofDSLContext.fetchSingle(Table, Condition...).ResultQuery.fetchSingle()Execute the query and return exactly one resulting record.@Nullable ObjectResultQuery.fetchSingle(int fieldIndex) Execute the query and return exactly one resulting value for a field index from the generated result.<U> UResultQuery.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> UResultQuery.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 ObjectResultQuery.fetchSingle(String fieldName) Execute the query and return exactly one resulting value for a field name from the generated result, usingFields.field(String)for lookup.<U> UResultQuery.fetchSingle(String fieldName, Class<? extends U> type) Execute the query and return exactly one resulting value for a field name from the generated result, usingFields.field(String)for lookup.<U> UResultQuery.fetchSingle(String fieldName, Converter<?, ? extends U> converter) Execute the query and return exactly one resulting value for a field name from the generated result, usingFields.field(String)for lookup.<U> UResultQuery.fetchSingle(Field<?> field, Class<? extends U> type) Execute the query and return exactly one resulting value for a field from the generated result, usingFields.field(Field)for lookup.<T> TResultQuery.fetchSingle(Field<T> field) Execute the query and return exactly one resulting value for a field from the generated result, usingFields.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, usingFields.field(Field)for lookup.@Nullable ObjectResultQuery.fetchSingle(Name fieldName) Execute the query and return exactly one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<U> UResultQuery.fetchSingle(Name fieldName, Class<? extends U> type) Execute the query and return exactly one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<U> UResultQuery.fetchSingle(Name fieldName, Converter<?, ? extends U> converter) Execute the query and return exactly one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<E> EResultQuery.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> EResultQuery.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 aResultQueryin the context of thisDSLContextand 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 ObjectDSLContext.fetchValue(String sql) Execute a new query holding plain SQL.@Nullable ObjectDSLContext.fetchValue(String sql, Object... bindings) Execute a new query holding plain SQL.@Nullable ObjectDSLContext.fetchValue(String sql, QueryPart... parts) Execute a new query holding plain SQL.@Nullable ObjectDSLContext.fetchValue(ResultSet rs) Fetch a record from a JDBCResultSetand return the only contained value.<T> TDSLContext.fetchValue(ResultSet rs, Class<T> type) Fetch a record from a JDBCResultSetand return the only contained value.<T> TDSLContext.fetchValue(ResultSet rs, DataType<T> type) Fetch a record from a JDBCResultSetand return the only contained value.<T> TDSLContext.fetchValue(ResultSet rs, Field<T> field) Fetch a record from a JDBCResultSetand return the only contained value.<T,R extends Record1<T>>
TDSLContext.fetchValue(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand return a single value.<T> TDSLContext.fetchValue(SelectField<T> field) Execute aResultQueryin the context of thisDSLContextand return a single value.@Nullable ObjectDSLContext.fetchValue(SQL sql) Execute a new query holding plain SQL.<T> TDSLContext.fetchValue(Table<? extends Record1<T>> table) Fetch a single value from a single column table.<T> TDSLContext.fetchValue(TableField<?, T> field) Execute aResultQueryin the context of thisDSLContextand return a single value.<T> TDSLContext.fetchValue(TableField<?, T> field, Condition condition) Execute aResultQueryin the context of thisDSLContextand 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 JDBCResultSetand return the only contained column's values.<T> @NotNull List<T> DSLContext.fetchValues(ResultSet rs, Class<T> type) Fetch a result from a JDBCResultSetand return the only contained column's values.<T> @NotNull List<T> DSLContext.fetchValues(ResultSet rs, DataType<T> type) Fetch a result from a JDBCResultSetand return the only contained column's values.<T> @NotNull List<T> DSLContext.fetchValues(ResultSet rs, Field<T> field) Fetch a result from a JDBCResultSetand return the only contained column's values.DSLContext.fetchValues(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand 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.<T> @NotNull List<T> DSLContext.fetchValues(TableField<?, T> field, Condition condition) 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 CatalogMeta.getCatalog(String name) Get a catalog object by name from the underlying meta data source, ornullif no such object exists.@NotNull CatalogMeta.getCatalog(Name name) Get a catalog object by name from the underlying meta data source, ornullif 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.getTriggers()Get all trigger objects from the underlying meta data source.Meta.getTriggers(String name) Get all trigger objects by name from the underlying meta data source.Meta.getTriggers(Name name) Get all trigger 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.booleanCursor.hasNext()Check whether this cursor has a next record.@NotNull InformationSchemaMeta.informationSchema()Export to theInformationSchemaformat.voidDAO.insert(Collection<P> objects) Performs a batchINSERTstatement for a given set of POJOs.voidPerforms anINSERTstatement for a given POJO.voidPerforms a batchINSERTstatement for a given set of POJOs.intTableRecord.insert()Store this record to the database using anINSERTstatement.intTableRecord.insert(Collection<? extends Field<?>> fields) Store parts of this record to the database using anINSERTstatement.intStore parts of this record to the database using anINSERTstatement.intUpdatableRecord.insert()Store this record back to the database using anINSERTstatement.intUpdatableRecord.insert(Collection<? extends Field<?>> fields) Store parts of this record to the database using anINSERTstatement.intStore parts of this record to the database using anINSERTstatement.ResultQuery.iterator()Execute the query usingResultQuery.fetch()and return the generated result as anIterator.@NotNull BigIntegerDSLContext.lastID()Retrieve the last inserted ID.voidDAO.merge(Collection<P> objects) Performs a batchMERGEstatement for a given set of POJOs.voidPerforms anMERGEstatement for a given POJO.voidPerforms a batchMERGEstatement for a given set of POJOs.intUpdatableRecord.merge()Store this record back to the database using aMERGEstatement.intUpdatableRecord.merge(Collection<? extends Field<?>> fields) Store parts of this record to the database using aMERGEstatement.intStore parts of this record to the database using aMERGEstatement.@NotNull QueriesGenerate a migration script to get from this meta data to another one.@NotNull QueriesMeta.migrateTo(Meta other, MigrationConfiguration configuration) Generate a migration script to get from this meta data to another one.@NotNull BigIntegerConvenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext's underlying JDBCConnection.@NotNull BigIntegerConvenience 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.voidUpdatableRecord.refresh()Refresh this record from the database.voidUpdatableRecord.refresh(Collection<? extends Field<?>> fields) Refresh parts of this record from the database.voidRefresh parts of this record from the database.voidConnectionProvider.release(Connection connection) Release a connection to the connection lifecycle handler.booleanConfiguration.requireCommercial(Supplier<String> logMessage) Whether this is a commercial edition of jOOQ, throwing an exception with a message, if not.voidTransactionProvider.rollback(TransactionContext ctx) Rollback a transaction.@NotNull MetaMeta.snapshot()Eager-create an in-memory copy of thisMetainstance without any connection to the original data source.intUpdatableRecord.store()Store this record back to the database.intUpdatableRecord.store(Collection<? extends Field<?>> fields) Store parts of this record to the database.intStore parts of this record to the database.Cursor.stream()Turn thisCursorinto aStream.ResultQuery.stream()Stream this query.voidDAO.update(Collection<P> objects) Performs a batchUPDATEstatement for a given set of POJOs.voidPerforms anUPDATEstatement for a given POJO.voidPerforms a batchUPDATEstatement for a given set of POJOs.intUpdatableRecord.update()Store this record back to the database using anUPDATEstatement.intUpdatableRecord.update(Collection<? extends Field<?>> fields) Store parts of this record to the database using anUPDATEstatement.intStore parts of this record to the database using anUPDATEstatement.Visit aFieldas aDSL.field(Condition), if it is aCondition, or as an ordineryQueryPart, otherwise.Visit aQueryPartin the currentContext.Context.visitSubquery(QueryPart part) Visit aQueryPartas a subquery in the currentContext. -
Uses of DataAccessException in org.jooq.exception
Subclasses of DataAccessException in org.jooq.exceptionModifier and TypeClassDescriptionclassTheConfigurationwas set up in a way that does not allow for a particular operation.classAn error occurred while storing a record with optimistic locking active, whose underlying data had already been changed.classAn error occurred while running DDL statements inDSLContext.meta(org.jooq.Source...)and related API.classTheDataExceptionis jOOQ's equivalent of JDBC'sSQLDataException.classAn error occurred while running aMigration.classAn error occurred while runningMigration.verify()orCommits.load(java.io.File), etc.classAn error occurred while handling data types.classclassTheIntegrityConstraintViolationExceptionis jOOQ's equivalent of JDBC'sSQLIntegrityConstraintViolationException.classAn unexpected result was encountered after executing aQuery.classThe jOOQIOExceptionis a wrapper for aIOException.classTheLoaderConfigurationExceptionindicates that aLoaderwas executed with an illegal execution configuration.classAn 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)...classAn unexpected result can be encountered while loading a file-basedMockDataProvider.classNo rows were returned from aResultQuery, when exactly one row was expected.classAn exception that occurs with plainSQLtemplating.classToo many rows (more than 1) were returned from aResultQuery. -
Uses of DataAccessException in org.jooq.impl
Subclasses of DataAccessException in org.jooq.implModifier and TypeClassDescriptionfinal classAn exception that arises while parsing SQL throughDSLContext.parser().Methods in org.jooq.impl that throw DataAccessExceptionModifier and TypeMethodDescriptionfinal voidDefaultConnectionProvider.commit()Convenience method to accessConnection.commit().DefaultDSLContext.fetchSingle(Collection<? extends SelectField<?>> fields) DefaultDSLContext.fetchSingle(SelectField<?>... fields) final booleanDefaultConnectionProvider.getAutoCommit()Convenience method to accessConnection.getAutoCommit().final intDefaultConnectionProvider.getHoldability()Convenience method to accessConnection.getHoldability().final intDefaultConnectionProvider.getTransactionIsolation()Convenience method to accessConnection.getTransactionIsolation().final booleanDefaultConnectionProvider.isReadOnly()Convenience method to accessConnection.isReadOnly().final voidDefaultConnectionProvider.releaseSavepoint(Savepoint savepoint) Convenience method to accessConnection.releaseSavepoint(Savepoint).booleanAbstractConfiguration.requireCommercial(Supplier<String> logMessage) static final voidInternal.requireCommercial(Supplier<String> logMessage) Whether this is a commercial edition of jOOQ, throwing an exception with a message, if not.final voidDefaultConnectionProvider.rollback()Convenience method to accessConnection.rollback().final voidConvenience method to accessConnection.rollback(Savepoint).final voidDefaultConnectionProvider.setAutoCommit(boolean autoCommit) Convenience method to accessConnection.setAutoCommit(boolean).final voidDefaultConnectionProvider.setHoldability(int holdability) Convenience method to accessConnection.setHoldability(int).final voidDefaultConnectionProvider.setReadOnly(boolean readOnly) Convenience method to accessConnection.setReadOnly(boolean).final @NotNull SavepointDefaultConnectionProvider.setSavepoint()Convenience method to accessConnection.setSavepoint().final @NotNull SavepointDefaultConnectionProvider.setSavepoint(String name) Convenience method to accessConnection.setSavepoint(String).final voidDefaultConnectionProvider.setTransactionIsolation(int level) Convenience method to accessConnection.setTransactionIsolation(int).
Cursor.fetchNext(int)instead.