Jorge Ferreira [http://community.jboss.org/people/imjorge] replied to the discussion
"Multiple JBPM4_VARIABLE records pointing to same LOB_ and different EXECUTIONID_" To view the discussion, visit: http://community.jboss.org/message/549077#549077 -------------------------------------------------------------- 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 | -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/549077#549077] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
