continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ingo Siebert <ingo.sieb...@cas.de>
Subject Re: Contimuum 1.1 with MySQL 5.0
Date Thu, 13 Dec 2007 08:06:53 GMT
Thank you!

I also needed to change the 'users' database to the latin1 charset.
It seems it's working fine now.

Cheers,

Ingo

ossi petz schrieb:
> Hallo
> 
> i have a very similar issue (etch mysql 5.0.32):
> 
> 2007-12-04 17:09:50,777 [main] ERROR JPOX.RDBMS  - Error thrown 
> executing CREATE TABLE `SECURITY_OPERATIONS`
> (
>     `NAME` VARCHAR(256) BINARY NOT NULL,
>     `DESCRIPTION` VARCHAR(256) BINARY NULL,
>     `PERMANENT` BIT NOT NULL,
>     `RESOURCE_REQUIRED` BIT NOT NULL,
>     PRIMARY KEY (`NAME`)
> ) ENGINE=INNODB : Specified key was too long; max key length is 765 bytes
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was 
> too long; max key length is 765 bytes
> 
> 
> in the jpox forums are quite some posts on this. it seems to be some 256 
>  > 255 issue in JDO specs as mysql is a little strict in lengths. the 
> workaround i found working is change the charset of the database from 
> utf-8 to latin1_general_ci
> 
> ALTER DATABASE `mvn_continuum` DEFAULT CHARACTER SET latin1 COLLATE 
> latin1_general_ci
> 
> 
> hope this helps :)
> regards
> 
> ossi
> 
> 
> 
> Ingo Siebert schrieb:
>> Hi Damien,
>>
>> i'm using MySQL 5.0.32. It's coming as a stable Debian package.
>>
>> I tried the other driver "com.mysql.jdbc.Driver", but it doesn't 
>> change anything.
>>
>> Maybe someone can look into my attached logfile to find a solution.
>> Any other idea? I think VAHCHAR(256) isn't more than 756 Bytes.
>>
>> Ingo
>>
>>
>> Damien Lecan schrieb:
>>> Hello,
>>>
>>>> i'm trying to use MySQL instead of Derby, because it is already
>>>> available at the server.
>>>>
>>>> I used this tutorial, but i use this JDBC driver: 
>>>> rg.gjt.mm.mysql.Driver
>>>>    http://docs.codehaus.org/display/CONTINUUMUSER/Continuum+on+MySQL
>>>> ...
>>>> Does someone use the current continuum version with MySQL 5.0?
>>>
>>> Yes, it works fine with Mysql 5.0.45.
>>> But class name for the official MySQL Connector/J driver is
>>> com.mysql.jdbc.Driver.
>>>
>>>> Is there any workaround?
>>>
>>> Try com.mysql.jdbc.Driver driver ?
>>>
>>>
>>> Damien Lecan
>>
>>
>>
> 


Mime
View raw message