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/integration/AS5/etc/server/default/deploy/mysql-persistence-service.xml.
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#4230185 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4230185 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
