<!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: Clustering strategy for jBPM5
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/arkper">Arkady Perepelyuk</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/625402#625402">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>No. I have tried to do so, but it appears to be an issue when Hibernate tries to update SessionInfo shared by more than one node. It fails to commit the transaction if the entity has been updated by another node. The exception is as follows:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style=": ; color: #000080; font-size: 2;"><p align="left" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p></span><p align="left" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p></p><p align="left" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-size: 10pt;"><p align="left">Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?</p></span><span style="color: #ff0000; font-size: 10pt;"><p align="left">Sep 7, 2011 10:39:34 PM org.drools.persistence.jta.JtaTransactionManager commit</p><p align="left">WARNING: Unable to commit transaction</p></span><span style="text-decoration: underline;"><span style="text-decoration: underline;"><span style="color: #000080; font-size: 10pt; text-decoration: underline;"><span style=": ; color: #000080; font-size: 2; text-decoration: underline;"><p align="left">javax.persistence.OptimisticLockException</p></span></span><p align="left" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p></span></span><p align="left" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><span style="color: #ff0000; font-size: 10pt;">: </span><span style="text-decoration: underline;"><span style="color: #000080; font-size: 10pt; text-decoration: underline;"><span style="color: #000080; font-size: 10pt; text-decoration: underline;">org.hibernate.StaleObjectStateException</span></span></span><p align="left"><span style="color: #ff0000; font-size: 10pt;">: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.drools.persistence.info.SessionInfo#1</span></p><p align="left" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p></p><p align="left"><span style="color: #ff0000; font-size: 10pt;">Something like Terracotta should help to cluster Knowledge Session as it has a potential to instrument the byte code and introduce the necessary locking mechanism to make the shared objects "thread"-safe even for threads running in different JVMs.</span></p><p align="left" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p align="left"><span style="color: #ff0000; font-size: 10pt;">Has anybody tried and succeeded integrating jBPM5 with Terracotta?</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><div class="mcePaste" id="_mcePaste" style="position: absolute; top: 0px; left: 0px;"></div></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/625402#625402">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>