ExecutableStatement

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 future 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

Executes this statement and returns the first row returned by a database engine.

If no rows are found, None 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 future 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

Executes this statement and returns a single generated key.

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 future 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
• NoKeysReturnedException when no keys were returned by the database engine
• NoSuitableConverterFoundException when no suitable converter was found to transform key value to desired class instance

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 future 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

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 future 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

Executes this statement and returns a ResultStream 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 future 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

Executes this statement and returns a single column value from the first row returned by a database engine.

If no rows are found, None will be returned.

If extracted value has SQL null value, a Some instance containing a null value will be returned.

This method is not intended to be used for returning values from columns that can have a SQL null value. Use executeForValueOpt for such columns.

Example:

for {
  val id = 10
  select <- conn.statement(sql"select name from users where id = $id")
  name <- select.executeForValue(_.str("name"))
} yield name

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 future 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

Executes this statement and returns a single column value from the first row returned by a database engine.

If no rows are found, None will be returned.

If row was found but extracted value has SQL null value, a Some instance will be returned containing a None.

Example:

val id = 10
for {
  select <- conn.select(sql"select name from users where id = $id")
  name <- parametrized.executeForValueOpt(_.str("name"))
} yield name

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 future 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