Uses of Class
org.jooq.exception.TooManyRowsException
Packages that use TooManyRowsException
-
Uses of TooManyRowsException in org.jooq
Methods in org.jooq that throw TooManyRowsExceptionModifier and TypeMethodDescription<O extends TableRecord<O>>
OUpdatableRecord.fetchChild(ForeignKey<O,R> key)Fetch a child record of this record, given a foreign key.@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.<U> UExecute the query and return at most one resulting value for a field name from the generated result.<U> UExecute the query and return at most one resulting value for a field name from the generated result.<U> UExecute the query and return at most one resulting value for a field from the generated result.<T> TExecute the query and return at most one resulting value for a field from the generated result.<T, U> UExecute the query and return at most one resulting value for a field from the generated result.@Nullable ObjectExecute the query and return at most one resulting value for a field name from the generated result.<U> UExecute the query and return at most one resulting value for a field name from the generated result.<U> UExecute the query and return at most one resulting value for a field name from the generated result.<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[]ResultQuery.fetchOneArray()Execute the query and return at most one resulting record as an array<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.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.<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.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.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.@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)<R extends Record>
RDSLContext.fetchSingle(ResultQuery<R> query)Execute aResultQueryin the context of thisDSLContextand return a record.@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 forResultQuery.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.<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.<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.<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.<T> TResultQuery.fetchSingle(Field<T> field)Execute the query and return exactly one resulting value for a field from the generated result.<T, U> UResultQuery.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 ObjectResultQuery.fetchSingle(Name fieldName)Execute the query and return exactly one resulting value for a field name from the generated result.<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.<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.<E> EResultQuery.fetchSingle(RecordMapper<? super R,E> mapper)Execute the query and return exactly one resulting value into a custom mapper callback.@NotNull Object[]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.@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.@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.