activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christopher G. Stach II" <...@ldsys.net>
Subject Re: error using MySql
Date Tue, 11 Apr 2006 18:37:54 GMT
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

Mime
View raw message