ErinO wrote: > Hi, > > I am trying to config the ActiveMQ 4.0 RC1 to use mysql, I tried both > mysql-connector-java-3.1.12-bin.jar and > mysql-connector-java-5.0.0-beta-bin.jar, and got the same error message: > > Failure was: CREATE TABLE ACTIVEMQ_ACKS(CONTAINER VARCHAR(250) NOT NULL, > CLIENT_ID VARCHAR(250) NOT NULL, SUB_NAME VARCHAR(250) NOT NULL, SELECTOR > VARCHAR(250), LAST_ACKED_ID INTEGER, PRIMARY KEY ( CONTAINER, CLIENT_ID, > SUB_NAME)) Message: Specified key was too long; max key length is 1024 bytes > SQLState: 42000 Vendor code: 1071
(250 + 250 + 250) * <default charset character width> = something greater than 1024 -- Christopher G. Stach II
