Uses of Class
org.jooq.exception.TooManyRowsException

Packages that use TooManyRowsException

Package	Description
org.jooq	The org.jooq 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.
R	DeleteResultStep.fetchOne()	The record holding returned values as specified by the DeleteReturningStep.
Record	DSLContext.fetchOne(String sql)	Execute a new query holding plain SQL.
Record	DSLContext.fetchOne(String sql, Object... bindings)	Execute a new query holding plain SQL.
Record	DSLContext.fetchOne(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
Record	DSLContext.fetchOne(ResultSet rs)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchOne(ResultSet rs, Class<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchOne(ResultSet rs, DataType<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
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.
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	InsertResultStep.fetchOne()	The record holding returned values as specified by the InsertReturningStep.
R	ResultQuery.fetchOne()	Execute the query and return at most one resulting record.
Object	ResultQuery.fetchOne(int fieldIndex)	Execute the query and return at most one resulting value for a field index from the generated result.
<T> T	ResultQuery.fetchOne(int fieldIndex, Class<? extends T> 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.
Object	ResultQuery.fetchOne(String fieldName)	Execute the query and return at most one resulting value for a field name from the generated result.
<T> T	ResultQuery.fetchOne(String fieldName, Class<? extends T> 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.
<T> T	ResultQuery.fetchOne(Field<?> field, Class<? extends T> 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.
Object	ResultQuery.fetchOne(Name fieldName)	Execute the query and return at most one resulting value for a field name from the generated result.
<T> T	ResultQuery.fetchOne(Name fieldName, Class<? extends T> 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.
R	UpdateResultStep.fetchOne()	The record holding returned values as specified by the UpdateReturningStep.
Object[]	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.
Map<String,Object>	ResultQuery.fetchOneMap()	Execute the query and return at most one resulting record as a name/value map.
Optional<R>	DeleteResultStep.fetchOptional()	The record holding returned values as specified by the DeleteReturningStep.
Optional<Record>	DSLContext.fetchOptional(String sql)	Execute a new query holding plain SQL.
Optional<Record>	DSLContext.fetchOptional(String sql, Object... bindings)	Execute a new query holding plain SQL.
Optional<Record>	DSLContext.fetchOptional(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
Optional<Record>	DSLContext.fetchOptional(ResultSet rs)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Optional<Record>	DSLContext.fetchOptional(ResultSet rs, Class<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Optional<Record>	DSLContext.fetchOptional(ResultSet rs, DataType<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
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> Optional<R>	DSLContext.fetchOptional(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return a record.
Optional<Record>	DSLContext.fetchOptional(SQL sql)	Execute a new query holding plain SQL.
<R extends Record> Optional<R>	DSLContext.fetchOptional(Table<R> table)	Execute and return zero or one record for
<R extends Record> Optional<R>	DSLContext.fetchOptional(Table<R> table, Collection<? extends Condition> conditions)	Execute and return zero or one record for
<R extends Record> Optional<R>	DSLContext.fetchOptional(Table<R> table, Condition condition)	Execute and return zero or one record for
<R extends Record> Optional<R>	DSLContext.fetchOptional(Table<R> table, Condition... conditions)	Execute and return zero or one record for
Optional<R>	InsertResultStep.fetchOptional()	The record holding returned values as specified by the InsertReturningStep.
Optional<R>	ResultQuery.fetchOptional()	Execute the query and return at most one resulting record.
Optional<?>	ResultQuery.fetchOptional(int fieldIndex)	Execute the query and return at most one resulting value for a field index from the generated result.
<T> Optional<T>	ResultQuery.fetchOptional(int fieldIndex, Class<? extends T> type)	Execute the query and return at most one resulting value for a field index from the generated result.
<U> 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.
Optional<?>	ResultQuery.fetchOptional(String fieldName)	Execute the query and return at most one resulting value for a field name from the generated result.
<T> Optional<T>	ResultQuery.fetchOptional(String fieldName, Class<? extends T> type)	Execute the query and return at most one resulting value for a field name from the generated result.
<U> 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.
<T> Optional<T>	ResultQuery.fetchOptional(Field<?> field, Class<? extends T> type)	Execute the query and return at most one resulting value for a field from the generated result.
<T> 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> 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.
Optional<?>	ResultQuery.fetchOptional(Name fieldName)	Execute the query and return at most one resulting value for a field name from the generated result.
<T> Optional<T>	ResultQuery.fetchOptional(Name fieldName, Class<? extends T> type)	Execute the query and return at most one resulting value for a field name from the generated result.
<U> 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> Optional<E>	ResultQuery.fetchOptional(RecordMapper<? super R,E> mapper)	Execute the query and return at most one resulting value into a custom mapper callback.
Optional<R>	UpdateResultStep.fetchOptional()	The record holding returned values as specified by the UpdateReturningStep.
Optional<Object[]>	ResultQuery.fetchOptionalArray()	Execute the query and return at most one resulting record as an array.
<E> Optional<E>	ResultQuery.fetchOptionalInto(Class<? extends E> type)	Map resulting records onto a custom type.
<Z extends Record> Optional<Z>	ResultQuery.fetchOptionalInto(Table<Z> table)	Map resulting records onto a custom record.
Optional<Map<String,Object>>	ResultQuery.fetchOptionalMap()	Execute the query and return at most one resulting record as a name/value map.
Optional<?>	DSLContext.fetchOptionalValue(String sql)	Execute a new query holding plain SQL.
Optional<?>	DSLContext.fetchOptionalValue(String sql, Object... bindings)	Execute a new query holding plain SQL.
Optional<?>	DSLContext.fetchOptionalValue(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
Optional<?>	DSLContext.fetchOptionalValue(ResultSet rs)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T> Optional<T>	DSLContext.fetchOptionalValue(ResultSet rs, Class<T> type)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T> Optional<T>	DSLContext.fetchOptionalValue(ResultSet rs, DataType<T> type)	Fetch a record from a JDBC ResultSet and return the only contained value.
<T> 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>> Optional<T>	DSLContext.fetchOptionalValue(ResultQuery<R> query)	Execute a ResultQuery in the context of this DSLContext and return a single value.
Optional<?>	DSLContext.fetchOptionalValue(SQL sql)	Execute a new query holding plain SQL.
<T> Optional<T>	DSLContext.fetchOptionalValue(TableField<?,T> field)	Execute a ResultQuery in the context of this DSLContext and return a single value.
Record	DSLContext.fetchSingle(String sql)	Execute a new query holding plain SQL.
Record	DSLContext.fetchSingle(String sql, Object... bindings)	Execute a new query holding plain SQL.
Record	DSLContext.fetchSingle(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
Record	DSLContext.fetchSingle(ResultSet rs)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchSingle(ResultSet rs, Class<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchSingle(ResultSet rs, DataType<?>... types)	Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
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.
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.
Object	ResultQuery.fetchSingle(int fieldIndex)	Execute the query and return exactly one resulting value for a field index from the generated result.
<T> T	ResultQuery.fetchSingle(int fieldIndex, Class<? extends T> 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.
Object	ResultQuery.fetchSingle(String fieldName)	Execute the query and return exactly one resulting value for a field name from the generated result.
<T> T	ResultQuery.fetchSingle(String fieldName, Class<? extends T> 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.
<T> T	ResultQuery.fetchSingle(Field<?> field, Class<? extends T> 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.
Object	ResultQuery.fetchSingle(Name fieldName)	Execute the query and return exactly one resulting value for a field name from the generated result.
<T> T	ResultQuery.fetchSingle(Name fieldName, Class<? extends T> 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.
Object[]	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.
Map<String,Object>	ResultQuery.fetchSingleMap()	Execute the query and return exactly one resulting record as a name/value map.
Object	DSLContext.fetchValue(String sql)	Execute a new query holding plain SQL.
Object	DSLContext.fetchValue(String sql, Object... bindings)	Execute a new query holding plain SQL.
Object	DSLContext.fetchValue(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
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.
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.