ExecuteContext (jOOQ 3.11.12 API)

All Superinterfaces:

Scope
```
public interface ExecuteContext
extends Scope
```
A context object for Query execution passed to registered ExecuteListener's.

Author:

Lukas Eder

See Also:

ExecuteListener

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`Query[]`	`batchQueries()` The jOOQ `Query` objects that are being executed in batch mode, or empty if the query is unknown or if there was no jOOQ `Query`.
`int[]`	`batchRows()` The number of rows that were affected by the last statement executed in batch mode.
`String[]`	`batchSQL()` The generated SQL statements that are being executed in batch mode, or empty if the query is unknown or if there was no SQL statement.
`Connection`	`connection()` The connection to be used in this execute context.
`void`	`connectionProvider(ConnectionProvider connectionProvider)` Override the `Connection` that is being used for execution.
`RuntimeException`	`exception()` The `RuntimeException` being thrown.
`void`	`exception(RuntimeException e)` Override the `RuntimeException` being thrown.
`Query`	`query()` The jOOQ `Query` that is being executed or `null` if the query is unknown, if it is a batch query, or if there was no jOOQ `Query`.
`Record`	`record()` The last record that was fetched from the result set, or `null` if no record has been fetched.
`void`	`record(Record record)` Calling this has no effect.
`Result<?>`	`result()` The last result that was fetched from the result set, or `null` if no result has been fetched.
`void`	`result(Result<?> result)` Calling this has no effect.
`ResultSet`	`resultSet()` The `ResultSet` that is being fetched or `null` if the result set is unknown or if no result set is being fetched.
`void`	`resultSet(ResultSet resultSet)` Override the `ResultSet` that is being fetched.
`Routine<?>`	`routine()` The jOOQ `Routine` that is being executed or `null` if the query is unknown or if there was no jOOQ `Routine`.
`int`	`rows()` The number of rows that were affected by the last statement.
`void`	`rows(int rows)` Calling this has no effect.
`String[]`	`serverOutput()` Any server output collected from this statement when `Settings.getFetchServerOutputSize() > 0`.
`void`	`serverOutput(String[] output)` Any server output collected from this statement when `Settings.getFetchServerOutputSize() > 0`.
`String`	`sql()` The SQL that is being executed or `null` if the SQL statement is unknown or if there was no SQL statement.
`void`	`sql(String sql)` Override the SQL statement that is being executed.
`SQLException`	`sqlException()` The `SQLException` that was thrown by the database.
`void`	`sqlException(SQLException e)` Override the `SQLException` being thrown.
`SQLWarning`	`sqlWarning()` The `SQLWarning` that was emitted by the database.
`void`	`sqlWarning(SQLWarning e)` Override the `SQLWarning` being emitted.
`PreparedStatement`	`statement()` The `PreparedStatement` that is being executed or `null` if the statement is unknown or if there was no statement.
`void`	`statement(PreparedStatement statement)` Override the `PreparedStatement` that is being executed.
`int`	`statementExecutionCount()` The number of times this particular statement has been executed.
`ExecuteType`	`type()` The type of database interaction that is being executed.

Methods inherited from interface org.jooq.Scope
configuration, data, data, data, dialect, dsl, family, settings

- Method Detail
  - connection
```
Connection connection()
```
    The connection to be used in this execute context.
    This returns a proxy to the Configuration.connectionProvider() 's supplied connection. This proxy takes care of two things:
    - It takes care of properly implementing Settings.getStatementType()
    - It takes care of properly returning a connection to ConnectionProvider.release(Connection), once jOOQ can release the connection
  - type
```
ExecuteType type()
```
    The type of database interaction that is being executed.
    
    See Also:
    
    ExecuteType
  - query
```
Query query()
```
    The jOOQ Query that is being executed or null if the query is unknown, if it is a batch query, or if there was no jOOQ Query.
    
    See Also:
    
    routine(), batchQueries()
  - batchQueries
```
Query[] batchQueries()
```
    The jOOQ Query objects that are being executed in batch mode, or empty if the query is unknown or if there was no jOOQ Query.
    If a single Query is executed in non-batch mode, this will return an array of length 1, containing that Query
    
    Returns:
    
    The executed Query object(s). This is never null
    
    See Also:
    
    query(), routine()
  - routine
```
Routine<?> routine()
```
    The jOOQ Routine that is being executed or null if the query is unknown or if there was no jOOQ Routine.
    
    See Also:
    
    routine()
  - sql
```
String sql()
```
    The SQL that is being executed or null if the SQL statement is unknown or if there was no SQL statement.
  - sql
```
void sql(String sql)
```
    Override the SQL statement that is being executed.
    This may have no effect, if called at the wrong moment.
    
    See Also:
    
    ExecuteListener.renderEnd(ExecuteContext), ExecuteListener.prepareStart(ExecuteContext)
  - batchSQL
```
String[] batchSQL()
```
    The generated SQL statements that are being executed in batch mode, or empty if the query is unknown or if there was no SQL statement.
    If a single Query is executed in non-batch mode, this will return an array of length 1, containing that Query
    
    Returns:
    
    The generated SQL statement(s). This is never null
    
    See Also:
    
    query(), routine()
  - connectionProvider
