Loading...

XML

Word

Printable

Blocked:
False
Ready:
False
CDW devel_ack:
CDW docs_ack:
CDW pm_ack:
CDW qa_ack:
CDW release:
Fix Build:
CR1
QE Test Coverage:
+
Release Note Text:
Undefined
Target Release:

7.11.1.GA
Git Pull Request:
https://github.com/kiegroup/jbpm/pull/1919, https://github.com/kiegroup/jbpm/pull/1962
Market:

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

relates to

JBPM-9796 Adding unit test for ExecuteSQLQueryCommand job command