Mailing-List: contact users-help@activemq.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@activemq.apache.org
Received-SPF: pass (nike.apache.org: domain of suonayi2006@163.com designates
 220.181.13.26 as permitted sender)
Date: Fri, 6 Jan 2012 12:50:47 +0800 (CST)
From: SuoNayi <suonayi2006@163.com>
To: Amq <users@activemq.apache.org>
Message-ID: <26fb70dc.1246e.134b15ad773.Coremail.suonayi2006@163.com>
Subject: No destinations are present on web console or jconsole when broker
 starts up
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_295941_557780835.1325825447795"

------=_Part_295941_557780835.1325825447795
Content-Type: text/plain; charset=GBK
Content-Transfer-Encoding: 7bit

Hi all,
     I have just noted that for AMQ 5.5 no desionations are present on web console or jconsole expect for an active producer or consumer are present at first.
The storage of broker is based on jdbc, oracle in fact, I find the sql sentence used to fetch all desionations from the db differs from the old one of AMQ 5.2.
Here is the statement of AMQ 5.5:
    public String getFindAllDestinationsStatement() {
        if (findAllDestinationsStatement == null) {
            findAllDestinationsStatement = "SELECT DISTINCT CONTAINER FROM " + getFullAckTableName();
        }
        return findAllDestinationsStatement;
    }
while for AMQ 5.2, it is the following:
public String getFindAllDestinationsStatement() {
  if (findAllDestinationsStatement == null) {
      findAllDestinationsStatement = "SELECT DISTINCT CONTAINER FROM " + getFullMessageTableName();
  }
  return findAllDestinationsStatement;
}
In my option, JDBCAdapter should fetch all informations of desionations  from the table named activemq_msgs, not activemq_acks.
Or there are some changes about this difference?
Thanks.

SuoNayi


------=_Part_295941_557780835.1325825447795--