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 and Description
<O extends TableRecord<O>> O	UpdatableRecord.fetchChild(ForeignKey<O,R> key) Fetch a child record of this record, given a foreign key.
R	UpdateResultStep.fetchOne() The record holding returned values as specified by the UpdateReturningStep.
R	ResultQuery.fetchOne() Execute the query and return at most one resulting record.
R	InsertResultStep.fetchOne() The record holding returned values as specified by the InsertReturningStep.
R	DeleteResultStep.fetchOne() The record holding returned values as specified by the DeleteReturningStep.
<T> T	ResultQuery.fetchOne(Field<?> field, java.lang.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.
java.lang.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, java.lang.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.
java.lang.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, java.lang.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 extends Record> R	DSLContext.fetchOne(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a record.
Record	DSLContext.fetchOne(java.sql.ResultSet rs) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchOne(java.sql.ResultSet rs, java.lang.Class<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchOne(java.sql.ResultSet rs, DataType<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchOne(java.sql.ResultSet rs, Field<?>... fields) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchOne(SQL sql) Execute a new query holding plain SQL.
java.lang.Object	ResultQuery.fetchOne(java.lang.String fieldName) Execute the query and return at most one resulting value for a field name from the generated result.
Record	DSLContext.fetchOne(java.lang.String sql) Execute a new query holding plain SQL.
<T> T	ResultQuery.fetchOne(java.lang.String fieldName, java.lang.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(java.lang.String fieldName, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field name from the generated result.
Record	DSLContext.fetchOne(java.lang.String sql, java.lang.Object... bindings) Execute a new query holding plain SQL.
Record	DSLContext.fetchOne(java.lang.String sql, QueryPart... parts) Execute a new query holding plain SQL.
<R extends Record> R	DSLContext.fetchOne(Table<R> table) Execute and return zero or one record for SELECT * FROM [table].
<R extends Record> R	DSLContext.fetchOne(Table<R> table, Condition condition) Execute and return zero or one record for SELECT * FROM [table] WHERE [condition] .
java.lang.Object[]	ResultQuery.fetchOneArray() Execute the query and return at most one resulting record as an array You can access data like this query.fetchOneArray()[fieldIndex]
<E> E	ResultQuery.fetchOneInto(java.lang.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.
java.util.Map<java.lang.String,java.lang.Object>	ResultQuery.fetchOneMap() Execute the query and return at most one resulting record as a name/value map.
java.util.Optional<R>	UpdateResultStep.fetchOptional() The record holding returned values as specified by the UpdateReturningStep.
java.util.Optional<R>	ResultQuery.fetchOptional() Execute the query and return at most one resulting record.
java.util.Optional<R>	InsertResultStep.fetchOptional() The record holding returned values as specified by the InsertReturningStep.
java.util.Optional<R>	DeleteResultStep.fetchOptional() The record holding returned values as specified by the DeleteReturningStep.
<T> java.util.Optional<T>	ResultQuery.fetchOptional(Field<?> field, java.lang.Class<? extends T> type) Execute the query and return at most one resulting value for a field from the generated result.
<T> java.util.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> java.util.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.
java.util.Optional<?>	ResultQuery.fetchOptional(int fieldIndex) Execute the query and return at most one resulting value for a field index from the generated result.
<T> java.util.Optional<T>	ResultQuery.fetchOptional(int fieldIndex, java.lang.Class<? extends T> type) Execute the query and return at most one resulting value for a field index from the generated result.
<U> java.util.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.
java.util.Optional<?>	ResultQuery.fetchOptional(Name fieldName) Execute the query and return at most one resulting value for a field name from the generated result.
<T> java.util.Optional<T>	ResultQuery.fetchOptional(Name fieldName, java.lang.Class<? extends T> type) Execute the query and return at most one resulting value for a field name from the generated result.
<U> java.util.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> java.util.Optional<E>	ResultQuery.fetchOptional(RecordMapper<? super R,E> mapper) Execute the query and return at most one resulting value into a custom mapper callback.
<R extends Record> java.util.Optional<R>	DSLContext.fetchOptional(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a record.
java.util.Optional<Record>	DSLContext.fetchOptional(java.sql.ResultSet rs) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
java.util.Optional<Record>	DSLContext.fetchOptional(java.sql.ResultSet rs, java.lang.Class<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
java.util.Optional<Record>	DSLContext.fetchOptional(java.sql.ResultSet rs, DataType<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
java.util.Optional<Record>	DSLContext.fetchOptional(java.sql.ResultSet rs, Field<?>... fields) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
java.util.Optional<Record>	DSLContext.fetchOptional(SQL sql) Execute a new query holding plain SQL.
java.util.Optional<?>	ResultQuery.fetchOptional(java.lang.String fieldName) Execute the query and return at most one resulting value for a field name from the generated result.
java.util.Optional<Record>	DSLContext.fetchOptional(java.lang.String sql) Execute a new query holding plain SQL.
<T> java.util.Optional<T>	ResultQuery.fetchOptional(java.lang.String fieldName, java.lang.Class<? extends T> type) Execute the query and return at most one resulting value for a field name from the generated result.
<U> java.util.Optional<U>	ResultQuery.fetchOptional(java.lang.String fieldName, Converter<?,? extends U> converter) Execute the query and return at most one resulting value for a field name from the generated result.
java.util.Optional<Record>	DSLContext.fetchOptional(java.lang.String sql, java.lang.Object... bindings) Execute a new query holding plain SQL.
java.util.Optional<Record>	DSLContext.fetchOptional(java.lang.String sql, QueryPart... parts) Execute a new query holding plain SQL.
<R extends Record> java.util.Optional<R>	DSLContext.fetchOptional(Table<R> table) Execute and return zero or one record for SELECT * FROM [table].
<R extends Record> java.util.Optional<R>	DSLContext.fetchOptional(Table<R> table, Condition condition) Execute and return zero or one record for SELECT * FROM [table] WHERE [condition] .
java.util.Optional<java.lang.Object[]>	ResultQuery.fetchOptionalArray() Execute the query and return at most one resulting record as an array.
<E> java.util.Optional<E>	ResultQuery.fetchOptionalInto(java.lang.Class<? extends E> type) Map resulting records onto a custom type.
<Z extends Record> java.util.Optional<Z>	ResultQuery.fetchOptionalInto(Table<Z> table) Map resulting records onto a custom record.
java.util.Optional<java.util.Map<java.lang.String,java.lang.Object>>	ResultQuery.fetchOptionalMap() Execute the query and return at most one resulting record as a name/value map.
<T,R extends Record1<T>> java.util.Optional<T>	DSLContext.fetchOptionalValue(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a single value.
java.util.Optional<?>	DSLContext.fetchOptionalValue(java.sql.ResultSet rs) Fetch a record from a JDBC ResultSet and return the only contained value.
<T> java.util.Optional<T>	DSLContext.fetchOptionalValue(java.sql.ResultSet rs, java.lang.Class<T> type) Fetch a record from a JDBC ResultSet and return the only contained value.
<T> java.util.Optional<T>	DSLContext.fetchOptionalValue(java.sql.ResultSet rs, DataType<T> type) Fetch a record from a JDBC ResultSet and return the only contained value.
<T> java.util.Optional<T>	DSLContext.fetchOptionalValue(java.sql.ResultSet rs, Field<T> field) Fetch a record from a JDBC ResultSet and return the only contained value.
java.util.Optional<?>	DSLContext.fetchOptionalValue(SQL sql) Execute a new query holding plain SQL.
java.util.Optional<?>	DSLContext.fetchOptionalValue(java.lang.String sql) Execute a new query holding plain SQL.
java.util.Optional<?>	DSLContext.fetchOptionalValue(java.lang.String sql, java.lang.Object... bindings) Execute a new query holding plain SQL.
java.util.Optional<?>	DSLContext.fetchOptionalValue(java.lang.String sql, QueryPart... parts) Execute a new query holding plain SQL.
<T> java.util.Optional<T>	DSLContext.fetchOptionalValue(TableField<?,T> field) Execute a ResultQuery in the context of this DSLContext and return a single value.
R	ResultQuery.fetchSingle() Execute the query and return exactly one resulting record.
<T> T	ResultQuery.fetchSingle(Field<?> field, java.lang.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.
java.lang.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, java.lang.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.
java.lang.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, java.lang.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.
<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(java.sql.ResultSet rs) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchSingle(java.sql.ResultSet rs, java.lang.Class<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchSingle(java.sql.ResultSet rs, DataType<?>... types) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchSingle(java.sql.ResultSet rs, Field<?>... fields) Fetch a record from a JDBC ResultSet and transform it to a jOOQ Record.
Record	DSLContext.fetchSingle(SQL sql) Execute a new query holding plain SQL.
java.lang.Object	ResultQuery.fetchSingle(java.lang.String fieldName) Execute the query and return exactly one resulting value for a field name from the generated result.
Record	DSLContext.fetchSingle(java.lang.String sql) Execute a new query holding plain SQL.
<T> T	ResultQuery.fetchSingle(java.lang.String fieldName, java.lang.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(java.lang.String fieldName, Converter<?,? extends U> converter) Execute the query and return exactly one resulting value for a field name from the generated result.
Record	DSLContext.fetchSingle(java.lang.String sql, java.lang.Object... bindings) Execute a new query holding plain SQL.
Record	DSLContext.fetchSingle(java.lang.String sql, QueryPart... parts) Execute a new query holding plain SQL.
<R extends Record> R	DSLContext.fetchSingle(Table<R> table) Execute and return exactly one record for SELECT * FROM [table].
<R extends Record> R	DSLContext.fetchSingle(Table<R> table, Condition condition) Execute and return exactly one record for SELECT * FROM [table] WHERE [condition] .
java.lang.Object[]	ResultQuery.fetchSingleArray() Execute the query and return exactly one resulting record as an array You can access data like this query.fetchSingleArray()[fieldIndex]
<E> E	ResultQuery.fetchSingleInto(java.lang.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.
java.util.Map<java.lang.String,java.lang.Object>	ResultQuery.fetchSingleMap() Execute the query and return exactly one resulting record as a name/value map.
<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.
java.lang.Object	DSLContext.fetchValue(java.sql.ResultSet rs) Fetch a record from a JDBC ResultSet and return the only contained value.
<T> T	DSLContext.fetchValue(java.sql.ResultSet rs, java.lang.Class<T> type) Fetch a record from a JDBC ResultSet and return the only contained value.
<T> T	DSLContext.fetchValue(java.sql.ResultSet rs, DataType<T> type) Fetch a record from a JDBC ResultSet and return the only contained value.
<T> T	DSLContext.fetchValue(java.sql.ResultSet rs, Field<T> field) Fetch a record from a JDBC ResultSet and return the only contained value.
java.lang.Object	DSLContext.fetchValue(SQL sql) Execute a new query holding plain SQL.
java.lang.Object	DSLContext.fetchValue(java.lang.String sql) Execute a new query holding plain SQL.
java.lang.Object	DSLContext.fetchValue(java.lang.String sql, java.lang.Object... bindings) Execute a new query holding plain SQL.
java.lang.Object	DSLContext.fetchValue(java.lang.String sql, QueryPart... parts) Execute a new query holding plain SQL.
<T> T	DSLContext.fetchValue(TableField<?,T> field) Execute a ResultQuery in the context of this DSLContext and return a single value.