pack-priv abstract Class AbstractResultQuery<R extends org.jooq.Record>

Overrides org.jooq.impl.AbstractQuery.bind.

Implements org.jooq.CloseableResultQuery.bind, org.jooq.CloseableQuery.bind.

Doc from org.jooq.Query.bind.

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 keepStatement(boolean), the underlying PreparedStatement will be closed automatically in order for new bind values to have an effect.

Parameters

param:String

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

value:Object

The new bind value.

Annotations

@SuppressWarnings:unchecked

@Override

Overrides org.jooq.impl.AbstractQuery.bind.

Implements org.jooq.CloseableResultQuery.bind, org.jooq.CloseableQuery.bind.

Doc from org.jooq.Query.bind.

Bind a new value to an indexed parameter.

[#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 keepStatement(boolean), the underlying PreparedStatement will be closed automatically in order for new bind values to have an effect.

Parameters

index:int

The parameter index, starting with 1

value:Object

The new bind value.

Annotations

@SuppressWarnings:unchecked

@Override

Implements org.jooq.CloseableResultQuery.coerce.

Doc from org.jooq.ResultQuery.coerce.

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

Annotations

@SuppressWarnings:unchecked

@Override

Implements org.jooq.CloseableResultQuery.coerce.

Doc from org.jooq.ResultQuery.coerce.

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

Annotations

@SuppressWarnings:unchecked

@Override

Implements org.jooq.ResultQuery.fetch.

Doc from org.jooq.ResultQuery.fetch.

Execute the query and return the generated result.

The result and its contained records are attached to the original Configuration by default. Use Settings#isAttachRecords() to override this behaviour.

Lifecycle guarantees

In order to keep open ResultSets and fetch records lazily, use fetchLazy() instead and then operate on Cursor.

This method is not affected by Settings#getFetchIntermediateResult().

Returns:Result<R>

The result. This will never be null.

Annotations

@Override

Overrides default org.jooq.impl.ResultQueryTrait.fetchLazy.

Doc from org.jooq.ResultQuery.fetchLazy.

Execute the query and "lazily" return the generated result.

The returned Cursor holds a reference to the executed PreparedStatement and the associated ResultSet. Data can be fetched (or iterated over) lazily, fetching records from the ResultSet one by one.

Depending on your JDBC driver's default behaviour, this may load the whole database result into the driver's memory. In order to indicate to the driver that you may not want to fetch all records at once, use ResultQuery#fetchSize(int) or Settings#setFetchSize(Integer) prior to calling this method.

Client code is responsible for closing the cursor after use.

Returns:Cursor<R>

The resulting cursor. This will never be null.

Annotations

@Override

Overrides default org.jooq.impl.ResultQueryTrait.fetchLazyNonAutoClosing.

When we manage the lifecycle of a returned Cursor internally in jOOQ, then the cursor must not be auto-closed.

Annotations

@Override

Overrides default org.jooq.impl.ResultQueryTrait.fetchMany.

Doc from org.jooq.ResultQuery.fetchMany.

Execute a query, possibly returning several result sets.

Example (Sybase ASE):

String sql = "sp_help 'my_table'";

The result and its contained records are attached to the original Configuration by default. Use Settings#isAttachRecords() to override this behaviour.

Returns:Results

The resulting records. This will never be null.

Annotations

@Override

Implements org.jooq.CloseableResultQuery.fetchSize.

Doc from org.jooq.ResultQuery.fetchSize.

Specify the fetch size of the underlying Statement.

Regardless of this setting, 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 resultSetType(int)) and ResultSet#CONCUR_READ_ONLY (set in 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

Annotations

@Override

Implements org.jooq.ResultQuery.getRecordType.

Doc from org.jooq.ResultQuery.getRecordType.

The record type produced by this query.

Annotations

@SuppressWarnings:unchecked

@Override

Implements org.jooq.ResultQuery.getResult.

Doc from org.jooq.ResultQuery.getResult.

Return the result generated by a previous call to execute().

Returns:Result<R>

The result or null if no call to execute() was done previously.

Annotations

@Override

Implements org.jooq.CloseableResultQuery.intern.

Doc from org.jooq.ResultQuery.intern.

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.

Parameters

fields:Field<?>[]

The fields whose values should be interned

Returns:CloseableResultQuery<R>

The same result query

Annotations

@Override

Implements org.jooq.CloseableResultQuery.intern.

Doc from org.jooq.ResultQuery.intern.

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.

Parameters

fieldIndexes:int[]

The field indexes whose values should be interned

Returns:CloseableResultQuery<R>

The same result query

Annotations

@Override

Implements org.jooq.CloseableResultQuery.intern.

Doc from org.jooq.ResultQuery.intern.

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.

Parameters

fieldNameStrings:String[]

The field names whose values should be interned

Returns:CloseableResultQuery<R>

The same result query

Annotations

@Override

Implements org.jooq.CloseableResultQuery.intern.

Doc from org.jooq.ResultQuery.intern.

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.

Parameters

fieldNames:Name[]

The field names whose values should be interned

Returns:CloseableResultQuery<R>

The same result query

Annotations

@Override

Overrides org.jooq.impl.AbstractQuery.keepStatement.

Implements org.jooq.CloseableResultQuery.keepStatement, org.jooq.CloseableQuery.keepStatement.

Doc from org.jooq.Query.keepStatement.

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.

Parameters

k:boolean

Whether to keep the underlying statement open

Annotations

@SuppressWarnings:unchecked

@Override

Implements org.jooq.CloseableResultQuery.maxRows.

Doc from org.jooq.ResultQuery.maxRows.

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.

Annotations

@Override

Overrides org.jooq.impl.AbstractQuery.poolable.

Implements org.jooq.CloseableResultQuery.poolable, org.jooq.CloseableQuery.poolable.

Doc from org.jooq.Query.poolable.

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

Annotations

@SuppressWarnings:unchecked

@Override

Overrides org.jooq.impl.AbstractQuery.queryTimeout.

Implements org.jooq.CloseableResultQuery.queryTimeout, org.jooq.CloseableQuery.queryTimeout.

Doc from org.jooq.Query.queryTimeout.

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

Annotations

@SuppressWarnings:unchecked

@Override

Implements org.jooq.CloseableResultQuery.resultSetConcurrency.

Doc from org.jooq.ResultQuery.resultSetConcurrency.

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()

Annotations

@Override

Implements org.jooq.CloseableResultQuery.resultSetHoldability.

Doc from org.jooq.ResultQuery.resultSetHoldability.

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()

Annotations

@Override

Implements org.jooq.CloseableResultQuery.resultSetType.

Doc from org.jooq.ResultQuery.resultSetType.

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()

Annotations

@Override