continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ingo Siebert <ingo.sieb...@cas.de>
Subject Contimuum 1.1 with MySQL 5.0
Date Tue, 04 Dec 2007 11:32:20 GMT
Hi,

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


But i get this problem.

58969 [http-9080-Processor24] ERROR JPOX.RDBMS  - Error thrown executing 
CREATE TABLE `JDOUSER`
(
     `USERNAME` VARCHAR(256) BINARY NOT NULL,
     `ACCOUNT_CREATION_DATE` DATETIME NULL,
     `COUNT_FAILED_LOGIN_ATTEMPTS` INTEGER NOT NULL,
     `EMAIL` VARCHAR(256) BINARY NULL,
     `ENCODED_PASSWORD` VARCHAR(256) BINARY NULL,
     `FULL_NAME` VARCHAR(256) BINARY NULL,
     `LAST_LOGIN_DATE` DATETIME NULL,
     `LAST_PASSWORD_CHANGE` DATETIME NULL,
     `LOCKED` BIT NOT NULL,
     `MODEL_ENCODING` VARCHAR(256) BINARY NULL,
     `USER_PASSWORD` VARCHAR(256) BINARY NULL,
     `PASSWORD_CHANGE_REQUIRED` BIT NOT NULL,
     `PERMANENT` BIT NOT NULL,
     `VALIDATED` BIT NOT NULL,
     PRIMARY KEY (`USERNAME`)
) ENGINE=INNODB : Specified key was too long; max key length is 765 bytes

Does someone use the current continuum version with MySQL 5.0?
Is there any workaround?

Cheers,

Ingo

Mime
View raw message