<!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: message passing through underlying db
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/ryanhos">Ryan Hochstetler</a> in <i>JBoss Messaging</i> - <a href="http://community.jboss.org/message/594564#594564">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Tim,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>If you really have three JBoss Messaging instances pointed at the same exact database tables, I think this is considered an "out of spec" configuration.  Each independent, non-clustered JBoss Messaging instance requires sole access to the underlying database tables.  (Clustered JBM's understand that they share the tables with other nodes and are configured with a unique identifier that prevents them from seeing messages from other nodes).  If you are going to run three or four independent JBM instances, you might consider giving each JBM instance it's own login credentials and create all of the messaging tables under the default schema for each credential.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>You cannot pass messages with the DB, to my knowledge.  JBM doesn't appear to requery the DB.  It just assumes that since it is the only thing modifying those tables, the tables are consistent with its internal state, where it keeps all messages it is currently processing.  For the most part, it issues INSERTs and DELETEs, rarely SELECTs, except at boot to get the initial working set, or when you've exceeded a queue's FullSize.  DB message passing saves less work than you think if you mentally draw the sequence diagram for each scenario.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Why not just have Nodes 1 through 3 send messages directly to Node 4?  Instead of looking-up the ConnectionFactory on the local JBoss, look-up the ConnectionFactory on JBoss 4, and the rest of your code should function as expected.</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/594564#594564">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in JBoss Messaging at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2042">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>