<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: jBPM Process Persistence Issue
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/vmdocua">Vadim Melnik</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/629703#629703">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hello Marco,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I belive mentioned problem is not related to DB at all and should exist on many DBs. We saw this on DB2 UDB 9.  Problem roots reside in JPBM5 persistence mechanism design, it should be reviewed and reworked, palliative solution to bypass this provided above. ORM works with entities like processinstanceinfo (XXXinfo), but there is no correlation between real process runtime info and serialized XXXinfo. Once XXXinfo is serialized by ORM,  it will not be serialized anymore even if related process was updated. In 90-99% cases nobody see this problem, as in JBPM5 demo, presentation and tutorial code transaction is simple and commit happens at the end, when all JBPM5 execution finished and all is good. In  real business application and large transaction it's possible that Hibernate sometime flushes data to DB  in the middle of JTA transaction. This intermediate snapshot will contain old/broken information about process instance. Later, at the JTA transaction commit time latest process instance information will not be serialized to DB anymore. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>--</p><p>Thanks,</p><p>Vadim.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/629703#629703">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>