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 Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
@Nullable Record
@Nullable Record
@Nullable Record
<R extends Record>
RDSLContext.fetchOne(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a record.@Nullable Record
Execute 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 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
Execute the query and return at most one resulting value for a field index from the generated result.<U> U
Execute the query and return at most one resulting value for a field index from the generated result.@Nullable Object
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field from the generated result.<T> T
Execute 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 Object
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
Execute the query and return at most one resulting value for a field name from the generated result.<U> U
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.@Nullable 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>
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 aResultQuery
in the context of thisDSLContext
and 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 JDBCResultSet
and return the only contained value.<T> @NotNull Optional<T>
DSLContext.fetchOptionalValue(ResultSet rs, Class<T> type)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> @NotNull Optional<T>
DSLContext.fetchOptionalValue(ResultSet rs, DataType<T> type)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> @NotNull Optional<T>
DSLContext.fetchOptionalValue(ResultSet rs, Field<T> field)
Fetch a record from a JDBCResultSet
and return the only contained value.DSLContext.fetchOptionalValue(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
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 aResultQuery
in the context of thisDSLContext
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)
@NotNull Record
DSLContext.fetchSingle(ResultSet rs, Class<?>... types)
@NotNull Record
DSLContext.fetchSingle(ResultSet rs, DataType<?>... types)
@NotNull Record
DSLContext.fetchSingle(ResultSet rs, Field<?>... fields)
<R extends Record>
RDSLContext.fetchSingle(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a record.@NotNull Record
DSLContext.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 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.<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.<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.<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.<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.@Nullable Object
ResultQuery.fetchSingle(Name fieldName)
Execute the query and return exactly one resulting value for a field name from the generated result.<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.<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.@NotNull 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>
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 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 JDBCResultSet
and return the only contained value.<T> T
DSLContext.fetchValue(ResultSet rs, Class<T> type)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
DSLContext.fetchValue(ResultSet rs, DataType<T> type)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
DSLContext.fetchValue(ResultSet rs, Field<T> field)
Fetch a record from a JDBCResultSet
and return the only contained value.<T, R extends Record1<T>>
TDSLContext.fetchValue(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
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 aResultQuery
in the context of thisDSLContext
and return a single value.