This content has been marked as final.
Show 1 reply
-
1. Re: JMS, HypersonicSQL and MySQL
cubeur Apr 19, 2003 3:13 PM (in response to cubeur)Allen Johnson give me the solution :))
In fact when you want to use MySQL alone without HypersonicSQL, JMS in JBoss try to create 2 tables, but fail because syntax errors...
use :
CREATE TABLE JMS_MESSAGES
(
MESSAGEID INTEGER NOT NULL,
DESTINATION VARCHAR(255) NOT NULL,
TXID INTEGER,
TXOP CHAR(1),
MESSAGEBLOB BLOB,
PRIMARY KEY (MESSAGEID, DESTINATION)
);
CREATE TABLE JMS_TRANSACTIONS
(
TXID INTEGER
);
to manually create those tables... and then move away HypersonicSQL... it works... :)
thx to Allen
Arnaud