Uses of Class
org.jooq.exception.TooManyRowsException

Packages that use TooManyRowsException

Package	Description
org.jooq	This package contains jOOQ's public API.

Uses of TooManyRowsException in org.jooq

Methods in org.jooq that throw TooManyRowsException

Modifier and Type	Method	Description
<O extends TableRecord<O>> O	UpdatableRecord.fetchChild(ForeignKey<O,R> key)	Fetch a child record of this record, given a foreign key.
@Nullable Record	DSLContext.fetchOne(String sql)	Execute a new query holding plain SQL.
@Nullable Record	DSLContext.fetchOne(String sql, Object... bindings)	Execute a new query holding plain SQL.
@Nullable Record	DSLContext.fetchOne(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@Nullable Record	DSLContext.fetchOne(ResultSet rs)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
@Nullable Record	DSLContext.fetchOne(ResultSet rs, Class<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
@Nullable Record	DSLContext.fetchOne(ResultSet rs, DataType<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
@Nullable Record	DSLContext.fetchOne(ResultSet rs, Field<?>... fields)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
<R extends Record> R	DSLContext.fetchOne(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return a record.
@Nullable Record	DSLContext.fetchOne(SQL sql)	Execute a new query holding plain SQL.
<R extends Record> R	DSLContext.fetchOne(Table<R> table)	Execute and return zero or one record for
<R extends Record> R	DSLContext.fetchOne(Table<R> table, Collection<? extends Condition> conditions)	Execute and return zero or one record for
<R extends Record> R	DSLContext.fetchOne(Table<R> table, Condition condition)	Execute and return zero or one record for
<R extends Record> R	DSLContext.fetchOne(Table<R> table, Condition... conditions)	Execute and return zero or one record for
R	ResultQuery.fetchOne()	Execute the query and return at most one resulting record.
@Nullable Object	ResultQuery.fetchOne(int fieldIndex)	Execute the query and return at most one resulting value for a field index from the generated result.
<U> U	ResultQuery.fetchOne(int fieldIndex, Class<? extends U> type)	Execute the query and return at most one resulting value for a field index from the generated result.
<U> U	ResultQuery.fetchOne(int fieldIndex, Converter<?,? extends U> converter)	Execute the query and return at most one resulting value for a field index from the generated result.
@Nullable Object	ResultQuery.fetchOne(String fieldName)	Execute the query and return at most one resulting value for a field name from the generated result.
<U> U	ResultQuery.fetchOne(String fieldName, Class<? extends U> type)	Execute the query and return at most one resulting value for a field name from the generated result.
<U> U	ResultQuery.fetchOne(String fieldName, Converter<?,? extends U> converter)	Execute the query and return at most one resulting value for a field name from the generated result.
<U> U	ResultQuery.fetchOne(Field<?> field, Class<? extends U> type)	Execute the query and return at most one resulting value for a field from the generated result.
<T> T	ResultQuery.fetchOne(Field<T> field)	Execute the query and return at most one resulting value for a field from the generated result.
<T, U> U	ResultQuery.fetchOne(Field<T> field, Converter<? super T,? extends U> converter)	Execute the query and return at most one resulting value for a field from the generated result.
@Nullable Object	ResultQuery.fetchOne(Name fieldName)	Execute the query and return at most one resulting value for a field name from the generated result.
<U> U	ResultQuery.fetchOne(Name fieldName, Class<? extends U> type)	Execute the query and return at most one resulting value for a field name from the generated result.
<U> U	ResultQuery.fetchOne(Name fieldName, Converter<?,? extends U> converter)	Execute the query and return at most one resulting value for a field name from the generated result.
<E> E	ResultQuery.fetchOne(RecordMapper<? super R,E> mapper)	Execute the query and return at most one resulting value into a custom mapper callback.
@Nullable Object @Nullable []	ResultQuery.fetchOneArray()	Execute the query and return at most one resulting record as an array
<E> E	ResultQuery.fetchOneInto(Class<? extends E> type)	Map resulting records onto a custom type.
<Z extends Record> Z	ResultQuery.fetchOneInto(Table<Z> table)	Map resulting records onto a custom record.
@Nullable Map<String,Object>	ResultQuery.fetchOneMap()	Execute the query and return at most one resulting record as a name/value map.
@NotNull Optional<Record>	DSLContext.fetchOptional(String sql)	Execute a new query holding plain SQL.
@NotNull Optional<Record>	DSLContext.fetchOptional(String sql, Object... bindings)	Execute a new query holding plain SQL.
@NotNull Optional<Record>	DSLContext.fetchOptional(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull Optional<Record>	DSLContext.fetchOptional(ResultSet rs)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
@NotNull Optional<Record>	DSLContext.fetchOptional(ResultSet rs, Class<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
@NotNull Optional<Record>	DSLContext.fetchOptional(ResultSet rs, DataType<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
@NotNull Optional<Record>	DSLContext.fetchOptional(ResultSet rs, Field<?>... fields)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
<R extends Record> @NotNull Optional<R>	DSLContext.fetchOptional(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return a record.
@NotNull Optional<Record>	DSLContext.fetchOptional(SQL sql)	Execute a new query holding plain SQL.
<R extends Record> @NotNull Optional<R>	DSLContext.fetchOptional(Table<R> table)	Execute and return zero or one record for
<R extends Record> @NotNull Optional<R>	DSLContext.fetchOptional(Table<R> table, Collection<? extends Condition> conditions)	Execute and return zero or one record for
<R extends Record> @NotNull Optional<R>	DSLContext.fetchOptional(Table<R> table, Condition condition)	Execute and return zero or one record for
<R extends Record> @NotNull Optional<R>	DSLContext.fetchOptional(Table<R> table, Condition... conditions)	Execute and return zero or one record for
@NotNull Optional<R>	ResultQuery.fetchOptional()	Execute the query and return at most one resulting record.
@NotNull Optional<?>	ResultQuery.fetchOptional(int fieldIndex)	Execute the query and return at most one resulting value for a field index from the generated result.
<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.
@NotNull Optional<Object[]>	ResultQuery.fetchOptionalArray()	Execute the query and return at most one resulting record as an array.
<E> @NotNull Optional<E>	ResultQuery.fetchOptionalInto(Class<? extends E> type)	Map resulting records onto a custom type.
<Z extends Record> @NotNull Optional<Z>	ResultQuery.fetchOptionalInto(Table<Z> table)	Map resulting records onto a custom record.
@NotNull Optional<Map<String,Object>>	ResultQuery.fetchOptionalMap()	Execute the query and return at most one resulting record as a name/value map.
@NotNull Optional<?>	DSLContext.fetchOptionalValue(String sql)	Execute a new query holding plain SQL.
@NotNull Optional<?>	DSLContext.fetchOptionalValue(String sql, Object... bindings)	Execute a new query holding plain SQL.
@NotNull Optional<?>	DSLContext.fetchOptionalValue(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull Optional<?>	DSLContext.fetchOptionalValue(ResultSet rs)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T> @NotNull Optional<T>	DSLContext.fetchOptionalValue(ResultSet rs, Class<T> type)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T> @NotNull Optional<T>	DSLContext.fetchOptionalValue(ResultSet rs, DataType<T> type)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T> @NotNull Optional<T>	DSLContext.fetchOptionalValue(ResultSet rs, Field<T> field)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T, R extends Record1<T>> @NotNull Optional<T>	DSLContext.fetchOptionalValue(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return a single value.
@NotNull Optional<?>	DSLContext.fetchOptionalValue(SQL sql)	Execute a new query holding plain SQL.
<T> @NotNull Optional<T>	DSLContext.fetchOptionalValue(TableField<?,T> field)	Execute a ResultQuery in the context of this DSLContext and return a single value.
@NotNull Record	DSLContext.fetchSingle(String sql)	Execute a new query holding plain SQL.
@NotNull Record	DSLContext.fetchSingle(String sql, Object... bindings)	Execute a new query holding plain SQL.
@NotNull Record	DSLContext.fetchSingle(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull Record	DSLContext.fetchSingle(ResultSet rs)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
@NotNull Record	DSLContext.fetchSingle(ResultSet rs, Class<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
@NotNull Record	DSLContext.fetchSingle(ResultSet rs, DataType<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
@NotNull Record	DSLContext.fetchSingle(ResultSet rs, Field<?>... fields)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
<R extends Record> R	DSLContext.fetchSingle(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return a record.
@NotNull Record	DSLContext.fetchSingle(SQL sql)	Execute a new query holding plain SQL.
<R extends Record> R	DSLContext.fetchSingle(Table<R> table)	Execute and return exactly one record for
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Collection<? extends Condition> conditions)	Execute and return exactly one record for
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition condition)	Execute and return exactly one record for
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition... conditions)	Execute and return exactly one record for
R	ResultQuery.fetchSingle()	Execute the query and return exactly one resulting record.
@Nullable Object	ResultQuery.fetchSingle(int fieldIndex)	Execute the query and return exactly one resulting value for a field index from the generated result.
<U> 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> Z	ResultQuery.fetchSingleInto(Table<Z> table)	Map resulting records onto a custom record.
@NotNull Map<String,Object>	ResultQuery.fetchSingleMap()	Execute the query and return exactly one resulting record as a name/value map.
@Nullable Object	DSLContext.fetchValue(String sql)	Execute a new query holding plain SQL.
@Nullable Object	DSLContext.fetchValue(String sql, Object... bindings)	Execute a new query holding plain SQL.
@Nullable Object	DSLContext.fetchValue(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@Nullable Object	DSLContext.fetchValue(ResultSet rs)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T> T	DSLContext.fetchValue(ResultSet rs, Class<T> type)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T> T	DSLContext.fetchValue(ResultSet rs, DataType<T> type)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T> T	DSLContext.fetchValue(ResultSet rs, Field<T> field)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T, R extends Record1<T>> T	DSLContext.fetchValue(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return a single value.
@Nullable Object	DSLContext.fetchValue(SQL sql)	Execute a new query holding plain SQL.
<T> T	DSLContext.fetchValue(Table<? extends Record1<T>> table)	Fetch a single value from a single column table.
<T> T	DSLContext.fetchValue(TableField<?,T> field)	Execute a ResultQuery in the context of this DSLContext and return a single value.