Is there a technical or license difference between using:
com.mysql.jdbc.Driver
And
org.gjt.mm.mysql.Driver
?
Which are both in the Connector/J 3.1.10 jar.
Thanks.
-Chris
-----Original Message-----
From: Eric Weidner [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 11, 2005 6:40 PM
To: James-User Mailing List
Subject: mailstore issue with MySQL 4.1.13
James 2.2.0
MySQL 4.1.13
Connector/J 3.1.8a
I installed James 2.2.0 with MySQL 4.1.13, changed the mysql driver to be
com.mysql.jdbc.Driver, and added the Connector/J 4.1.8a jar in
james-2.2.0/lib. I am getting an error in the mailstore that says...
java.sql.SQLException: Specified key was too long; max key length is
1024 bytes
I found the following archive thread that describes this exact issue...
http://www.mail-archive.com/server-user@james.apache.org/msg04659.html
The user solved his problem by downgrading to MySQL 4.0.x. I don't have
that option.
Following through with Serge's suggestions, I ran the statement in MySQL
at the client command line...
mysql> create table users ( message_name varchar (200) not null,
repository_name varchar (255) not null, message_statte varchar (30) not
null, error_message varchar (200) null, sender varchar (255) null,
recipients text not null, remote_host varchar (255) not null,
remote_addr varchar (20) not null, message_body longblob not null,
message_attributes longblob null, last_updated datetime not null,
primary key (repository_name, message_name));
ERROR 1071 (42000): Specified key was too long; max key length is 1024 bytes
mysql>
If I change the statement above so that the messagename varchar length +
the repository_name varchar length = 341 (1024/3) or lower, then the
statement works.
Any thoughts on the problem and how to solve it?
Could I hack the sqlResources.xml and change the lengths so that they
equal 341 only? Does repository_name have to be 255? If that is a
valid option, what is the suggested ratio (200/191, 150/191, etc)?
Thanks,
Eric
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
