<!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;">
JDBCPersistenceManager will crash by design ?
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/timconinxrvp">Tim Coninx</a> in <i>JBoss Messaging</i> - <a href="http://community.jboss.org/message/574084#574084">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 posted in another discussion about having to remove messages by hand from our oracle db. But now we found the problem behind this necessity.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The context is that we sometimes have to 'DELETE FROM JBM_MSG_REF' when messages still exist in a queue, because when a server tries to start the queue, he fails with:</p><p>java.sql.SQLException: Invalid column index</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The reason behind this is as follows:</p><p>- in the persistence-service.xml (in our case the one for oracle), a SELECT query is defined as:</p><p>LOAD_UNPAGED_REFS=SELECT MESSAGE_ID, DELIVERY_COUNT, SCHED_DELIVERY FROM JBM_MSG_REF WHERE STATE = 'C' AND CHANNEL_ID = ? AND PAGE_ORD IS NULL ORDER BY ORD</p><p>- in the supported JDBCPersistenceManager in jboss-messaging (version 1_4_6_GA) the following code appears in the method loadFromStart(long, int)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><table cellpadding="0" cellspacing="0" style="width: 1913px; color: #000000; font-family: sans-serif; font-size: 12pt; margin: 0px; border: initial none initial;"><tbody><tr class="vc_row_odd" id="l982" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">982</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">ps = conn.prepareStatement(getSQLStatement("LOAD_UNPAGED_REFS"));</td></tr><tr class="vc_row_odd" id="l983" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">983</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px"><br/></td></tr><tr class="vc_row_odd" id="l984" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">984</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">ps.setFetchSize(number);</td></tr><tr class="vc_row_odd" id="l985" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">985</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px"><br/></td></tr><tr class="vc_row_odd" id="l986" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">986</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">ps.setLong(1, channelID);</td></tr><tr class="vc_row_odd" id="l987" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">987</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px"><br/></td></tr><tr class="vc_row_odd" id="l988" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">988</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">rs = ps.executeQuery();</td></tr><tr class="vc_row_odd" id="l989" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">989</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px"><br/></td></tr><tr class="vc_row_odd" id="l990" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">990</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">List<ReferenceInfo> refs = new ArrayList<ReferenceInfo>();</td></tr><tr class="vc_row_odd" id="l991" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">991</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px"><br/></td></tr><tr class="vc_row_odd" id="l992" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">992</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">List<ReferenceInfo> refsToUpdate = new ArrayList<ReferenceInfo>();</td></tr><tr class="vc_row_odd" id="l993" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">993</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px"><br/></td></tr><tr class="vc_row_odd" id="l994" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">994</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">int count = 0;</td></tr><tr class="vc_row_odd" id="l995" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">995</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">boolean inMemSwitch = false;</td></tr><tr class="vc_row_odd" id="l996" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">996</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">boolean nonPageFlag = true;</td></tr><tr class="vc_row_odd" id="l997" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">997</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">while (rs.next())</td></tr><tr class="vc_row_odd" id="l998" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">998</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">{</td></tr><tr class="vc_row_odd" id="l999" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">999</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">rs.getObject(4);</td></tr><tr class="vc_row_odd" id="l1000" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">1000</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">inMemSwitch = rs.wasNull();</td></tr><tr class="vc_row_odd" id="l1001" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">1001</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">if (nonPageFlag && (!inMemSwitch))</td></tr><tr class="vc_row_odd" id="l1002" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">1002</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">{</td></tr><tr class="vc_row_odd" id="l1003" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">1003</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">nonPageFlag = false;</td></tr><tr class="vc_row_odd" id="l1004" style="vertical-align: top; background-color: #f0f0f0;"><td class="vc_file_line_number" style="vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 1px; background-color: #eeeeee; color: #505050; text-align: right; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">1004</td><td class="vc_file_line_text" style="vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px;; border: initial none initial;vertical-align: top; border-right-width: 0px; background-color: white; font-family: monospace; text-align: left; white-space: pre; width: 1856px; border-right-style: solid; border-right-color: #505050; text-decoration: none; font-weight: normal; font-style: normal; padding-top: 1px; padding-right: 5px; padding-bottom: 1px; padding-left: 5px">}</td></tr></tbody></table></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I have no idea what the use of 'inMemSwitch' is (it will be ignored because nonPageFlag is always true), or how it is set. But the result of this is that when there are message entries in our queues from a previous run, the startup code for that queue WILL crash (4 > 3).</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>What am I supposed to do now ? I can't just upgrade because we're under support contract for this version.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Or am I missing something ?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks in advance for any helpful replies !</p><p>Tim</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/574084#574084">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>