[jboss-user] [JBoss Messaging] - Re: Unknown column 'NODE_ID' in 'where clause'

[gaohoward]

Hi, can you please check in your mysql database that the table JBM_TX, like this:


  | mysql> desc JBM_TX;
  | +----------------+----------------+------+-----+---------+-------+
  | | Field          | Type           | Null | Key | Default | Extra |
  | +----------------+----------------+------+-----+---------+-------+
  | | NODE_ID        | int(11)        | YES  |     | NULL    |       | 
  | | TRANSACTION_ID | bigint(20)     | NO   | PRI | 0       |       | 
  | | BRANCH_QUAL    | varbinary(254) | YES  |     | NULL    |       | 
  | | FORMAT_ID      | int(11)        | YES  |     | NULL    |       | 
  | | GLOBAL_TXID    | varbinary(254) | YES  |     | NULL    |       | 
  | +----------------+----------------+------+-----+---------+-------+
  | 5 rows in set (0.00 sec)
  | 

And see if there is a column named NODE_ID (as bove). If not, try to drop all JBM_* tables and restart the server. If problem still, check the mysql-persistence-service.xml in your deploy/jboss-messaging.sar if the table create statement are correct. If not, then you probably got wrong version of JBM.




View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4225786#4225786

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4225786