Mailing-List: contact users-help@activemq.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@activemq.apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <20009472.post@talk.nabble.com>
Date: Thu, 16 Oct 2008 01:38:51 -0700 (PDT)
From: tricpod <tricpod@googlemail.com>
To: users@activemq.apache.org
Subject: mysql 4.1 ACTIVEMQ_ACKS primary key length
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Hi,
I  have to install ActiveMQ on a mysql 4.1 database. 
If I create ACTIVEMQ_ACKS with 
CREATE TABLE ACTIVEMQ_ACKS (
    CONTAINER varchar(250) collate utf8_general_ci NOT NULL,
    SUB_DEST varchar(250) collate utf8_general_ci default NULL,
    CLIENT_ID varchar(250) collate utf8_general_ci NOT NULL,
    SUB_NAME varchar(250) collate utf8_general_ci NOT NULL,
    SELECTOR varchar(250) collate utf8_general_ci default NULL,
    LAST_ACKED_ID int(11) default NULL,
    PRIMARY KEY  (CONTAINER,CLIENT_ID,SUB_NAME)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
 I got a Error Code : 1071 Specified key was too long; max key length is
1024 bytes
There was written before to it should be safe do decrease some field to 128.
What kind of data is written to CONTAINER, CLIENT_ID and SUB_NAME?
To create the primary key I have to decrease all 3 to varchar(113) (3 Byte
UFT-8*3=1017). 
What is the best way to get this table? All fields same size? Don't use key?

kind regards Thomas

-- 
View this message in context: http://www.nabble.com/mysql-4.1-ACTIVEMQ_ACKS-primary-key-length-tp20009472p20009472.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.