The ONLY types of variables that are stored for any given process:
- org.w3c.dom.Document
- java.util.List<String>
- java.lang.Boolean
- TWO custom classes that implement java.io.Serializable
For setting a variable value we use several API, but all from publicly exposed jBPM interfaces:
- OpenExecution.setVariable(...);
- ActivityExecution.setVariable(...);
- ExecutionService.setVariable(...);
At the moment JBPM4_VARIABLE has several pairs (2) of records that point to the same LOB_.
select lob_
from jbpm4_variable
group by lob_
having count(1) > 1
order by lob_
select v.key_, v.execution_, v.lob_
from jbpm4_variable v
where v.lob_ in (
1970117,
1970123,
1970218,
2260229,
2260232)
order by v.lob_
| key_ | execution_ | lob_ |
|---|
| lastProcessTaskOutcome | 1940241 | 1970117 |
| executionWarnings | 1970116 | 1970117 |
| xmlObject | 1940241 | 1970123 |
| processIdentifier | 1970116 | 1970123 |
| xmlObject | 1970139 | 1970218 |
| executionErrors | 1970212 | 1970218 |
| executionErrors | 2260197 | 2260229 |
| executionErrors | 2260223 | 2260229 |
| executionWarnings | 2260197 | 2260232 |
| xmlObject | 2260223 | 2260232 |