Skip to main content

SQL statement

A Service task can used to perform a SQL statement, in order to execute a writing operation on a database table (insert, update, delete, ..).
Required properties are:

  • Id and Name: they identify the task and they are mandatory; be sure NOT to include accents in these fields (only alphanumeric characters are allowed).
  • Documentation: an optional description of this task
  • Class: it.sinesy.activiti.services.ExecuteSqlStmtServiceTask
  • Class fields: in this list of fields, a set of properties must be defined, in order to correctly define the SQL statement to execute:
  • name: property name to refer
  • string value: value to assign to that property
  • expression: optional expression to set, e.g. ${VARIABLE == ’Test’ ? YES : ’NO’}

A mandatory couple name-value is:

  • " sql " – the SQL statement to execute
  • " result " – optional variable used to store the number of processed records.

A typical SQL statement execution would contain the following couples name-value:

  • name = sql
  • string value = update users set expiration_date=null where username=:USER_ID

Important note
Do NOT use the notation ${VARNAME} in a SQL statement: you have to use the notation :VARNAME instead.

Additional properties:

  • name = dataSourceName
  • value = additional datasource id defined within 4WS.Platform and used to access to a different database schema, instead of the default repository schema used by 4WS.Platform and Activiti.