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> U Execute 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 @Nullable []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> 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 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.@Nullable Object @NotNull []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.