```
void connectionProvider(ConnectionProvider connectionProvider)
```
    Override the Connection that is being used for execution.
    This may have no effect, if called at the wrong moment.
    
    See Also:
    
    ExecuteListener.start(ExecuteContext)
  - statement
```
PreparedStatement statement()
```
    The PreparedStatement that is being executed or null if the statement is unknown or if there was no statement.
    This can be any of the following:
    - A java.sql.PreparedStatement from your JDBC driver when a jOOQ Query is being executed as StatementType.PREPARED_STATEMENT
    - A java.sql.Statement from your JDBC driver wrapped in a java.sql.PreparedStatement when your jOOQ Query is being executed as StatementType.STATIC_STATEMENT
    - A java.sql.CallableStatement when you are executing a jOOQ Routine
  - statement
```
void statement(PreparedStatement statement)
```
    Override the PreparedStatement that is being executed.
    This may have no effect, if called at the wrong moment.
    
    See Also:
    
    ExecuteListener.prepareEnd(ExecuteContext), ExecuteListener.bindStart(ExecuteContext)
  - statementExecutionCount
```
int statementExecutionCount()
```
    The number of times this particular statement has been executed.
    Statements that are prepared by jOOQ can be executed multiple times without being closed if Query.keepStatement(boolean) is activated.
    This value will increment as soon as the statement is about to be executed (at the ExecuteListener.executeStart(ExecuteContext) event).
    
    See Also:
    
    ExecuteListener.executeStart(ExecuteContext)
  - resultSet
```
ResultSet resultSet()
```
    The ResultSet that is being fetched or null if the result set is unknown or if no result set is being fetched.
  - resultSet
```
void resultSet(ResultSet resultSet)
```
    Override the ResultSet that is being fetched.
    This may have no effect, if called at the wrong moment.
    
    See Also:
    
    ExecuteListener.executeEnd(ExecuteContext), ExecuteListener.fetchStart(ExecuteContext)
  - record
```
Record record()
```
    The last record that was fetched from the result set, or null if no record has been fetched.
  - record
```
void record(Record record)
```
    Calling this has no effect. It is used by jOOQ internally.
  - rows
```
int rows()
```
    The number of rows that were affected by the last statement.
    This returns -1:
    - if the number of affected rows is not yet available (e.g. prior to the ExecuteListener.executeEnd(ExecuteContext) event).
    - if affected rows are not applicable for the given statement (statements that do not produce a JDBC Statement#getUpdateCount().
  - rows
```
void rows(int rows)
```
    Calling this has no effect. It is used by jOOQ internally.
  - batchRows
```
int[] batchRows()
```
    The number of rows that were affected by the last statement executed in batch mode.
    If a single Query is executed in non-batch mode, this will return an array of length 1, containing rows()
    This returns -1 values if the number of affected rows is not yet available, or if affected rows are not applicable for a given statement.
    
    Returns:
    
    The affected rows. This is never null
    
    See Also:
    
    rows()
  - result
```
Result<?> result()
```
    The last result that was fetched from the result set, or null if no result has been fetched.
  - result
```
void result(Result<?> result)
```
    Calling this has no effect. It is used by jOOQ internally.
  - exception
```
RuntimeException exception()
```
    The RuntimeException being thrown.
  - exception
```
void exception(RuntimeException e)
```
    Override the RuntimeException being thrown.
    This may have no effect, if called at the wrong moment.
  - sqlException
```
SQLException sqlException()
```
    The SQLException that was thrown by the database.
  - sqlException
```
void sqlException(SQLException e)
```
    Override the SQLException being thrown.
    Any SQLException will be wrapped by jOOQ using an unchecked DataAccessException. To have jOOQ throw your own custom RuntimeException, use exception(RuntimeException) instead. This may have no effect, if called at the wrong moment.
    If null is being passed, jOOQ will internally translate the "unavailable" exception to an unspecified DataAccessException.
  - sqlWarning
```
SQLWarning sqlWarning()
```
    The SQLWarning that was emitted by the database.
    Note that fetching of warnings can be disabled using Settings.isFetchWarnings(), in case of which this property will be null.
  - sqlWarning
```
void sqlWarning(SQLWarning e)
```
    Override the SQLWarning being emitted.
  - serverOutput
```
String[] serverOutput()
```
    Any server output collected from this statement when Settings.getFetchServerOutputSize() > 0.
    
    Returns:
    
    The server output. This is never null.
  - serverOutput
```
void serverOutput(String[] output)
```
    Any server output collected from this statement when Settings.getFetchServerOutputSize() > 0.

Interface ExecuteContext

Method Summary

Methods inherited from interface org.jooq.Scope

Method Detail

connection

type

query

batchQueries

routine

sql

sql

batchSQL

connectionProvider

statement

statement

statementExecutionCount

resultSet

resultSet

record

record

rows

rows

batchRows

result

result

exception

exception

sqlException

sqlException

sqlWarning

sqlWarning

serverOutput

serverOutput