0 Replies Latest reply on Jun 9, 2004 8:23 AM by wdllove

    jboss 3.2.3 not starting ,i  use 3.2.4 can create tables but

    wdllove

      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