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