Module org.jooq

Package org.jooq

Interface CloseableResultQuery<R extends Record>

All Superinterfaces:

Attachable, AttachableQueryPart, AutoCloseable, CloseableQuery, Fields, Flow.Publisher<R>, Iterable<R>, Publisher<R>, org.reactivestreams.Publisher<R>, Query, QueryPart, ResultQuery<R>, Serializable, Statement

public interface CloseableResultQuery<R extends Record>
extends ResultQuery<R>, CloseableQuery

A 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 Type	Method	Description
@NotNull CloseableResultQuery<R>	bind(int index, Object value)	Bind a new value to an indexed parameter.
@NotNull CloseableResultQuery<R>	bind(String param, Object value)	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(Field<?>... fields)	Coerce the result record type of this query to that of a set of fields.
<T1> @NotNull CloseableResultQuery<Record1<T1>>	coerce(Field<T1> field1)	Coerce the result record type of this query to that of a set of fields.
<T1, T2> @NotNull CloseableResultQuery<Record2<T1,T2>>	coerce(Field<T1> field1, Field<T2> field2)	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(Field<T1> field1, Field<T2> field2, Field<T3> field3)	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(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)	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(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)	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(Table<X> table)	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 underlying Statement.
@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>	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.0
@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.0
@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.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 underlying Statement.
@NotNull CloseableResultQuery<R>	poolable(boolean poolable)	Specify whether any JDBC Statement created by this query should be Statement.setPoolable(boolean).
@NotNull CloseableResultQuery<R>	queryTimeout(int timeout)	Specify the query timeout in number of seconds for the underlying JDBC Statement.
@NotNull CloseableResultQuery<R>	resultSetConcurrency(int resultSetConcurrency)	Specify the ResultSet concurrency of ResultSet objects created by jOOQ.
@NotNull CloseableResultQuery<R>	resultSetHoldability(int resultSetHoldability)	Specify the ResultSet holdability of ResultSet objects created by jOOQ.
@NotNull CloseableResultQuery<R>	resultSetType(int resultSetType)	Specify the ResultSet type of ResultSet 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.jooq.Publisher

subscribe

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 with StatementType.STATIC_STATEMENT and there is an underlying PreparedStatement kept open because of Query.keepStatement(boolean), the underlying PreparedStatement will be closed automatically in order for new bind values to have an effect.

Specified by:

bind in interface CloseableQuery

Specified by:

bind in interface Query

Specified by:

bind in interface ResultQuery<R extends Record>

Parameters:

param - The named parameter name. If this is a number, then this is the same as calling Query.bind(int, Object)

value - The new bind value.

Throws:

IllegalArgumentException - if there is no parameter by the given parameter name or index.

DataTypeException - if value 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 a DSL.log(Field, Field) call, where the first argument is the value and the second argument is the base, 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 as DSL.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 with StatementType.STATIC_STATEMENT and there is an underlying PreparedStatement kept open because of Query.keepStatement(boolean), the underlying PreparedStatement will be closed automatically in order for new bind values to have an effect.

Specified by:

bind in interface CloseableQuery

Specified by:

bind in interface Query

Specified by:

bind in interface ResultQuery<R extends Record>

Parameters:

index - The parameter index in rendering order, starting with 1

value - The new bind value.

Throws:

IllegalArgumentException - if there is no parameter by the given parameter index.

DataTypeException - if value cannot be converted into the parameter's data type

poolable

@NotNull
@NotNull CloseableResultQuery<R> poolable(boolean poolable)

Description copied from interface: Query

Specify whether any JDBC Statement created by this query should be Statement.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 interface CloseableQuery

Specified by:

poolable in interface Query

Specified by:

poolable in interface ResultQuery<R extends Record>

See Also:

• Statement.setPoolable(boolean)

queryTimeout

@NotNull
@NotNull CloseableResultQuery<R> queryTimeout(int timeout)

Description copied from interface: Query

Specify the query timeout in number of seconds for the underlying JDBC Statement.

Specified by:

queryTimeout in interface CloseableQuery

Specified by:

queryTimeout in interface Query

Specified by:

queryTimeout in interface ResultQuery<R extends Record>

See Also:

• Statement.setQueryTimeout(int)

keepStatement

