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, using Fields.field(String) for lookup.
<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, using Fields.field(String) for lookup.
<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, using Fields.field(String) for lookup.
<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, using Fields.field(Field) for lookup.
<T> T	ResultQuery.fetchOne(Field<T> field)	Execute the query and return at most one resulting value for a field from the generated result, using Fields.field(Field) for lookup.
<T, U> U	ResultQuery.fetchOne(Field<T> field, Converter<? super T,? extends U> converter)	Execute the query and return at most one resulting value for a field from the generated result, using Fields.field(Field) for lookup.
@Nullable Object	ResultQuery.fetchOne(Name fieldName)	Execute the query and return at most one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.
<U> U	ResultQuery.fetchOne(Name fieldName, Class<? extends U> type)	Execute the query and return at most one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.
<U> U	ResultQuery.fetchOne(Name fieldName, Converter<?,? extends U> converter)	Execute the query and return at most one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.
<E> E	ResultQuery.fetchOne(RecordMapper<? super R,E> mapper)	Execute the query and return at most one resulting value into a custom mapper callback.
@Nullable Object @Nullable []	ResultQuery.fetchOneArray()	Execute the query and return at most one resulting record as an array
<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, using Fields.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, using Fields.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, using Fields.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, using Fields.field(Field) for lookup.
<T> @NotNull Optional<T>	ResultQuery.fetchOptional(Field<T> field)	Execute the query and return at most one resulting value for a field from the generated result, using Fields.field(Field) for lookup.
<T, U> @NotNull Optional<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, using Fields.field(Field) for lookup.
@NotNull Optional<?>	ResultQuery.fetchOptional(Name fieldName)	Execute the query and return at most one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.
<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, using Fields.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, using Fields.field(Name) for lookup.
<E> @NotNull Optional<E>	ResultQuery.fetchOptional(RecordMapper<? super R,E> mapper)	Execute the query and return at most one resulting value into a custom mapper callback.
@NotNull Optional<Object[]>	ResultQuery.fetchOptionalArray()	Execute the query and return at most one resulting record as an array.
<E> @NotNull Optional<E>	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.
<T> @NotNull Optional<T>	DSLContext.fetchOptionalValue(TableField<?,T> field, Condition condition)	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 extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition c1, Condition c2, Condition c3, Condition c4, Condition c5, Condition c6, Condition c7, Condition c8, Condition c9, Condition c10, Condition c11, Condition c12, Condition c13, Condition c14, Condition c15, Condition c16, Condition c17, Condition c18, Condition c19, Condition c20, Condition c21, Condition c22)	Disambiguation overload of DSLContext.fetchSingle(Table, Condition...).
R	ResultQuery.fetchSingle()	Execute the query and return exactly one resulting record.
@Nullable Object	ResultQuery.fetchSingle(int fieldIndex)	Execute the query and return exactly one resulting value for a field index from the generated result.
<U> 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, using Fields.field(String) for lookup.
<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, using Fields.field(String) for lookup.
<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, using Fields.field(String) for lookup.
<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, using Fields.field(Field) for lookup.
<T> T	ResultQuery.fetchSingle(Field<T> field)	Execute the query and return exactly one resulting value for a field from the generated result, using Fields.field(Field) for lookup.
<T, U> U	ResultQuery.fetchSingle(Field<T> field, Converter<? super T,? extends U> converter)	Execute the query and return exactly one resulting value for a field from the generated result, using Fields.field(Field) for lookup.
@Nullable Object	ResultQuery.fetchSingle(Name fieldName)	Execute the query and return exactly one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.
<U> U	ResultQuery.fetchSingle(Name fieldName, Class<? extends U> type)	Execute the query and return exactly one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.
<U> U	ResultQuery.fetchSingle(Name fieldName, Converter<?,? extends U> converter)	Execute the query and return exactly one resulting value for a field name from the generated result, using Fields.field(Name) for lookup.
<E> E	ResultQuery.fetchSingle(RecordMapper<? super R,E> mapper)	Execute the query and return exactly one resulting value into a custom mapper callback.
@Nullable Object @NotNull []	ResultQuery.fetchSingleArray()	Execute the query and return exactly one resulting record as an array
<E> E	ResultQuery.fetchSingleInto(Class<? extends E> type)	Map resulting records onto a custom type.
<Z extends Record> Z	ResultQuery.fetchSingleInto(Table<Z> table)	Map resulting records onto a custom record.
@NotNull Map<String,Object>	ResultQuery.fetchSingleMap()	Execute the query and return exactly one resulting record as a name/value map.
@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.
<T> T	DSLContext.fetchValue(TableField<?,T> field, Condition condition)	Execute a ResultQuery in the context of this DSLContext and return a single value.