Modifying the hsqldb file is not recommended - you should use the mysql-persistence.xml
file instead. I noticed that JBoss AS 5.1.0.CR1 doesn't have this file yet, but you
can get it from
http://anonsvn.jboss.org/repos/messaging/tags/JBossMessaging_1_4_3_GA/int....
In that file you will see this line:
CREATE_DUAL=CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY (DUMMY)) ENGINE = INNODB
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4230185#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...