Top Description Methods
org.jooq

public Interface CloseableResultQuery<R extends org.jooq.Record>

extends ResultQuery<R extends Record>, CloseableQuery
Known Direct Subinterfaces
org.jooq.impl.ResultQueryTrait
Imports
java.sql.PreparedStatement, java.util.Collection, org.jooq.exception.DataTypeException, org.jetbrains.annotations.NotNull
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 TypeMethod and Description
public @NotNull CloseableResultQuery<R>
bind(String
The named parameter name. If this is a number, then this is the same as calling bind(int, Object)
param, Object
The new bind value.
value)

Redeclares org.jooq.ResultQuery.bind, org.jooq.CloseableQuery.bind.

Bind a new value to a named parameter.
public @NotNull CloseableResultQuery<R>
bind(int
The parameter index, starting with 1
index, Object
The new bind value.
value)

Redeclares org.jooq.ResultQuery.bind, org.jooq.CloseableQuery.bind.

Bind a new value to an indexed parameter.
public <X extends Record> @NotNull CloseableResultQuery<X>
coerce(Table<X> table)

Redeclares org.jooq.ResultQuery.coerce.

Coerce the result record type of this query to that of a table.
public @NotNull CloseableResultQuery<Record>
coerce(Field<?>... fields)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public @NotNull CloseableResultQuery<Record>
coerce(Collection<? extends Field<?>> fields)

Redeclares org.jooq.ResultQuery.coerce.

Coerce the result record type of this query to that of a set of fields.
public <T1> @NotNull CloseableResultQuery<Record1<T1>>
coerce(Field<T1> field1)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <T1, T2> @NotNull CloseableResultQuery<Record2<T1, T2>>
coerce(Field<T1> field1, Field<T2> field2)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <T1, T2, T3> @NotNull CloseableResultQuery<Record3<T1, T2, T3>>
coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <T1, T2, T3, T4> @NotNull CloseableResultQuery<Record4<T1, T2, T3, T4>>
coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public <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)

Redeclares org.jooq.ResultQuery.coerce.

Deprecated as a consequence of Field being deprecated.
Coerce the result record type of this query to that of a set of fields.
public @NotNull CloseableResultQuery<R>
fetchSize(int rows)

Redeclares org.jooq.ResultQuery.fetchSize.

Specify the fetch size of the underlying Statement.
public @NotNull CloseableResultQuery<R>
intern(Field<?>...
The fields whose values should be interned
fields)

Redeclares org.jooq.ResultQuery.intern.

Deprecated for removal since 3.10. - 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0
Specify a set of fields whose values should be interned.
public @NotNull CloseableResultQuery<R>
intern(int...
The field indexes whose values should be interned
fieldIndexes)

Redeclares org.jooq.ResultQuery.intern.

Deprecated for removal since 3.10. - 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0
Specify a set of field indexes whose values should be interned.
public @NotNull CloseableResultQuery<R>
intern(String...
The field names whose values should be interned
fieldNames)

Redeclares org.jooq.ResultQuery.intern.

Deprecated for removal since 3.10. - 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0
Specify a set of field names whose values should be interned.
public @NotNull CloseableResultQuery<R>
intern(Name...
The field names whose values should be interned
fieldNames)

Redeclares org.jooq.ResultQuery.intern.

Deprecated for removal since 3.10. - 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0
Specify a set of field names whose values should be interned.
public @NotNull CloseableResultQuery<R>
keepStatement(boolean
Whether to keep the underlying statement open
keepStatement)

Redeclares org.jooq.ResultQuery.keepStatement, org.jooq.CloseableQuery.keepStatement.

Keep the query's underlying statement open after execution.
public @NotNull CloseableResultQuery<R>
maxRows(int rows)

Redeclares org.jooq.ResultQuery.maxRows.

Specify the maximum number of rows returned by the underlying Statement.
public @NotNull CloseableResultQuery<R>
poolable(boolean poolable)

Redeclares org.jooq.ResultQuery.poolable, org.jooq.CloseableQuery.poolable.

Specify whether any JDBC java.sql.Statement created by this query should be java.sql.Statement#setPoolable(boolean).
public @NotNull CloseableResultQuery<R>
queryTimeout(int timeout)

Redeclares org.jooq.ResultQuery.queryTimeout, org.jooq.CloseableQuery.queryTimeout.

Specify the query timeout in number of seconds for the underlying JDBC Statement.
public @NotNull CloseableResultQuery<R>
resultSetConcurrency(int resultSetConcurrency)

Redeclares org.jooq.ResultQuery.resultSetConcurrency.

Specify the ResultSet concurrency of ResultSet objects created by jOOQ.
public @NotNull CloseableResultQuery<R>
resultSetHoldability(int resultSetHoldability)

Redeclares org.jooq.ResultQuery.resultSetHoldability.

Specify the ResultSet holdability of ResultSet objects created by jOOQ.
public @NotNull CloseableResultQuery<R>
resultSetType(int resultSetType)

Redeclares org.jooq.ResultQuery.resultSetType.

Specify the ResultSet type of ResultSet objects created by jOOQ.
Inherited from org.jooq.CloseableQuery:
close
Inherited from org.jooq.ResultQuery:
collectfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyfetchAnyArrayfetchAnyIntofetchAnyIntofetchAnyMapfetchArrayfetchArrayfetchArrayfetchArrayfetchArrayfetchArrayfetchArrayfetchArrayfetchArrayfetchArrayfetchArrayfetchArrayfetchArrayfetchArraysfetchAsyncfetchAsyncfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchGroupsfetchIntofetchIntofetchIntofetchLazyfetchManyfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapfetchMapsfetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOneArrayfetchOneIntofetchOneIntofetchOneMapfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalArrayfetchOptionalIntofetchOptionalIntofetchOptionalMapfetchResultSetfetchSetfetchSetfetchSetfetchSetfetchSetfetchSetfetchSetfetchSetfetchSetfetchSetfetchSetfetchSetfetchSetfetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSingleArrayfetchSingleIntofetchSingleIntofetchSingleMapfetchStreamfetchStreamIntofetchStreamIntoforEachgetRecordTypegetResultiteratorspliteratorstream