ExecutableStatement

```
public interface ExecutableStatement
```
Represents an executable SQL statement.
Executable statement is a statement that has all parameters provided and is ready to be executed.

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`java.util.concurrent.CompletionStage<java.lang.Void>`	`execute()` Executes this statement ignoring any resulting information.
`java.util.concurrent.CompletionStage<java.lang.Void>`	`execute(java.time.Duration timeout)` Executes this statement ignoring any resulting information.
`java.util.concurrent.CompletionStage<java.util.Optional<Row>>`	`executeForFirstRow()` Executes this statement and returns the first row returned by a database engine.
`java.util.concurrent.CompletionStage<java.util.Optional<Row>>`	`executeForFirstRow(java.time.Duration timeout)` Executes this statement and returns the first row returned by a database engine.
`java.util.concurrent.CompletionStage<java.lang.Long>`	`executeForRowsAffected()` Executes this statement returning a number of rows that were affected.
`java.util.concurrent.CompletionStage<java.lang.Long>`	`executeForRowsAffected(java.time.Duration timeout)` Executes this statement returning a number of rows that were affected.
`java.util.concurrent.CompletionStage<ResultSet>`	`executeForSet()` Executes this statement and returns a `ResultSet` instance.
`java.util.concurrent.CompletionStage<ResultSet>`	`executeForSet(java.time.Duration timeout)` Executes this statement and returns a `ResultSet` instance.
`<T> java.util.concurrent.CompletionStage<java.util.Optional<T>>`	`executeForValue(ThrowingFunction<Row,T> valExtractor)` Executes this statement and returns a single column value from the first row returned by a database engine.
`<T> java.util.concurrent.CompletionStage<java.util.Optional<T>>`	`executeForValue(ThrowingFunction<Row,T> valExtractor, java.time.Duration timeout)` Executes this statement and returns a single column value from the first row returned by a database engine.
`RowPublisher`	`stream()` Executes this statement and returns a `RowPublisher` instance that can be used to stream rows from the database leveraging Reactive Streams specification's `Publisher` with backpressure.
`RowPublisher`	`stream(java.time.Duration timeout)` Executes this statement and returns a `RowPublisher` instance that can be used to stream rows from the database leveraging Reactive Streams specification's `Publisher` with backpressure.

- Method Detail
  - stream
```
RowPublisher stream(java.time.Duration timeout)
```
    Executes this statement and returns a RowPublisher instance that can be used to stream rows from the database leveraging Reactive Streams specification's Publisher with backpressure.
    After the operation takes longer time than timeout, operation will be aborted. Note however, that it may not be feasible to abort the operation immediately.
    Returned publisher can signal following error types:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
  - stream
```
RowPublisher stream()
```
    Executes this statement and returns a RowPublisher instance that can be used to stream rows from the database leveraging Reactive Streams specification's Publisher with backpressure.
    Returned publisher can signal following error types:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
  - execute
```
java.util.concurrent.CompletionStage<java.lang.Void> execute(java.time.Duration timeout)
```
    Executes this statement ignoring any resulting information.
    After the operation takes longer time than timeout, operation will be aborted. Note however, that it may not be feasible to abort the operation immediately.
    Returned CompletionStage can fail with:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
  - execute
```
java.util.concurrent.CompletionStage<java.lang.Void> execute()
```
    Executes this statement ignoring any resulting information.
    Returned CompletionStage can fail with:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
  - executeForSet
```
java.util.concurrent.CompletionStage<ResultSet> executeForSet(java.time.Duration timeout)
```
    Executes this statement and returns a ResultSet instance.
    After execution all resulting rows will be pulled from a database and buffered in the resulting object. If expected result set is very big this may cause out of memory errors.
    After the operation takes longer time than timeout, operation will be aborted. Note however, that it may not be feasible to abort the operation immediately.
    Returned CompletionStage can fail with:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
  - executeForSet
```
java.util.concurrent.CompletionStage<ResultSet> executeForSet()
```
    Executes this statement and returns a ResultSet instance.
    Returned CompletionStage can fail with:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
  - executeForRowsAffected
```
java.util.concurrent.CompletionStage<java.lang.Long> executeForRowsAffected(java.time.Duration timeout)
```
    Executes this statement returning a number of rows that were affected.
    After the operation takes longer time than timeout, operation will be aborted. Note however, that it may not be feasible to abort the operation immediately.
    Returned CompletionStage can fail with:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
  - executeForRowsAffected
```
java.util.concurrent.CompletionStage<java.lang.Long> executeForRowsAffected()
```
    Executes this statement returning a number of rows that were affected.
    Returned CompletionStage can fail with:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
  - executeForFirstRow
```
java.util.concurrent.CompletionStage<java.util.Optional<Row>> executeForFirstRow(java.time.Duration timeout)
```
    Executes this statement and returns the first row returned by a database engine.
    If no rows are found, an empty Optional will be returned.
    After the operation takes longer time than timeout, operation will be aborted. Note however, that it may not be feasible to abort the operation immediately.
    Returned CompletionStage can fail with:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
  - executeForFirstRow
```
java.util.concurrent.CompletionStage<java.util.Optional<Row>> executeForFirstRow()
```
    Executes this statement and returns the first row returned by a database engine.
    If no rows are found, an empty Optional will be returned.
    Returned CompletionStage can fail with:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
  - executeForValue
```
<T> java.util.concurrent.CompletionStage<java.util.Optional<T>> executeForValue(ThrowingFunction<Row,T> valExtractor,
                                                                                java.time.Duration timeout)
```
    Executes this statement and returns a single column value from the first row returned by a database engine.
    If no rows are found, an empty Optional will be returned.
    After the operation takes longer time than timeout, operation will be aborted. Note however, that it may not be feasible to abort the operation immediately.
    Returned CompletionStage can fail with:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
    Parameters:
    
    valExtractor - function used to extract value from the returned row
  - executeForValue
```
<T> java.util.concurrent.CompletionStage<java.util.Optional<T>> executeForValue(ThrowingFunction<Row,T> valExtractor)
```
    Executes this statement and returns a single column value from the first row returned by a database engine.
    If no rows are found, an empty Optional will be returned.
    Returned CompletionStage can fail with:
    - UnauthorizedException when client is not authorized to perform the action
    - InvalidQueryException when query is rejected by a database engine as invalid
    - InactiveTxException when transaction is in progress but is in inactive state
    - ConstraintViolationException when operation results in an integrity constraint violation
    Parameters:
    
    valExtractor - function used to extract value from the returned row

Interface ExecutableStatement

Method Summary

Method Detail

stream

stream

execute

execute

executeForSet

executeForSet

executeForRowsAffected

executeForRowsAffected

executeForFirstRow

executeForFirstRow

executeForValue

executeForValue