@NotNull
@NotNull CloseableResultQuery<R> keepStatement(boolean 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 or PreparedStatement should be kept open after execution. If it is kept open, client code is responsible for properly closing it using CloseableQuery.close(), e.g. via a try-with-resources statement.

Specified by:

keepStatement in interface CloseableQuery

Specified by:

keepStatement in interface Query

Specified by:

keepStatement in interface ResultQuery<R extends Record>

Parameters:

keepStatement - Whether to keep the underlying statement open

maxRows

@NotNull
@NotNull CloseableResultQuery<R> maxRows(int rows)

Description copied from interface: ResultQuery

Specify the maximum number of rows returned by the underlying Statement.

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 interface ResultQuery<R extends Record>

See Also:

• Statement.setMaxRows(int)

fetchSize

@NotNull
@NotNull CloseableResultQuery<R> fetchSize(int rows)

Description copied from interface: ResultQuery

Specify the fetch size of the underlying Statement.

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 with ResultSet.TYPE_FORWARD_ONLY (set in ResultQuery.resultSetType(int)) and ResultSet.CONCUR_READ_ONLY (set in ResultQuery.resultSetConcurrency(int)). See this page here for details.
• PostgreSQL does not like fetch sizes being combined with Connection.getAutoCommit() == true. For more information, see this page here

Specified by:

fetchSize in interface ResultQuery<R extends Record>

See Also:

• Statement.setFetchSize(int)

resultSetConcurrency

@NotNull
@NotNull CloseableResultQuery<R> resultSetConcurrency(int resultSetConcurrency)

Description copied from interface: ResultQuery

Specify the ResultSet concurrency of ResultSet objects created by jOOQ.

This will affect the way you may perceive ResultSet objects obtained from any of these methods:

• ResultQuery.fetchResultSet()
• Cursor.resultSet()
• ExecuteContext.resultSet()

Specified by:

resultSetConcurrency in interface ResultQuery<R extends Record>

See Also:

• Statement.getResultSetConcurrency()

resultSetType

@NotNull
@NotNull CloseableResultQuery<R> resultSetType(int resultSetType)

Description copied from interface: ResultQuery

Specify the ResultSet type of ResultSet objects created by jOOQ.

This will affect the way you may perceive ResultSet objects obtained from any of these methods:

• ResultQuery.fetchResultSet()
• Cursor.resultSet()
• ExecuteContext.resultSet()

Specified by:

resultSetType in interface ResultQuery<R extends Record>

See Also:

• Statement.getResultSetType()

resultSetHoldability

@NotNull
@NotNull CloseableResultQuery<R> resultSetHoldability(int resultSetHoldability)

Description copied from interface: ResultQuery

Specify the ResultSet holdability of ResultSet objects created by jOOQ.

This will affect the way you may perceive ResultSet objects obtained from any of these methods:

• ResultQuery.fetchResultSet()
• Cursor.resultSet()
• ExecuteContext.resultSet()

Specified by:

resultSetHoldability in interface ResultQuery<R extends Record>

See Also:

• Statement.getResultSetHoldability()

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.0

Description copied from interface: ResultQuery

Specify a set of fields whose values should be interned.

Unlike Result's intern() methods, this already interns values right after fetching them from a JDBC result set. See Result.intern(int...) for more details.

Specified by:

intern in interface ResultQuery<R extends Record>

Parameters:

fields - The fields whose values should be interned

Returns:

The same result query

See Also:

• Result.intern(Field...)
• String.intern()

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.0

Description copied from interface: ResultQuery

Specify a set of field indexes whose values should be interned.

Unlike Result's intern() methods, this already interns values right after fetching them from a JDBC result set. See Result.intern(int...) for more details.

Specified by:

intern in interface ResultQuery<R extends Record>

Parameters:

fieldIndexes - The field indexes whose values should be interned

Returns:

The same result query

See Also:

• Result.intern(int...)
• String.intern()

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.0

Description copied from interface: ResultQuery

Specify a set of field names whose values should be interned.

Unlike Result's intern() methods, this already interns values right after fetching them from a JDBC result set. See Result.intern(String...) for more details.

Specified by:

intern in interface ResultQuery<R extends Record>

Parameters:

fieldNames - The field names whose values should be interned

Returns:

The same result query

See Also:

• Result.intern(String...)
• String.intern()

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.0

Description copied from interface: ResultQuery

Specify a set of field names whose values should be interned.

Unlike Result's intern() methods, this already interns values right after fetching them from a JDBC result set. See Result.intern(Name...) for more details.

Specified by:

intern in interface ResultQuery<R extends Record>

Parameters:

fieldNames - The field names whose values should be interned

Returns:

The same result query

See Also:

• Result.intern(Name...)
• String.intern()

coerce

@NotNull
<X extends Record> @NotNull CloseableResultQuery<X> coerce(Table<X> table)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a table.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
@NotNull CloseableResultQuery<Record> coerce(Field<?>... fields)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
@NotNull CloseableResultQuery<Record> coerce(Collection<? extends Field<?>> fields)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<T1> @NotNull CloseableResultQuery<Record1<T1>> coerce(Field<T1> field1)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<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 interface ResultQuery<R extends Record>

coerce

@NotNull
<T1,
T2,
T3>
@NotNull CloseableResultQuery<Record3<T1,T2,T3>> coerce(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 interface ResultQuery<R extends Record>

coerce

@NotNull
<T1,
T2,
T3,
T4>
@NotNull CloseableResultQuery<Record4<T1,T2,T3,T4>> coerce(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 interface ResultQuery<R extends Record>

coerce

@NotNull
<T1,
T2,
T3,
T4,
T5>
@NotNull CloseableResultQuery<Record5<T1,T2,T3,T4,T5>> coerce(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 interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>

coerce

@NotNull
<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)

Description copied from interface: ResultQuery

Coerce the result record type of this query to that of a set of fields.

Specified by:

coerce in interface ResultQuery<R extends Record>