Details
-
Task
-
Resolution: Done
-
Major
-
None
-
None
-
None
-
False
-
False
-
CR1
-
+
-
Undefined
-
2021 Week 22-24 (from May 31), 2021 Week 25-27 (from Jun 21)
Description
create the command
org.jbpm.executor.commands.ExecuteSQLQueryCommand
which is reocurrent. It executes SQL native queries and stores the results in a comma separated format.
| Parameter | Type | Description |
|---|---|---|
| SingleRun | String | true or false if it should triggered once or more times |
| EmfName | String | name of the persistence unit to be used to run the query |
| businessKey | String | associate businesskey to the request info |
| SQL | Stirng | native sql query to be executed. Parameters must be preceded by the symbol ":" |
| ParametersList | String | comma separated list of the parameters to be used in the sql and provided in the command context. e.g ParametersList=paramKey,paramId will be two different in a SQL like : SELECT * FROM RequestInfo WHERE id = :paramId AND businessKey = :paramKey context will provided two different fields paramKey=key value paramId=id value |
| <param> | String | value of the param provided in the parametersList bound to the native SQL |
Attachments
Issue Links
- relates to
-
JBPM-9796 Adding unit test for ExecuteSQLQueryCommand job command
-
- Resolved
-