It seems that this bug still occurs for db database:
2008-03-25 10:55:54,493 [http-0.0.0.0-28080-1] ERROR JPOX.RDBMS - Error
thrown executing CREATE TABLE `SECURITY_RESOURCES`
(
`IDENTIFIER` VARCHAR(256) BINARY NOT NULL,
`PATTERN` BIT NOT NULL,
`PERMANENT` BIT NOT NULL,
PRIMARY KEY (`IDENTIFIER`)
) ENGINE=INNODB : Specified key was too long; max key length is 767 bytes
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was
too long; max key length is 767 bytes
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
I add the patch to the JdoFactory for users role-hint and it works. I
think that you can reopen the bug ?
Benoit
