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"
table JMS_MESSAGES dont create! why? thanks