activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex_ynr <suburbanc...@gmail.com>
Subject Re: Couldn't get jdbcPersistenceAdapter working
Date Wed, 10 Oct 2007 12:44:15 GMT

Eh...

The "Specified key was too long; max key length is 1000 bytes" error came up
in my logs on creating the tables and I've seen it many times because I work
with utf-8 databases a lot so it jumped at me :P

I'm using Fuse 3.3 btw ...

Alex


Yuen-Chi Lian wrote:
> 
> Hi Alex,
> 
> Fantastic! I managed to get it working now. Do you mind to share how did
> you
> manage to find that out?
> 
> Anyway:
> 
> mysql> status
> --------------
> ...
> Server characterset:    utf8
> Db     characterset:    utf8
> ...
> 
> mysql> drop database activemq;
> Query OK, 2 rows affected (0.06 sec)
> 
> mysql> create database activemq char set latin1;
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> use activemq;
> Database changed
> mysql> status
> ...
> Server characterset:    utf8
> Db     characterset:    latin1
> ...
> 
> mysql> show tables;
> +--------------------+
> | Tables_in_activemq |
> +--------------------+
> | activemq_acks      |
> | activemq_lock      |
> | activemq_msgs      |
> +--------------------+
> 3 rows in set (0.00 sec)
> 
> On 10/10/07, Alex_ynr <suburbancore@gmail.com> wrote:
>>
>>
>> I just hit the same thing as well
>>
>> Specified key was too long; max key length is 1000 bytes is the error not
>> allowing the creation of ACTIVEMQ_ACKS
>>
>> You are probably using utf8/some other multibyte encoding as the
>> collation
>> in your database....
>>
>> Switch it to latin1 or ASCII... The varchar fields that the key is
>> composed
>> of add up to less than 1000 characters but with a multibyte encoding the
>> key
>> length is over 1000 bytes.
>>
>> That's the case in my mysql setup here anyway.
>>
>>
>>
>> Yuen-Chi Lian wrote:
>> >
>> > Hi Glen,
>> >
>> > I still haven't got this working. I noticed that ActiveMQ was able to
>> > create
>> > the activemq_locks and activemq_msgs tables but activemq_acks is
>> missing
>> > in
>> > my `show tables;` list. The same behaviour is reproducible by dropping
>> the
>> > database and start ActiveMQ on a clean one.
>> >
>> > Any idea?
>> >
>> >
>> > On 10/7/07, Yuen-Chi Lian <yuenchi.lian@gmail.com> wrote:
>> >>
>> >>
>> >> Hi Glen,
>> >>
>> >> I have only one MySQL server instance running at that time (on port
>> >> 3306).
>> >> And the username/password used in the configuration is "root":"".
>> >>
>> >> I have tried, by specifying an invalid (non-existing) database name, a
>> >> different error will be thrown instead.
>> >>
>> >> My Windows machine is not around and I'm with my Ubuntu right now. I
>> will
>> >> see if I can reproduce the problem, otherwise, I will have to come
>> back
>> >> here
>> >> on Monday or Tuesday.
>> >>
>> >> Thanks for your reply.
>> >>
>> >> Cheers,
>> >> Yuen-Chi Lian
>> >>
>> >>
>> >> Glen Mazza-2 wrote:
>> >> >
>> >> > Am Freitag, den 05.10.2007, 02:20 -0700 schrieb Yuen-Chi Lian:
>> >> >
>> >> >> Hi all,
>> >> >>
>> >> >> This is strange. I have poked around Google and the mailing list,
>> but
>> >> >> couldn't really find the exact solution to my problem.
>> >> >>
>> >> >> I am trying to enable jdbc persistence and I am getting the error
>> >> below:
>> >> >>
>> >> >> to start ActiveMQ JMS Message Broker. Reason: java.io.IOException:
>> >> Failed
>> >> >> to
>> >> >> get last broker message id:
>> >> >> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
>> >> >> 'activemq.activemq_acks' doesn't exist
>> >> >
>> >> > Normally the reason for an exception like this is rather
>> >> > unambiguous--the database driver cannot find the database table
>> >> > "activemq_acks" within the activemq schema, either (a) because it
>> does
>> >> > not exist or (b) the username/password you are supplying for that
>> >> > database does not have access rights to that table.  Can you use an
>> >> > external query tool to make sure the table exists (pay attention to
>> >> case
>> >> > sensitivity), and that the username you have accessing it can select
>> >> > from that table?  Also, how many mysql installations do you have on
>> >> your
>> >> > machine?  That could be another problem.
>> >> >
>> >> > HTH,
>> >> > Glen
>> >> >
>> >> >
>> >> >> 1. I have MySQL JDBC driver in my classpath,
>> >> >> mysql-connector-java-5.0.7-bin.jar
>> >> >> 2. I have tried making things "clean" by removing my
>> >> >> ${activemq.home}/activemq-data
>> >> >> 3. I have tried uncommenting the mysql-ds in the default config
as
>> >> well
>> >> >> as
>> >> >> using my own simple one:
>> >> >>
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/Couldn%27t-get-jdbcPersistenceAdapter-working-tf4574013s2354.html#a13079934
>> >> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >
>> >
>> > --
>> > Cheers,
>> > Yuen-Chi Lian
>> >
>> > "I do not seek; I find." - Pablo Picasso
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Couldn%27t-get-jdbcPersistenceAdapter-working-tf4574013s2354.html#a13134400
>> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>>
>>
> 
> 
> -- 
> Cheers,
> Yuen-Chi Lian
> 
> "I do not seek; I find." - Pablo Picasso
> 
> 

-- 
View this message in context: http://www.nabble.com/Couldn%27t-get-jdbcPersistenceAdapter-working-tf4574013s2354.html#a13135021
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message