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

Reply via email to