配置jboss+mysql能正常建三个表然后下面的就出错了?

[cckylin]

Tables_in_ejbca
------------------
jms_roles
jms_subscriptions
jms_users

create three table?
server.log :
2004-06-09 20:08:59,646 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Resolving uncommited TXS
2004-06-09 20:08:59,656 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Could not create table with SQL: CREATE CACHED TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) ), got : java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CACHED TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINA"

我觉得数据已经连接上了,已经成功的建了三个表了,但接下来就出错?搞不明白是哪的问题希望成功配置过的人给些提示!

[wdllove]

谢谢你,能不能和你交流一下,msn:[e-mail]

我又改了几个配置文件,现在能行了!

[Leemaasn]

恭喜。。。

[realmud]

sql 语句里面的 cached 去掉

[wdllove]

但cached并不是我建的?这样去掉可以吗?

[wdllove]

CREATE_TX_TABLE = CREATE CACHED TABLE JMS_TRANSACTIONS ( TXID INTEGER, PRIMARY KEY (TXID) )
而且我查看日志上面能成功建表的也事宜 chahed的!这个字段表示什么?

[realmud]

http://www.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQJDBC3Persistence


create CACHED Table 是用来优化big table的