MySQL and HyperSonicSQL

[cubeur]

I use JBoss 3.2 / Tomcat 4.1.24 on windows with Mysql 4.0.10-max-nt

I do not succed in totaly replace HyperSonicSQL by MySQL in JBoss (see other topic last day) so i try another way...

- i put the mysql-ds.xml in deploy/
- i modify standardjbosscmp-jdbc.xml in conf/
- i modify standardjaws.xml in conf/

and that's all....

after that i was able to start without ERROR, i suppose JMS in JBoss still using HypersonicSQL and i was able to deploy Entity Beans using mysql automaticaly...

my questions are...

- is it correct installation ?
- what about JMS (i will use it) in HyperSonicSQL ?
- is there a way to not use HypersonicSQL but MySQL ?

thx

Arnaud

[cubeur]

add-on... sorry

- i modify standardjbosscmp-jdbc.xml in conf/
by replace HypersonicSQL by MySQL

- i modify standardjaws.xml in conf/
by replace HypersonicSQL by MySQL


thx

[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