Hi Serge,
That was quick! I have been reading thru the mm JDBC driver mailing
lists and it looks like a known problem with this driver (currently the limit
for a Blob is 1 Mb so this exception appears with attach files bigger than 1Mb).
Take a look at this message where this is discussed:
http://db.geocrawler.com/mail/msg.php3?msg_id=4746024&list=193
By the way, the www.caucho.com driver is experimental, so not an option.
Thanks,
J. Carles
------------------------------------------------------------------------
DROP DATABASE James;
CREATE DATABASE James;
use James;
CREATE TABLE Message (
message_name varchar (200) NOT NULL PRIMARY KEY,
repository_name varchar (200) NOT NULL ,
message_state varchar (30) NOT NULL ,
error_message varchar (200) NULL ,
sender varchar (100) NOT NULL ,
recipients text NOT NULL ,
remote_host varchar (100) NOT NULL ,
remote_addr varchar (20) NOT NULL ,
message_body longblob NOT NULL ,
last_updated datetime NOT NULL
);
-------------------------------------------------------------------------
On Thu, 15 Feb 2001 08:17:34 -0500
"Serge Knystautas" <sergek@lokitech.com> wrote:
> Can you send me a structure of your tables? I know at one point the mysql
> script had one column type that was off, and while I thought it was
> corrected, I wouldn't be surprised if the incorrect version is still out
> there. Thanks.
>
> Serge Knystautas
> Loki Technologies
> http://www.lokitech.com/
> ----- Original Message -----
> From: "Joan Carles Núñez" <joancarles@indibil.com>
> To: <james-dev@jakarta.apache.org>
> Sent: Thursday, February 15, 2001 8:10 AM
> Subject: Mysql problem with attached files: Interbase?
>
>
> > Hi List,
> >
> > I encountered the following problem with the mm JDBC driver for Mysql:
> >
> > java.lang.ArrayIndexOutOfBoundsException
> > at java.lang.System.arraycopy(Native Method)
> > at org.gjt.mm.mysql.Buffer.writeBytesNoNull(Buffer.java:352)
> > at
> org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java:291)
> > at com.workingdogs.town.Record.saveWithInsert(Record.java:1727)
> > at com.workingdogs.town.Record.save(Record.java:1612)
> > at com.workingdogs.town.Record.save(Record.java:1456)
> > at com.workingdogs.town.Record.save(Record.java:1419)
> > at
> org.apache.james.mailrepository.TownSpoolRepository.store(TownSpoolRepositor
> y.java:188)
> > at org.apache.james.James.sendMail(James.java:298)
> > at
> org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java:317)
> > at org.apache.james.smtpserver.SMTPHandler.run(SMTPHandler.java:121)
> > at org.apache.avalon.utils.recycle.pool.Worker.run(Worker.java:113)
> >
> > This implies that I either tinker with the JDBC driver to deal with large
> blobs or
> > use some other database (I didn't try www.caucho.com's JDBC driver...).
> > I am considering the use of Interbase Super Server. Before I set myself to
> do
> > this, does anyone know a workaround the Mysql JDBC limitation?
> > Using a database with transaction support like interbase would add extra
> overhead
> > to the machine that hosts James...
> > Is migrating database a matter of finding the right column types for the
> 'Message' table?
> >
> > Thanks,
> >
> > Joan Carles Núñez
> >
> > EBS S.L.
> > Spain
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: james-dev-help@jakarta.apache.org
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-dev-help@jakarta.apache.org
|