The problem is the max key length.
Look at this: http://bugs.mysql.com/bug.php?id=7509
You probably have a multibyte default charset (utf8) and it double the
key size.
I would change the sqlResources.sql decreasing the repository_name
column length to 50.
You can find this configuration twice (MailRepository / SpoolRepository).
Let us know if this fix.
Stefano
-=Kobye=- wrote:
hi,
when I config james with mysql5.0(have change the driver to 3.12)
there is an error.
Caused by: java.sql.SQLException: Specified key was too long; max key length
is
1024 bytes
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(
what about the reason?
how to solve it?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
