- All Superinterfaces:
Attachable
,AttachableQueryPart
,AutoCloseable
,CloseableQuery
,Fields
,Flow.Publisher<R>
,Iterable<R>
,Publisher<R>
,org.reactivestreams.Publisher<R>
,Query
,QueryPart
,ResultQuery<R>
,Serializable
,Statement
ResultQuery
that holds a reference to the underlying
PreparedStatement
without closing it, for reuse.
It was created via ResultQuery.keepStatement(boolean)
and must be
treated as a resource, e.g. in a try-with-resources
statement.
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull CloseableResultQuery<R>
Bind a new value to an indexed parameter.@NotNull CloseableResultQuery<R>
Bind a new value to a named parameter.@NotNull CloseableResultQuery<Record>
coerce
(Collection<? extends Field<?>> fields) Coerce the result record type of this query to that of a set of fields.@NotNull CloseableResultQuery<Record>
Coerce the result record type of this query to that of a set of fields.<T1> @NotNull CloseableResultQuery<Record1<T1>>
Coerce the result record type of this query to that of a set of fields.<T1,
T2> @NotNull CloseableResultQuery<Record2<T1, T2>> Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3>
@NotNull CloseableResultQuery<Record3<T1,T2, T3>> Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4>
@NotNull CloseableResultQuery<Record4<T1,T2, T3, T4>> Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5>
@NotNull CloseableResultQuery<Record5<T1,T2, T3, T4, T5>> Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6>
@NotNull CloseableResultQuery<Record6<T1,T2, T3, T4, T5, T6>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7>
@NotNull CloseableResultQuery<Record7<T1,T2, T3, T4, T5, T6, T7>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull CloseableResultQuery<Record8<T1,T2, T3, T4, T5, T6, T7, T8>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull CloseableResultQuery<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull CloseableResultQuery<Record10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull CloseableResultQuery<Record11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull CloseableResultQuery<Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull CloseableResultQuery<Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull CloseableResultQuery<Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull CloseableResultQuery<Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull CloseableResultQuery<Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull CloseableResultQuery<Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull CloseableResultQuery<Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull CloseableResultQuery<Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull CloseableResultQuery<Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull CloseableResultQuery<Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull CloseableResultQuery<Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Coerce the result record type of this query to that of a set of fields.<X extends Record>
@NotNull CloseableResultQuery<X>Coerce the result record type of this query to that of a table.@NotNull CloseableResultQuery<R>
fetchSize
(int rows) Specify the fetch size of the underlyingStatement
.@NotNull CloseableResultQuery<R>
intern
(int... fieldIndexes) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0@NotNull CloseableResultQuery<R>
Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0@NotNull CloseableResultQuery<R>
Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0@NotNull CloseableResultQuery<R>
Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0@NotNull CloseableResultQuery<R>
keepStatement
(boolean keepStatement) Keep the query's underlying statement open after execution.@NotNull CloseableResultQuery<R>
maxRows
(int rows) Specify the maximum number of rows returned by the underlyingStatement
.@NotNull CloseableResultQuery<R>
poolable
(boolean poolable) Specify whether any JDBCStatement
created by this query should beStatement.setPoolable(boolean)
.@NotNull CloseableResultQuery<R>
queryTimeout
(int timeout) Specify the query timeout in number of seconds for the underlying JDBCStatement
.@NotNull CloseableResultQuery<R>
resultSetConcurrency
(int resultSetConcurrency) Specify theResultSet
concurrency ofResultSet
objects created by jOOQ.@NotNull CloseableResultQuery<R>
resultSetHoldability
(int resultSetHoldability) Specify theResultSet
holdability ofResultSet
objects created by jOOQ.@NotNull CloseableResultQuery<R>
resultSetType
(int resultSetType) Specify theResultSet
type ofResultSet
objects created by jOOQ.Methods inherited from interface org.jooq.Attachable
attach, configuration, detach
Methods inherited from interface org.jooq.AttachableQueryPart
getBindValues, getParam, getParams, getSQL, getSQL
Methods inherited from interface org.jooq.CloseableQuery
close
Methods inherited from interface org.jooq.Fields
dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, types
Methods inherited from interface org.reactivestreams.Publisher
subscribe
Methods inherited from interface org.jooq.Query
cancel, execute, executeAsync, executeAsync, isExecutable
Methods inherited from interface org.jooq.QueryPart
$replace, $replace, $traverse, $traverse, equals, hashCode, toString
Methods inherited from interface org.jooq.ResultQuery
collect, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAnyArray, fetchAnyInto, fetchAnyInto, fetchAnyMap, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArrays, fetchAsync, fetchAsync, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchInto, fetchInto, fetchInto, fetchLazy, fetchMany, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMaps, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOneArray, fetchOneInto, fetchOneInto, fetchOneMap, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptionalArray, fetchOptionalInto, fetchOptionalInto, fetchOptionalMap, fetchResultSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingleArray, fetchSingleInto, fetchSingleInto, fetchSingleMap, fetchStream, fetchStreamInto, fetchStreamInto, forEach, getRecordType, getResult, iterator, spliterator, stream
-
Method Details
-
bind
@NotNull @NotNull CloseableResultQuery<R> bind(String param, Object value) throws IllegalArgumentException, DataTypeException Description copied from interface:Query
Bind a new value to a named parameter.[#1886] If the bind value with name
param
is inlined (Param.isInline()
) or if this query was created withStatementType.STATIC_STATEMENT
and there is an underlyingPreparedStatement
kept open because ofQuery.keepStatement(boolean)
, the underlyingPreparedStatement
will be closed automatically in order for new bind values to have an effect.- Specified by:
bind
in interfaceCloseableQuery
- Specified by:
bind
in interfaceQuery
- Specified by:
bind
in interfaceResultQuery<R extends Record>
- Parameters:
param
- The named parameter name. If this is a number, then this is the same as callingQuery.bind(int, Object)
value
- The new bind value.- Throws:
IllegalArgumentException
- if there is no parameter by the given parameter name or index.DataTypeException
- ifvalue
cannot be converted into the parameter's data type
-
bind
@NotNull @NotNull CloseableResultQuery<R> bind(int index, Object value) throws IllegalArgumentException, DataTypeException Description copied from interface:Query
Bind a new value to an indexed parameter.Bind index order
The 1-based parameter index describes a parameter in rendering order, not in input order. For example, if a query contains aDSL.log(Field, Field)
call, where the first argument is thevalue
and the second argument is thebase
, this may produce different dialect specific renderings:- Db2:
ln(value) / ln(base)
- Oracle:
log(base, value)
- SQL Server:
log(value, base)
Some bind values may even be repeated by a dialect specific emulation, leading to duplication and index-shifting.
As such, it is usually better to supply bind values directly with the input of an expression, e.g.:
- Directly with the
DSL
method, such asDSL.log(Field, Field)
, for example. - With the plain SQL template constructor, e.g.
DSL.field(String, Object...)
- With the parser method, e.g.
Parser.parseField(String, Object...)
Inlined values
[#1886] If the bind value at
index
is inlined (Param.isInline()
) or if this query was created withStatementType.STATIC_STATEMENT
and there is an underlyingPreparedStatement
kept open because ofQuery.keepStatement(boolean)
, the underlyingPreparedStatement
will be closed automatically in order for new bind values to have an effect.- Specified by:
bind
in interfaceCloseableQuery
- Specified by:
bind
in interfaceQuery
- Specified by:
bind
in interfaceResultQuery<R extends Record>
- Parameters:
index
- The parameter index in rendering order, starting with 1value
- The new bind value.- Throws:
IllegalArgumentException
- if there is no parameter by the given parameter index.DataTypeException
- ifvalue
cannot be converted into the parameter's data type
- Db2:
-
poolable
Description copied from interface:Query
Specify whether any JDBCStatement
created by this query should beStatement.setPoolable(boolean)
.If this method is not called on jOOQ types, then jOOQ will not specify the flag on JDBC either, resulting in JDBC's default behaviour.
- Specified by:
poolable
in interfaceCloseableQuery
- Specified by:
poolable
in interfaceQuery
- Specified by:
poolable
in interfaceResultQuery<R extends Record>
- See Also:
-
queryTimeout
Description copied from interface:Query
Specify the query timeout in number of seconds for the underlying JDBCStatement
.- Specified by:
queryTimeout
in interfaceCloseableQuery
- Specified by:
queryTimeout
in interfaceQuery
- Specified by:
queryTimeout
in interfaceResultQuery<R extends Record>
- See Also:
-
keepStatement
Description copied from interface:Query
Keep the query's underlying statement open after execution.This indicates to jOOQ that the query's underlying
Statement
orPreparedStatement
should be kept open after execution. If it is kept open, client code is responsible for properly closing it usingCloseableQuery.close()
, e.g. via atry-with-resources
statement.- Specified by:
keepStatement
in interfaceCloseableQuery
- Specified by:
keepStatement
in interfaceQuery
- Specified by:
keepStatement
in interfaceResultQuery<R extends Record>
- Parameters:
keepStatement
- Whether to keep the underlying statement open
-
maxRows
Description copied from interface:ResultQuery
Specify the maximum number of rows returned by the underlyingStatement
.This is not the same as setting a
LIMIT … OFFSET
clause onto the statement, where the result set is restricted within the database.- Specified by:
maxRows
in interfaceResultQuery<R extends Record>
- See Also:
-
fetchSize
Description copied from interface:ResultQuery
Specify the fetch size of the underlyingStatement
.Regardless of this setting,
ResultQuery.fetchLazy()
is the only way in jOOQ not to fetch all data in memory. However, you may influence how your JDBC driver interacts with your database through specifying a fetch size.Dialect-specific remarks:
- MySQL uses
Integer.MIN_VALUE
as an indicator to fetch resulting rows row-by-row in conjunction withResultSet.TYPE_FORWARD_ONLY
(set inResultQuery.resultSetType(int)
) andResultSet.CONCUR_READ_ONLY
(set inResultQuery.resultSetConcurrency(int)
). See this page here for details. - PostgreSQL does not like fetch sizes being combined with
. For more information, see this page hereConnection.getAutoCommit()
== true
- Specified by:
fetchSize
in interfaceResultQuery<R extends Record>
- See Also:
- MySQL uses
-
resultSetConcurrency
Description copied from interface:ResultQuery
Specify theResultSet
concurrency ofResultSet
objects created by jOOQ.This will affect the way you may perceive
ResultSet
objects obtained from any of these methods:- Specified by:
resultSetConcurrency
in interfaceResultQuery<R extends Record>
- See Also:
-
resultSetType
Description copied from interface:ResultQuery
Specify theResultSet
type ofResultSet
objects created by jOOQ.This will affect the way you may perceive
ResultSet
objects obtained from any of these methods:- Specified by:
resultSetType
in interfaceResultQuery<R extends Record>
- See Also:
-
resultSetHoldability
Description copied from interface:ResultQuery
Specify theResultSet
holdability ofResultSet
objects created by jOOQ.This will affect the way you may perceive
ResultSet
objects obtained from any of these methods:- Specified by:
resultSetHoldability
in interfaceResultQuery<R extends Record>
- See Also:
-
intern
@NotNull @Deprecated(forRemoval=true, since="3.10") @NotNull CloseableResultQuery<R> intern(Field<?>... fields) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0Description copied from interface:ResultQuery
Specify a set of fields whose values should be interned.Unlike
Result
'sintern()
methods, this already interns values right after fetching them from a JDBC result set. SeeResult.intern(int...)
for more details.- Specified by:
intern
in interfaceResultQuery<R extends Record>
- Parameters:
fields
- The fields whose values should be interned- Returns:
- The same result query
- See Also:
-
intern
@NotNull @Deprecated(forRemoval=true, since="3.10") @NotNull CloseableResultQuery<R> intern(int... fieldIndexes) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0Description copied from interface:ResultQuery
Specify a set of field indexes whose values should be interned.Unlike
Result
'sintern()
methods, this already interns values right after fetching them from a JDBC result set. SeeResult.intern(int...)
for more details.- Specified by:
intern
in interfaceResultQuery<R extends Record>
- Parameters:
fieldIndexes
- The field indexes whose values should be interned- Returns:
- The same result query
- See Also:
-
intern
@NotNull @Deprecated(forRemoval=true, since="3.10") @NotNull CloseableResultQuery<R> intern(String... fieldNames) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0Description copied from interface:ResultQuery
Specify a set of field names whose values should be interned.Unlike
Result
'sintern()
methods, this already interns values right after fetching them from a JDBC result set. SeeResult.intern(String...)
for more details.- Specified by:
intern
in interfaceResultQuery<R extends Record>
- Parameters:
fieldNames
- The field names whose values should be interned- Returns:
- The same result query
- See Also:
-
intern
@NotNull @Deprecated(forRemoval=true, since="3.10") @NotNull CloseableResultQuery<R> intern(Name... fieldNames) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0Description copied from interface:ResultQuery
Specify a set of field names whose values should be interned.Unlike
Result
'sintern()
methods, this already interns values right after fetching them from a JDBC result set. SeeResult.intern(Name...)
for more details.- Specified by:
intern
in interfaceResultQuery<R extends Record>
- Parameters:
fieldNames
- The field names whose values should be interned- Returns:
- The same result query
- See Also:
-
coerce
Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a table.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2> @NotNull CloseableResultQuery<Record2<T1,T2>> coerce(Field<T1> field1, Field<T2> field2) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record3<T1,T3> T2, coerceT3>> (Field<T1> field1, Field<T2> field2, Field<T3> field3) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record4<T1,T3, T4> T2, coerceT3, T4>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record5<T1,T3, T4, T5> T2, coerceT3, T4, T5>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record6<T1,T3, T4, T5, T6> T2, coerceT3, T4, T5, T6>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record7<T1,T3, T4, T5, T6, T7> T2, coerceT3, T4, T5, T6, T7>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record8<T1,T3, T4, T5, T6, T7, T8> T2, coerceT3, T4, T5, T6, T7, T8>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record9<T1,T3, T4, T5, T6, T7, T8, T9> T2, coerceT3, T4, T5, T6, T7, T8, T9>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record10<T1,T3, T4, T5, T6, T7, T8, T9, T10> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record11<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record12<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record13<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record14<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record15<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record16<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record17<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record18<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record19<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record20<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record21<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-
coerce
@NotNull <T1,T2, @NotNull CloseableResultQuery<Record22<T1,T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> T2, coerceT3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> (Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Description copied from interface:ResultQuery
Coerce the result record type of this query to that of a set of fields.- Specified by:
coerce
in interfaceResultQuery<R extends Record>
-