[JBoss Messaging] - Re: MQ migration help
by tnine
Thanks for the help. I've hit a bit of a snag, and I've found the solution. I changed the default datasource to use MySQL. Whenever I started jboss, I received this error
| 2008-04-16 09:02:40,752 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_POSTOFFICE (POSTOFFICE_NAME VARCHAR(255), NODE_ID INTEGER,QUEUE_NAME VARCHAR(255), CONDITION VARCHAR(1023), SELECTOR VARCHAR(1023), CHANNEL_ID BIGINT, CLUSTERED CHAR(1), ALL_NODES CHAR(1), PRIMARY KEY(POSTOFFICE_NAME, NODE_ID, QUEUE_NAME))
| com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDITION VARCHAR(1023), SELECTOR VARCHAR(1023), CHANNEL_ID BIGINT, CLUSTERED CH' at line 1
It appears that in mysql 5.0, some of the column names are reserved keywords or functions. I fixed it by manually escaping all the column names and executing the SQL myself.
| CREATE TABLE JBM_POSTOFFICE (`POSTOFFICE_NAME` VARCHAR(255), `NODE_ID` INTEGER,`QUEUE_NAME` VARCHAR(255), `CONDITION` VARCHAR(1023), `SELECTOR` VARCHAR(1023), `CHANNEL_ID` BIGINT, `CLUSTERED` CHAR(1), `ALL_NODES` CHAR(1), PRIMARY KEY(POSTOFFICE_NAME, NODE_ID, QUEUE_NAME))
|
This will be a pain when we start deploying this to different servers. Is there a configuration file somehwere I can change the create SQL?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4144341#4144341
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4144341
18 years, 3 months