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#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...