← Back to plugin index

Sql Executor Task
Description
Task that executes an SQL statement on a relational database.
Type name
SqlExecutorTask
Class
com.airlock.iam.servicecontainer.app.application.configuration.task.SqlExecutorTask
May be used by
Task Schedule
Properties
Sql Data Source (sqlDataSource)
Description
Defines how connections to the database are obtained.
Attributes
Plugin-Link
Mandatory
Assignable plugins
JDBC Connection Pool
Sql Statement (sqlStatement)
Description
The SQL statement to be executed (without a semicolon at the end). The statement is executed within a transaction.
Attributes
String
Mandatory
Multi-line-text
Example
DELETE FROM medusa_user WHERE not_valid_after < now()
Example
UPDATE medusa_user SET locked = 1 WHERE not_valid_after < now()
Log Executed Statements (logExecutedStatements)
Description
Uncheck to suppress logging of executed statements.
Attributes
Boolean
Optional
Default value
true
Execution Time Threshold (executionTimeThreshold)
Description
Defines after how many milliseconds of SQL statement execution a warning should be logged.
Attributes
Long
Optional
YAML Template (with default values) 

type: SqlExecutorTask
id: SqlExecutorTask-xxxxxx
displayName: 
comment: 
properties:
  executionTimeThreshold:
  logExecutedStatements: true
  sqlDataSource:
  sqlStatement: