Hi! I'm using JBoss Messaging as a part of JBossESB 4.2.1GA, and I'm trying to switch from hsqldb to MySQL. I've followed instructions I've gotten in the JBossESB forum, but I have one final (?) problem, and was told to go ask you guys here..
I get this WARN statement when I start the server: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'juddidb.jbm_postoffice' doesn't exist I have manually created the juddidb-database before. After getting this warningmessage, I tried to create the jbm_postoffice-table manually as well. I executed the following command in MySQL: CREATE TABLE JBM_POSTOFFICE (POSTOFFICE_NAME VARCHAR(255), NODE_ID INTEGER, QUEUE_NAME VARCHAR(255), | COND VARCHAR(1023), SELECTOR VARCHAR(1023), CHANNEL_ID BIGINT, CLUSTERED CHAR(1), ALL_NODES CHAR(1) | , PRIMARY KEY(POSTOFFICE_NAME, NODE_ID, QUEUE_NAME)) ENGINE = INNODB And I got this in return: Error code 1071, SQL state 42000: Specified key was too long; max key length is 1024 bytes | Can anyone help me out with this? Regards, Haagen View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4101347#4101347 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4101347 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
