-
- All Superinterfaces:
Scope
public interface ExecuteContext extends Scope
A context object forQuery
execution passed to registeredExecuteListener
's.- Author:
- Lukas Eder
- See Also:
ExecuteListener
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description Query[]
batchQueries()
The jOOQQuery
objects that are being executed in batch mode, or empty if the query is unknown or if there was no jOOQQuery
.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 theConnection
that is being used for execution.RuntimeException
exception()
TheRuntimeException
being thrown.void
exception(RuntimeException e)
Override theRuntimeException
being thrown.Query
query()
The jOOQQuery
that is being executed ornull
if the query is unknown, if it is a batch query, or if there was no jOOQQuery
.Record
record()
The last record that was fetched from the result set, ornull
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, ornull
if no result has been fetched.void
result(Result<?> result)
Calling this has no effect.ResultSet
resultSet()
TheResultSet
that is being fetched ornull
if the result set is unknown or if no result set is being fetched.void
resultSet(ResultSet resultSet)
Override theResultSet
that is being fetched.Routine<?>
routine()
The jOOQRoutine
that is being executed ornull
if the query is unknown or if there was no jOOQRoutine
.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()
> 0void
serverOutput(String[] output)
Any server output collected from this statement when
.Settings.getFetchServerOutputSize()
> 0String
sql()
The SQL that is being executed ornull
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()
TheSQLException
that was thrown by the database.void
sqlException(SQLException e)
Override theSQLException
being thrown.SQLWarning
sqlWarning()
TheSQLWarning
that was emitted by the database.void
sqlWarning(SQLWarning e)
Override theSQLWarning
being emitted.PreparedStatement
statement()
ThePreparedStatement
that is being executed ornull
if the statement is unknown or if there was no statement.void
statement(PreparedStatement statement)
Override thePreparedStatement
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.
-
-
-
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
- It takes care of properly implementing
-
type
ExecuteType type()
The type of database interaction that is being executed.- See Also:
ExecuteType
-
query
Query query()
The jOOQQuery
that is being executed ornull
if the query is unknown, if it is a batch query, or if there was no jOOQQuery
.- See Also:
routine()
,batchQueries()
-
batchQueries
Query[] batchQueries()
The jOOQQuery
objects that are being executed in batch mode, or empty if the query is unknown or if there was no jOOQQuery
.If a single
Query
is executed in non-batch mode, this will return an array of length1
, containing thatQuery
-
routine
Routine<?> routine()
The jOOQRoutine
that is being executed ornull
if the query is unknown or if there was no jOOQRoutine
.- See Also:
routine()
-
sql
String sql()
The SQL that is being executed ornull
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.
-
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 length1
, containing thatQuery
-
connectionProvider
void connectionProvider(ConnectionProvider connectionProvider)
Override theConnection
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()
ThePreparedStatement
that is being executed ornull
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 jOOQQuery
is being executed asStatementType.PREPARED_STATEMENT
- A
java.sql.Statement
from your JDBC driver wrapped in ajava.sql.PreparedStatement
when your jOOQQuery
is being executed asStatementType.STATIC_STATEMENT
- A
java.sql.CallableStatement
when you are executing a jOOQRoutine
- A
-
statement
void statement(PreparedStatement statement)
Override thePreparedStatement
that is being executed.This may have no effect, if called at the wrong moment.
-
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).
-
resultSet
ResultSet resultSet()
TheResultSet
that is being fetched ornull
if the result set is unknown or if no result set is being fetched.
-
resultSet
void resultSet(ResultSet resultSet)
Override theResultSet
that is being fetched.This may have no effect, if called at the wrong moment.
-
record
Record record()
The last record that was fetched from the result set, ornull
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()
.
- if the number of affected rows is not yet available (e.g. prior to
the
-
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 length1
, containingrows()
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, ornull
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()
TheRuntimeException
being thrown.
-
exception
void exception(RuntimeException e)
Override theRuntimeException
being thrown.This may have no effect, if called at the wrong moment.
-
sqlException
SQLException sqlException()
TheSQLException
that was thrown by the database.
-
sqlException
void sqlException(SQLException e)
Override theSQLException
being thrown.Any
SQLException
will be wrapped by jOOQ using an uncheckedDataAccessException
. To have jOOQ throw your own customRuntimeException
, useexception(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 unspecifiedDataAccessException
.
-
sqlWarning
SQLWarning sqlWarning()
TheSQLWarning
that was emitted by the database.Note that fetching of warnings can be disabled using
Settings.isFetchWarnings()
, in case of which this property will benull
.
-
sqlWarning
void sqlWarning(SQLWarning e)
Override theSQLWarning
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
-
-