Re: Couldn't get jdbcPersistenceAdapter working

2007-10-10 Thread Alex_ynr
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

Re: Couldn't get jdbcPersistenceAdapter working

2007-10-10 Thread Yuen Chi Lian
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> creat

Re: Couldn't get jdbcPersistenceAdapter working

2007-10-10 Thread Alex_ynr
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 t

Re: Couldn't get jdbcPersistenceAdapter working

2007-10-09 Thread Yuen Chi Lian
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 1

Re: Couldn't get jdbcPersistenceAdapter working

2007-10-06 Thread Yuen-Chi Lian
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

Re: Couldn't get jdbcPersistenceAdapter working

2007-10-06 Thread Glen Mazza
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

Couldn't get jdbcPersistenceAdapter working

2007-10-05 Thread 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: = Testi