<!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: JCRMessageStoreImpl store only message body?
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/burmanm">Michael Burman</a> in <i>JBoss ESB Development</i> - <a href="http://community.jboss.org/message/572381#572381">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I didn't find JCR to be correct way to handle this issue, so I personally created a new RDBMS based system, where we store the message's status and different payloads in several stages of the message. For tracking issues, we also modified the Actions and used filters to store auditlog from every entry point and exit point and everytime we change the message's properties.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>However, for the message store, the problem with relation database is storing all the attributes in reloadable format. I created and EAV-store to store all the attributes in few different formats (Long, String, Date ..) to the database as the message's properties. It's not perfect solution (it's difficult to store JPA Entitys this way unfortunately), but we do have a lot of information and track the messages.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Basic idea if this:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>message-table (store message uuid etc stuff here)</p><p> -> n * message_properties</p><p> -> Store all the payloads and attachments as documents</p><p>    -> all the documents have 0-n binaries associated to them</p><p>    -> attachments have 0-n properties stored for them</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>That's simplified example of the message store. It's one of the features which I'd really want to be more complex in the actual ESB distribution, since we also require a queryable datastore. Now we've built a webapp to list and search this message store.</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/572381#572381">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in JBoss ESB Development at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2032">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>