[jboss-user] [jBPM] - Multiple JBPM4_VARIABLE records pointing to same LOB_ and different EXECUTIONID_

[Jorge Ferreira]

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]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100622/e853bc10/attachment.html